Gambas ONE

aaw bless ya guys to be fair i had to recognise myself :lol: Ben asked on the mailing list for any contributors to add themselves to the contributors file. I deliberated for a bit thinking I hadn't done much but tons of bug reporting (tons and tons of bug reporting). So i added myself and listed the...

Well then, I’m somehow back to where it all began. Using key.code & Key.[names] was something I already had tried, but I didn’t know why it went wrong with certain keys. Now I do. Too bad that my latest idea can’t be used on every computer, because it really works for any key on my computer. This i...

Good morning - or which part of the day it is where you live. I have been pretty busy testing your suggestions and when one sort of combines some of them even an amateur like self can find a very satisfying solution. Keypoint was this little code from Steve : Public Sub Form_KeyPress() Dim varKey A...

Also there is this way. (Using Key["Return"] method not Key.Return constant)

Select Key.Code
   Case Key["Return"], Key["Enter"]
   Print "Enter or return was hit"

  Case Key["F1"]
  Print "F1 was hit"

End Select

AltGrKey does not work. (it broken in gambas) the right alt key is actually called ISO_Level3_Shift (the Windows keys are called Super) It's a pain dealing with it it's hex value with gtk will be 0xfe03 (as per keysymdef.h) If Key.Code = &hfe03& with qt it's integer value is 16781571 (annoyingly a d...

bill-lancaster wrote: ↑

Wednesday 14th April 2021 7:04am

Time(mysql!DateTime) also shows British Summer Time

yep , like i said in my first reply , date functions (Time() and Date()) do local conversion.

Hang on, it should do it anyway.

You have to set GridVew1.Mode property to single or multiple

GridView1.Rows[GridView1.Row].Selected = True

bill-lancaster wrote: ↑

Monday 12th April 2021 4:16pm

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.

You're welcome.. there's always a way

Thanks Bruce, still confused though! In gambas print date(), time() all show the right value. My system clock is correct Mysql locale is shown as "System" I'm thinking its really an sql matter Date value is stored as a UTC value (not locally conveted) Using Date() and Time() do the local string con...