Recent content by EdLeafe

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