Search results for query: *

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...

The only suggestion I have is to use the RemoveObject() method of the VSPE's parent control to first remove the control before you close the form.

To everyone's point that you have to have a table/cursor that drives the page output. Using variables would cause every page printed to have the same value -- no point to print more than one page. If each page is supposed to have different values, you could create two cursors that contain 150...

The variables do not have to be Public/Global. I do not use global variables at all. I do have memory variables referenced in reports. In the form method that will call the report, create the variables as LOCAL variables and they will be in scope when the report is run. You cannot reference...

Glad to see that you got it working. I wrote a custom timer class based on the Win32 API. See attached. The DeclareWinAPI.prg should be added as a library: SET LIBRARY TO DeclareWinAPI.prg ADDITIVE The class works pretty much the same way as the VFP control.

What is the source of the Polish text being displayed? If it is a cursor (from a SELECT-SQL command) and bound to the control, then the table CodePage should be set to 1250. By default, it will be set to VFP default value. In the create command for a cursor you can set the CodePage value...

iswithzhz-- I am curious as to your use of ExcelGrid. From the demo, it opens the xlsx file and displays in the screen -- what is the difference than using directly Excel to view the file? Can VFP interact with the cell values directly in ExcelGrid by reading the cell values or writing new...

Take a look at https://www.xpdfreader.com/ -- there are some tools for PDF extraction to text. I have not used them so I can't give any insight to how well they work.