Search results for query: *

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

Are you sure? Without looking at your source XML document I can't be sure, but is it possible that there is an additional single node between the primary node and your field name and value nodes? pamela

Just for your information the *.pjx file is not part of the runtime application, it is part of the source. It is the recipe for how to create the EXE. So it makes for a good test of your theory. pamela

Hi Ralph, This is a VB or ADO error, not a VFP error. You will get more help in a VB forum. Here is a link to one discussion http://www.vbforums.com/archive/index.php/t-461485.html For more just put the error message in a Google search pamela

You might want to double check that all of your tables (and the DBC) are marked as excluded from the project. If any of them are included in the EXE they could have an incorrect backlink. pamela

There is no such limit mentioned in the System Capacities topic of the VFP6 help file. It mentions a 65,500 limit to the number of characters in a record, but a memo field only takes up 4 bytes, so that wouldn't be affected. I don't remember ever hearing of such a limit. pamela