[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 551
  • 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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