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!

Recent content by pthalacker

  1. pthalacker

    SQL ST - can't close cursor !

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

    Reoccuring Table Corruption Problem

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

    XMLTOCURSOR()

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

    How do you connect to an SQL table at a remote site

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

    Trouble Calling a FoxPro Stored Procedure from .NET

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

    Creating and Exporting Reports

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

    Appending from Comma Delimited file into MEMO field

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

    KeyPress in run time

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

    Invalid date error...

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

    how to handle 2 users updating file viewed in grid

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

    XML import not working

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

    64 Bit Compatiblity

    Yes, it should run in compatibility mode. pamela
  13. pthalacker

    XML import not working

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

    Map/Link an Excel cell to VFP field value

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

    Validation check box

    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
See more

Part and Inventory Search

Back
Top