Gambas ONE

This seems to do the trick. Public Sub gdvMaster_Sort() Dim sOrder As String If gdvMaster.Columns.Ascending Then sOrder = gdvMaster.Columns[gdvMaster.Columns.Sort].Text Else sOrder = gdvMaster.Columns[gdvMaster.Columns.Sort].Text & " DESC" Endif hResultMaster = hConn.Find("master&...

I've been using the data event in gridview, the data source is a mysql database. It all works fine. When changing the sort order of a column in the database result, how is the Data event triggered? Public Sub Button1_Click() hResultMaster = hConn.Find("master", "ORDER BY Narrative&quo...

I like the not so dirty solution, thanks Bruce and Cogier.

Since I'm looking at day values of a date,
Select Case day_number MOD 10
Case 1
st
Case 2
nd
Case 3
rd
Case else
th
End Select

I guess this will do it, a bit messy though

Is there an available method to convert say "5" to "5th" or "23" to "23rd"?

OK, got it!

I can't see how to do this, it's probably very simple. I have a picture box with a thumbnail of a photo. I want to place a copy of the file in a particular directory using drag n' drop I don't want the drag.icon to be the picture because they are large images. How best to show just a "+" i...

Time(mysql!DateTime) also shows British Summer Time

Either the value is adjusted before writing to the db or the adjustment is made when reading the db.
I favour the latter, CDATE() displays the correct (local) time value.
Thanks again.

Yes, you're right, in fact the time values in the sql database are correct, its when they are displayed as a string that the problem occurs. So, when displayed in gridview (gdvTest),or in string Svar the time values are wrong. hResult!DateTimeEvent (an sql date-time field) is correct when printed to...