Recent content by pthalacker

Something doesn't seem quite right with the select statement syntax. What is the name of the database and what is the name of the table? pamela

Novell and Fox never got along. There were times when my Novell client would keep a file handle open even after I closed Fox. It required a cold boot for me to release the file handle. This is a recipe for table corruption. Running FoxFix was part of my weekly maintenance routine. The...

Hi Fred, XML can take a unlimited number of formats. XMLToCursor() has a limited understanding and expects to receive something similar to what is generated when you use CursorToXML(). If your incoming XML has a schema the I suggest using an XMLAdapter class to give VFP more information on how...

Hi Bill, My experience with SQL Server connections strings is that IP addresses are pretty much interchangeable with server names. pamela

When you say it works from the Command Window, how are you creating and destroying the license class? I don't see that in your code. I have never tried it, but I wouldn't be surprised if you can't use DEFINE CLASS in a stored procedure. It can't be used inside program flow structures. pamela

I assume that you do it the same way you launch any application from the command line. I have never used Unix but in DOS you just typed the name of the EXe. Once Fox is launched you get a Dot '.' prompt that functions much like the C:\ prompt in DOS. To exit Fox you type 'Quit' at the dot...

From the help file on APPEND FROM You might be able to parse it using Alines(FileToStr(myfile.txt)) or you may have to resort to using low-level file functions pamela

Pressing the Enter key should have no impact on the GotFocus and LostFocus events. You might pick up a copy of "The Fundamentals" at hentzenwerke.com. Although it was written for VFP6, most of the basic principles it covers still apply. pamela

That to me is the question. Fox has no problem with: ?{^1066/10/10} ?Date(1066, 10, 10) Could there be something else going on? pamela

Once user 1 has saved the updated information to disk the grid's Refresh method can be used to update the information in the cursor that is the RecordSource for user2's grid pamela

I would probably use the XMLAdapter class. It has an AddTableSchema method. pamela

Yes, it should run in compatibility mode. pamela

Yes, there have been many improvements in XMLToCursor over the versions, but XML is a very complex standard. Once you get past rather basic constructs, you need a schema for the source table to get you best results. With complicated source, I still often use string parsing or instantiate the...

Yes If the code is in a macro, something has to invoke the macro. I assume that would be the user. I am no expert in VBA either, but I assume it would use a FOR loop to cycle through all the cells in a range such as A2:A22 pamela

Your code looks like VB code, not VFP code. Are you using VFP tables for data storage? In VFP to assign a null value to a field the code is: REPLACE MyField with .NULL. IN MyTable pamela