Search results for query: *

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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