Search found 442 matches

by BruceSteers
Thursday 15th April 2021 2:29pm
Forum: General
Topic: Trapping Return - Serious problem ?
Replies: 16
Views: 222

Re: Trapping Return - Serious problem ?

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...
by BruceSteers
Thursday 15th April 2021 9:03am
Forum: General
Topic: Trapping Return - Serious problem ?
Replies: 16
Views: 222

Re: Trapping Return - Serious problem ?

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...
by BruceSteers
Wednesday 14th April 2021 11:27pm
Forum: General
Topic: Trapping Return - Serious problem ?
Replies: 16
Views: 222

Re: Trapping Return - Serious problem ?

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
by BruceSteers
Wednesday 14th April 2021 11:07pm
Forum: General
Topic: Trapping Return - Serious problem ?
Replies: 16
Views: 222

Re: Trapping Return - Serious problem ?

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...
by BruceSteers
Wednesday 14th April 2021 8:07am
Forum: General
Topic: mysql and British Summer Time problem
Replies: 8
Views: 119

Re: mysql and British Summer Time problem

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.
by BruceSteers
Monday 12th April 2021 10:40pm
Forum: General
Topic: [Solved] GridView Highlight selected row
Replies: 3
Views: 96

Re: GridView Highlight selected row

Hang on, it should do it anyway.

You have to set GridVew1.Mode property to single or multiple
by BruceSteers
Monday 12th April 2021 10:39pm
Forum: General
Topic: [Solved] GridView Highlight selected row
Replies: 3
Views: 96

Re: GridView Highlight selected row

GridView1.Rows[GridView1.Row].Selected = True
by BruceSteers
Monday 12th April 2021 5:47pm
Forum: General
Topic: mysql and British Summer Time problem
Replies: 8
Views: 119

Re: mysql and British Summer Time problem

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 :)
by BruceSteers
Monday 12th April 2021 12:32pm
Forum: General
Topic: mysql and British Summer Time problem
Replies: 8
Views: 119

Re: mysql and British Summer Time problem

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...
by BruceSteers
Monday 12th April 2021 9:54am
Forum: General
Topic: mysql and British Summer Time problem
Replies: 8
Views: 119

Re: mysql and British Summer Time problem

A date-time value is converted from British Summer Time to UTC when writing a mysql record. hResult = hConn.create("date_test") hResult!DateTimeCreated = Now hResult!DateTimeEvent = Date(2021, 4, 16, 9, 35, 00) The resulting time values in the mysql db are 1 hour less. This is probably a mysql matt...