Recent content by ggreen61

The 2.99 version of FoxyPreviewer is free to distribute with your applications. The 3.x version is not and must be licensed.

For the report you would need a custom report listener class for the report engine. I think there is an example in the foundation classes/examples that comes with VFP9. Also, Doug Hennig has published a PDF on report listener classes that is very good.

There can be problems with renaming a bak file to a dbf file. If the dbf is part of a database (DBC) then the database will contain the structure definition to the dbf. The dbf backup file is usually created when you made a structural change. So, these may not match any longer and you could...

I would suggest making a copy of your report first. Then hack the report by opening via USE reportname.frx. Then manually set the hpos value to the same value for the objects that you want to be all aligned.

In order to prevent a user from being able to browse to a share that contains the tables, I have used the following strategy: //sharename/protectedfolder/sharedfolder The protected folder user rights are not granted to the business users. The sharedfolder user rights is granted to the...

Try for your select statement: SELECT * FROM PLANPROD WHERE ALLTRIM(UPPER(PSTAT))=="PENDENTE" INTO CURSOR curPedProd

You might be able to speed up the VFP version by increasing the BLOCK size value. Instead of 8192, you might try sizes greater than 10 megabytes... This would be less reads performed. I believe that when comparing two string values, VFP will stop comparing when a byte is different between the...

What is your Windows printer driver -- I think you have to use a Raw printer driver.

Create the following index on your field that contains the grade value (where grade is the field name): INDEX ON PADL(ALLTRIM(grade), 10, '0') TAG grade Now use this index to set the order for display. If you want to select the records then use the same PADL() expression in the ORDER BY clause.

When the machine is rebooted that is running VFP IDE, the VFP running process is terminated by the OS. This is not an orderly shutdown that would allow the command history to be saved. You would need to use a method as described above that the user can trigger to save the contents to a file...

What if you select the two tables separately in a UNION clause? Use place holders in the missing fields for the first table.

Instead of using a textbox to determine the image, you could provide a lower section of the form that provides the images that are available. This image list could be scrollable and a user would select an image and then drag to the location desired. I ditto the use of a table to manage the...

My solution to the problem of RLOCK of a record by one user that another user needs access to, is to not use RLOCK. Instead, I have a table for managing the locks - tablelock.dbf. When a user selects a customer, supplier, etc. record to be edited, I add the record Id to the tablelock record...

I use the following code to do a similar select. I use NVL() function when the values are to be displayed. SELECT inv.invoicedate, inv.duedate, inv.billto, inv.stataxes, inv.loctaxes, inv.cittaxes, inv.shipping, inv.totaldue, inv.amtpaid, inv.memberid, mbr.membername, ; itm.price...

I have a similar application with a tab interface for selecting between forms: The first row allows the user to select between different tab groups. The second row allows a user to open a form into the group's tab interface. When the user selects a command button to open a popup child...