Search:

Probably should've - but I'm already bats.

Hi Sture -

The client migrated it - I believe with whatever driver came with 19.1. What's strange is that on my machine, the table explorer does not show the recnum column - just the client's.
...

This is the other way 'round & MS SQL (Express). DF Shows recnum, SSMS does not.

My MySQL experience is with the Mertech driver & in 5+ years never had an issue adding/updating fields through the...

Hi -

Df19.1 - embedded converted to MS SQL via studio tools. There is a system file (single record) that in the DF Table Explorer shows Recnum. However, in SQL, there is no Recnum column. DF...

Hi Phil -

A customer prefers a combo with Y and N ovr a checkbox - so this code is all over their system. Y always shows first.


Object oWSComboForm1 is a ComboForm
...

Actually, it's a boolean property - hence the "pb". I'd misremembered that what it does is to show/hide a form that let's the user select a particular location.

My own code - the property holds a Yard Location used to limit the SL to records for just one location. I should've removed that line.

And - each time the SL is fired up, it checks the property...

yup - what Michael said - set wherever you need the non-default - otherwise it'll use the default.

Hi -

This is the 'tother way 'round - but the same idea. Put this in the calling form:



Procedure Prompt_Callback Handle hoPrompt
Forward Send Prompt_Callback...

I can confirm that Stephen's workaround does indeed work.

Now remembering the old thread(s) is not something I can help on. What was your name again?

Have you tried the (old) Object_Shadow_State? Set to True to disable. In 19.0 neither works for me (Object_Shadow_State or Enabled_State).

There's also pbNoEnterReadOnly - set to True to disable...

This might (or might not) be appropriate here - but y'all know I don't always filter... Besides, it's Friday afternoon!


https://www.youtube.com/watch?v=mYKWch_MNY0

Different strokes... I find I want it True most of the time. :)

We've all been bitten by it :)

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.