Search results for query: *

I have a query that uses a remote view. I need to check that all the data is updated before beginning some batch processes. I run the query and check the date on each record, if it has not been updated yet, then the program loops back and reruns the query in ten minutes. The problem is after...

I am guerring a remote view to test if tables are updated. I run the query and test some file parameters to see it they are ready to download. If they are not updated the program is supposted to wait 10 minutes and requery the table to check the parameters again. When I rerun the query it...

I have launched Outlook from within VFP and want to add data entered on a form as the Body of the Outlook eMail. Example: Name: Frank Emp Number: 4999 Meno Box: I want to go here tomorrow I want the above fields enter on a VFP form to appear on an eMail as follows...

I have an application that I want to open outlook in the background and when a command button is pressed it will send an eMail to a particular person.

Using the Setup Wizard I built a set of installation disks to install my application on other desktops. I used the same proceedure many time in the past with great success. This time when I run the Setup it runs fine until it tries to open the ODBCSTF.DLL. I just reinstall VFP6.0 and it...

I tried that, I set the print when to the same expression as I used to create the balance on each line. It applied the logic to the last line of the detail above, if there were three lines 10,-20,0 and the print when said <>0 it would not show -10(the sum of 10-20+0) because the last line of...

I have created a report which displays the excess inventory for a part number(it is a calculatrion of three fields), each part number can have several lines. I created a Group Band on Part Number, the calculation is set to sum and it resets after each change in part number. The problem is I...

Here is the Code: Report Form I:\programs\issbu\reports\project_billing_issbu to printer prompt preview I'll check the closable properity of the form calling the report. I'll also try and use the _pageno system variable. Thanks Bob Fisk xk120se@aol.com

Jon Thanks, the problem is the [X] button on the preview panel is not enabled so the user can't click on it. How can I enable tghe [X] button on the preview panel? I understand the RANGE X,Y format, but can I load two vaiables x,y with value from the print preview toolbar(goto page button)...

This is a two part question concerning Print Preview Toolbars: 1) I'm using a short cut menu to run a report with preview at the end. This launches a preivew window containing the print preview toolbar for you the view, navagate, print or close the report. If you click on the...

I am running an application on our network server. When someone logs onto the application I want to store his/her login initials in a file so I know who is currently using my application. The problem is I don't know how to get to the Window API that stores the initials.

Thanks, great job!!!

Copy to (putfile()) type xls works, but when I choose to cancel without saving I get an error &quot; OLE error code 0x80030003 Unkown COM status code&quot; What is this error, how do I fix it?

How can I let the user of my application save a small data set of a table into xls format (COPY TO) and then direct the xls file to a directory they choose? When I use Copy To I will default the file name/path. I want the user to be able to rename and save the xls file to anywhere they choose.

Here is the SQL select statement that builds the view: SELECT *; FROM DSSCOM.TRANSACTION_DETAIL Transaction_detail; WHERE Transaction_detail.CATEGORY_ID = 'X1'; AND Transaction_detail.INV_PROD_FAM_CD <> 'D1'; OR (Transaction_detail.CATEGORY_ID = 'C1') (This statement creates a 275m...

Can anyone explain why the cursor created by a remote data view is 275M in size when the table that results from a query of that view is only 6.1M. Next how can I close this 275M cursor after the query builds the table without closing the project?

How can I access data stored in the Windows Registry?&nbsp;&nbsp;I found Registry.Vcx in the Components Gallery of VFP but I can't get it to work.&nbsp;&nbsp;Help!!!<br><br>Bob