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!

Register Log in
  • Congratulations Rhinorhino 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. EdLeafe

    Problem with NULL fields

    VFP has the NVL() function that will handle this for you. Try using: STORE NVL(rs.Fields(33).value, "NO DISPONIBLE") TO import33 I'm also assuming that 'import33' is a memory variable and not a field. If it were a field, you need to use REPLACE to change its value, not STORE.
  2. EdLeafe

    Know of Aspect-compatible products for Linux?

    Hi, My company has a large investment in ProComm Plus, including many custom Aspect scripts (currently running v4.8). We are looking to move our servers to Linux, but running these scripts is a problem. Using Wine doesn't work; however, the CrossOver Office product (a customized Wine...
  3. EdLeafe

    Newbie: Is Python well supported (looking into future)

    Python is very alive and very well supported. Since you mention a web project, you would do well to look into Zope: http://zope.org. It is a free dynamic web site framework and server, and is 100% python. I use it for my site (leafe.com), and find it to be the easiest and most powerful tool I've...
  4. EdLeafe

    DELETE FILE or DeleteFile()?

    Why not just use the native ERASE function in VFP? It takes wildcards, and is not subject to path sensitivity like DELETE FILE is. Hope that helps! -- Ed -- Get great VFP support in a new forum filled with Microsoft MVPs! -- http://opentech.leafe.com
  5. EdLeafe

    execute unix shell command with python

    The os module provides much of what you'd probably need. Have you checked it out? -- Ed -- Get great VFP support in a new forum filled with Microsoft MVPs! -- http://opentech.leafe.com
  6. EdLeafe

    How can i autofit grid columns

    Sure, there are 2.x sites out there, but a) 2.x doesn't have grids and b) this is a VFP forum [smile] -- Ed -- Get great VFP support in a new forum filled with Microsoft MVPs! -- http://opentech.leafe.com
  7. EdLeafe

    FREE TABLE ALWAYS CORRUPTED

    Tables can only be corrupted when they are being written to. If your POS system has a flaky power source, or a bad LAN connection, or users who pull the plug on it, it can get corrupted if those events occur during a disk write. You can switch to table buffering of your table, along with...
  8. EdLeafe

    Grid Class using Class Designer

    FWIW, the ability to designate a custom Header class for a column (as well as custom pages in pageframes, etc.) in one of the new features of VFP 8.0, which was released to manufacturing last week. Instead of spending a lot of time getting this to work in prior versions, if you can wait for 8...
  9. EdLeafe

    How can i autofit grid columns

    Oops, fat fingers! [blush] I meant to say "upgrade to VFP 8.0" -- Ed -- Get great VFP support in a new forum filled with Microsoft MVPs! -- http://opentech.leafe.com
  10. EdLeafe

    How can i autofit grid columns

    Or upgrade to VFP when it is available, which will probably be in 4-6 wks. It was released to manufacturing Jan 31. VFP 8 has this feature built-in. Hope that helps! -- Ed -- Get great VFP support in a new forum filled with Microsoft MVPs! -- http://opentech.leafe.com
  11. EdLeafe

    FoxPro 2.6 memo fields to SQL Server

    Varchar fields don't work like VFP fields - when you allocate 500 characters to a Varchar field and only insert a 20-char value, SQL Server doesn't pad the field with spaces out to 500. The "var" in varchar is short for "variable"; varchar is a variable-length character...
  12. EdLeafe

    Grid checkbox & drop down

    To add any control to a grid, first select the grid. Right-click and select "Edit" (or just control-click on the grid if you have VFP 7 or later). This will drill into the grid. Now select the desired control (such as a checkbox) from the Form Controls toolbar, and then click on the...
  13. EdLeafe

    Updating one table from another

    Here's a simple routine that will handle this: SELECT Table1 SCAN lcPLU = Table1.PLU SCATTER MEMO NAME loTable1 SELECT Table2 * Assume a tag on PLU IF SEEK(lcPLU, "PLU") SCATTER MEMO NAME loTable2 * Works great in VFP 8. In VFP 7, NULL values will * cause the...
  14. EdLeafe

    PageFrames with NO tabs in VFP 6.0 ...

    Set the pageframe's BorderWidth property to zero while Tabs = .T. Then when you set Tabs=.F., there will not be anything to click on. -- Ed -- Get great VFP support in a new forum filled with Microsoft MVPs! -- http://opentech.leafe.com
  15. EdLeafe

    Transactions in VFP

    You have a couple of options. One is to use SET REPROCESS to control the number of times or seconds that VFP will retry the lock before failing. This way, and short-duration locks the batch encounters won't cause the whole update to fail. The other is to FLOCK() the file before the update. While...
  16. EdLeafe

    Update Trigger ?

    Is the field you are updating in the same table? You cannot do that via a trigger then. Think about it: the trigger fires, and then changes a value in the same table, which fires the trigger, which changes a value in the same table, which fires the trigger, ... in other words, and infinite loop...
  17. EdLeafe

    Speed up SELECT using inedx?

    Also remember the syntax for creating a compound index tag: INDEX ON [expr] TAG [TagName] Sounds like you're using the standalone syntax: INDEX ON [expr] TO [FileName] -- Ed
  18. EdLeafe

    Select data from from two tables

    The general form for joining two tables in a query is: SELECT table1.field1, table1.field2, table2.field3, [etc] ; FROM table1 ; JOIN table2 ON table1.fk = table2.pk ; WHERE [filter conditions] ; GROUP BY [groupings] ; ORDER BY [orderings] ; INTO CURSOR Whatever Hope that helps! -- Ed
  19. EdLeafe

    Alternative databases

    MySQL 4 has transaction support. The older 3.2 versions do not. -- Ed
  20. EdLeafe

    Alternative databases

    Once MySQL is installed and running, install the ODBC driver on the machine you will be running VFP on. Create a System DSN to connect to a MySQL database, and then use that DSN from within VFP to connect to MySQL as you would to any other backend database. You can create remote views and work...

Part and Inventory Search

Back
Top