Trouble with ADO and VFP OLE DB provider
From: Paul Scvortsov (pauls_at_energotransbank.com)
Date: 03/30/04
- Previous message: Rolf Hesterberg: "Is ADO in D6 slower than in D5?"
- Next in thread: Brian Bushay TeamB: "Re: Trouble with ADO and VFP OLE DB provider"
- Reply: Brian Bushay TeamB: "Re: Trouble with ADO and VFP OLE DB provider"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 30 Mar 2004 14:47:55 +0300
Hi, all. Please help.
I need to use the old FoxPro 2.5 tables to get information from the outside
company
to my MS SQL 2000 database. I supposed to use the Visual FoxPro OLE DB
Provider
(MDAC 2.8; D7), but have some troubles:
1)When I try to delete a record:
ADOTable1.active:=true;
ADOTable1.edit;
ADOTable1.delete;
I receive the error:'Multiple-step operation generated errors. Check each
status value', and then I do
ADOTable1.refresh;
I receive: 'Insufficient key column information for updating or refreshing'.
I have such settings:
CursorLocation:=clUseClient;
CursorType:=ctKeyset;
TableDirect=False;
2) When I change settings to
CursorLocation:=clUseServer;
CursorType:=ctKeyset;
TableDirect=True;
I can delete records, but I couldn't hide deleted records, even I preveously
set 'Set deleted on' by ADOCommand.
Please give Your suggestions.
- Previous message: Rolf Hesterberg: "Is ADO in D6 slower than in D5?"
- Next in thread: Brian Bushay TeamB: "Re: Trouble with ADO and VFP OLE DB provider"
- Reply: Brian Bushay TeamB: "Re: Trouble with ADO and VFP OLE DB provider"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
