Parameterised query in vfp9
HI:
A vfp9 form has 2 buttons. Both identical except that one pulls data with a default date of today, the other allows the user to enter a date using a parameterised query from a remote view. The data source is the same.
Both work fine in vfp. No problem at all
Then I build the executable. The executable launches automatically. Both buttons work.
Then I run the executable from explorer or a shortcut on the desktop. The parameterised query returns no data!The default button does.
So yes, if I build an executable and it runs directly after build it works. If I then close vfp and run the executable it does not!
Does anybody know of this? Thanks!
A vfp9 form has 2 buttons. Both identical except that one pulls data with a default date of today, the other allows the user to enter a date using a parameterised query from a remote view. The data source is the same.
Both work fine in vfp. No problem at all
Then I build the executable. The executable launches automatically. Both buttons work.
Then I run the executable from explorer or a shortcut on the desktop. The parameterised query returns no data!The default button does.
So yes, if I build an executable and it runs directly after build it works. If I then close vfp and run the executable it does not!
Does anybody know of this? Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
And you have told me about British dates before!
That does it. I'm emigrating.It is less stressful!