Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ggreen61

    Change words (language) in button set

    If you want to support multiple languages, take a look at Steven Black's International Toolkit: http://www.stevenblack.com/intl/
  2. ggreen61

    html editor

    I wrote a Richtext editor as shown: You can find the source code at: https://github.com/ggreen86/VFP-Editors Look for the classlib GKKTextEdit.vcx. There are multiple classes and images that are needed (all found at the link).
  3. ggreen61

    Foxypreviewer commercial license

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

    Progress of report being processed

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

    .dbf files mysteriously gone missing (or being deleted)

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

    Report layout differs when running

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

    .dbf files mysteriously gone missing (or being deleted)

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

    Report not showing selected records

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

    Opening and reading from a binary file larger than 2GB

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

    how to send Esc code to Epson LQ-590II for draft, courier, etc.

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

    sorting

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

    Command History not saved if VFP closed by shutdown

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

    Copy fields from one table to another

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

    Adding and moving images in a running form

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

    Switching between forms in an application

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

    SQL query syntax

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

    Switching between forms in an application

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

    VFP 'unresponsive' for 60 secs when closing MSCOMMLib.MSComm

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

    Report with no Data Environment

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

    Report with no Data Environment

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

Part and Inventory Search

Back
Top