Solved

Parameterised query in vfp9

Posted on 2010-08-27
2
502 Views
Last Modified: 2012-05-10
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
Comment
Question by:ClaytonGlass
2 Comments
 
LVL 42

Accepted Solution

by:
pcelba earned 250 total points
ID: 33539747
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
 

Author Closing Comment

by:ClaytonGlass
ID: 33539829
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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to populate data from foxpro table to pdf file 14 91
Data Import from a CSV file 8 497
Import CSV Files 5 1,188
Controlling the ''Executing remote" message when using SQLEXEC() 5 135
Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question