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!

Search results for query: *

  1. asergeev

    VFP 9 - MS SQL 2005 Remote View Requery

    Hi, I posted this following message several days ago at MSDN-VFP forum. Unfortunately I didn't get any responces. This is my original message from MSDN forum. I have an interesting puzzle. I'm using Remote Views in VFP9 for the MS SQL Server database access. I'm trying not to store the...
  2. asergeev

    VFP9 Requery

    Mike, I solved the problem by installing VFP 9 SP1 beta. It was maybe a VFP bug that came out in my environment. Microsoft did patch couple places with REQUERY (see the fix list http://download.microsoft.com/download/c/7/b/c7b400fa-ff4f-43d3-ada1-8d0ea0e6803e/VFP9SP1_FixList.htm). Thanks once...
  3. asergeev

    VFP9 Requery

    Mike, Everything that I was doing was from command window in VFP. Nobody else was using the same connection and I was not running any other operations along with REQUERY. I also unset ASYNCHRONOUS EXECUTION option in connection, but it did not help. I found another recommendation for such ODBC...
  4. asergeev

    VFP9 Requery

    Mike, Thank you, as always, for your help. I checked an AERROR results and they were the following: VFP Error number: 1526 Error Message: Connectivity error: [Microsoft][ODBC Driver Manager] Function sequence error ODBC Error Message: [Microsoft][ODBC Driver Manager] Function sequence error...
  5. asergeev

    VFP9 Requery

    Hi, Our program updates a parameterized remote view against MS SQL Server. When we are trying to REQEURY this view after successful update with a new parameter VFP 9 doesn't update view and REQUERY returns -1. VFP 9 Help doesn't provide any information about return value of -1 for REQUERY. Here...
  6. asergeev

    VFP 9 and VFP 8

    Mike and Bill, Thank you for help. What is the most important that I undestood from your postings that what I'm experiencing is my local problem and I need to deal with it looking at VFP9 installation, ODBC, etc. Yesterday night I put VFP 9 on a fresh laptop with SQL 2005. I created my database...
  7. asergeev

    VFP 9 and VFP 8

    Mike, It returns actually 0. It is still executing. In Tracer I don't see any errors. But why does it take time to execute this query in 9 and no-time in 8? Could be version 9 installation? or something else that I missing? Thanks, Andrei.
  8. asergeev

    VFP 9 and VFP 8

    Mike, Yes, I tested this query in QA and it run fine and produced the set of tables and tables’ properties. The same result I have in VFP 8, but not in VFP 9. I also should say that for the last year several times I was trying to use VFP 9 with VFP 7 -8 code and in all these cases I came across...
  9. asergeev

    VFP 9 and VFP 8

    Mike, Database has tables and code runs fine in VFP8. This code is actually the part of the program for creating remote views from the backend database. Program reads tables from MS SQL database and creates DBC with remote views against SQL tables. I have now 133 tables in a database. In VFP9...
  10. asergeev

    VFP 9 and VFP 8

    Hi, I'm trying to use VFP 9, but I have problems with the same code that runs fine in VFP8. This is the code: RELEASE ALL CLOSE DATABASES CLOSE TABLES CLEAR LOCAL lctmp AS STRING, lnConnHandle AS INTEGER, lctblname AS STRING * Creating a connection string lctmp='Description=ABC...
  11. asergeev

    VFP and SQL Conversion

    Friend of mine actually sent me an intersting link for such library that looks very promising. http://www.dirfile.com/easysql4fox.htm Thanks, Andrei.
  12. asergeev

    VFP and SQL Conversion

    Mike, Thank you. This is what I thought. Andrei.
  13. asergeev

    VFP and SQL Conversion

    I have a query tool that was written in FP/VFP. It works fine for the last 10 years in our application. Now we are moving from FoxPro backend to RDBMS, to SQL Server in particular. We are using RV and SPT and VFP DAL for the data connection. Unfortunately, ODBC can't convert such VFP keywords as...

Part and Inventory Search

Back
Top