Search:

I get it - that's where the Mertech command is excellent as it's precisely the next line after the Exec - though less informative on SPs than on selects/Updates/Inserts - but I think that's a MySQL...

cConnection has an event called Error_Report - does that maybe do it? The help is not exactly full of info on what it does (sorry Dennis! ;))

I'm afraid I'm more familiar with the Mertech driver...

You can check out any time you like, but you can never leave...

Thanks Vincent. I figured it was something like that, but thought it'd be nice if it could handle the blank date situation. No big deal, as I have a workaround.

While this is probably more of a...

If you are in non-edit mode - do NOT do this when the grid is editable! - you can type a value & press any of the find keys. If the column is in the chosen index, it should find it.

This may have already been reported, but I'll do it anyway ;)

DF 20.0.7 DAW SQL Driver MS SQL Express


Move (dtNow - dtCalibrated) to tsDiff


dTNow is today & dtCalibrated is "blank" -...

It's all aboot the fun... A Candahoodian correcting an Amurrican on English is definitely humoUrous.

But my 'murican is real good.

:p

Your English is WAY better than my Italian. :)

Do you have a field named "ref"? That's what's giving the error - that the default value for it is invalid.

Hi -

I think you'll see that the DF side thinks the 3 red arrow ones are dates & the green arrow is a datetime.

I think you'll find that changing the DF type from Date to DateTime will cure the...

I agree with Chuck. Pick a processor that does all the entry/storage on their system & only returns a confirmation code so you know it went through OK.

But agile has such great jargon! Makes one sound really cool dontcha know?

OK, back to the scrum so I can get ready for the sprint. ;)

Eval?

Move (Eval(table.field)) to...

Or Get (Eval(table.field)) of ...

Hi Jim -

I think we need more info. You want to change the application? The view? forms? Yellow text for labels, for entry?

3.2 will compile & run 2.3 code - so it should work, no?

So - in later versions it is safe to "Move (CurrentDateTime()) to dDate" - where dDate is a date variable?

I don't have a specific issue - I simply stopped doing it & changed existing code back to...

Maybe it's changed, but in 19.0, there were issues using CurrentDateTime with dates & it was suggested to only use it with DateTime variables.

??

Didn't know it was obsolete - but yes - it always works - but if you need time in the same field you have to write code to build a datetime.

Thanks to both Samuel & Edgard. I will take the easy way out & since this is a recnum table (who know?) - I'll just add that to the index.

It would be nice to get a definitive answer though - as...

Thanks Samuel. I too made the same change & got the same results. Maybe there's some other setting?

Roughly 30% of the values have 00 for the seconds & none have milliseconds - though the...

Can anyone verify that it's local settings that affect the precision of datetimes? If so - is there any way I can ensure a certain precision?

It seems something has changed on machines that...

No, I haven't in detail. I did check on the server, but it saves seconds - it's just some user machines - which are on both VDI's and actual Win10 boxes. Since it does save seconds on the server,...

I don't know either. I'm just going by what the help says + how many are saved with no seconds. All are saved with "Set Field_Changed_Value Field SBS_FUP.FollowUpTime to (CurrentDateTime())" in...

Hi -

DF 19.0, MySQL, Mertech Driver

I am using a DateTime as part of an index & it seems that some computers recently started "not saving" the seconds portion. So - the DateTime is 05-02-2022...

I certainly did not mean to make light of this - as it is an issue that would be nice to get squared away. Seems DR handles this differently than DF.

In addition, DR has a same number variable...