Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 548
  • Last Modified:

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!
0
ClaytonGlass
Asked:
ClaytonGlass
1 Solution
 
pcelbaCommented:
So it simply means your executable does not contain everything it needs for successful run.

You should check the configuration (CONFIG.FPW and other settings). Are you sure the SET DATE is correct in EXE? Did you try to enter both AMERICAN and BRITISH date format on input?
0
 
ClaytonGlassAuthor Commented:
Thank you so much!
And you have told me about British dates before!
That does it. I'm emigrating.It is less stressful!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now