>>>HI,
>>>
>>>I need to create a connection to Visual Foxpro DBC database for query specific table documentos and insert the result into Cursor for creating a new table on SQL server to insert the result of my cursor.
>>>This is my code:
>>
>>Luís,
>>
>>Why don't you just OPEN DATABASE and SELECT FROM whatever you need to extract, and INSERT whatever you need to add?
>>
>>Hi Antonio,
>>
>>Thanks for your reply.
>>My program is developed in VFP9 with a SQL Server database, so I can create a routine to connect to my client's old FoxPro database.
>>to pass data to my program, namely SQL Server, because my client's software is specifically for glassware.
>>
>>My problem is that I can't open the database from the client's software, I just need to collect the data from the invoice head table and the invoice line table from my programme.
>>The USE command of the table lock it, so I can't use this option or the other software will stop.
>>
>>Ideally, I'd like to be able to connect to the DBC database via ODBC and perform the necessary queries to pass the data to a cursor in VFP and make INSERTs in my SQL table.
>>
>>
>>Are there any of these possibilities?
>>Thank you
>>Luis
>Sounds like a missing Set Exclusive Off before the Use.
There are other advantages of doing it with ODBC -- for example it doesn't open the table in the datasession. I've found that this makes things more stable.
ICQ 10556 (ya), 254117