Gambas ONE

OK, with this code:- Public Sub Form_Open() Dim hFrame As Frame Dim i As Integer For i = 0 To 4 With hFrame = New Frame(Me) .Name = "A" & i .X = (i * 60) .Y = 50 .W = 50 .H = 50 .Text = "B" & i End With Next End How best can I find the .text value of one of the frames? At...

I have a number of frames on a form which are generated dynamically, to recover information about a specific frame I do this: Dim hCtrl As Control For Each hCtrl In Me.Controls If hCtrl.Name = Last.Name Then do things! Endif Next Having set the frame's .Name to a unique value. Is there a better way ...

Thanks for that, struggling to translate your query to mysql syntax.
However, there would be a problem because there could easily be several maximum temperatures with completely different dates.
I need to re-think this.
Thanks again

I have a mysql table of temperature readings.
How can I find the date of MAX(Temperature) and the date of MIN(Temperature)?
My table looks like this:-
EpochDate as String
ReadingDate as Date
Temperature as Float
Pressure as Float

Thank you gbWilly, panic over. I think a visit to the opticians might be in order!

ORDER BY date seems not to be working. hResult = hConn.Find("transactions", "ORDER BY TransDate") produces:- 27/01/0022 00:00:00 27/01/0022 00:00:00 31/01/0022 00:00:00 31/01/0022 00:00:00 01/12/2021 00:00:00 01/12/2021 00:00:00 01/12/2021 00:00:00 01/12/2021 00:00:00 01/12/2021 ...

Thanks Bruce-all is well now.
Bill

Looking very closely, its possible that the console has shrunk to zero height!
Right click on that area produced a message saying that the console is set to 'invisible', selected set to 'visible' and console now shows.

No 'Print' shows nothing. I see a post by BruceSteers on 05th February 2023 where he says:- Find something like the following text in $HOME/.config/gambas3/gambas3.conf Code: Select all [FMain] Geometry=[12,59,1219,849,0,0] panProject=[False,293,True,False] panProperty=[False,265,True,False] panDebu...

Thank you cogier, gambas is running again.
ide console still missing though.
F11 does nothing.
Any ideas?