Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Gianni Sassanelli
  Where is Gianni Sassanelli?
 Rome
 Italy
 Gianni Sassanelli
 To: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 Tags
Subject: RE: delete on DBF by VFP.oledb provider
Thread ID: 131498 Message ID: 131513 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, May 11, 2007 8:59:34 PM         
   


I have some goods but not resolve my problem


I HAVE SUCCESS with

DELETE From
OPENRowSET('MSDASQL',
'Driver={Microsoft Visual FoxPro Driver};
SourceType=DBC;
SourceDB=c:\<font color="Blue" family="Microsoft Sans Serif">Database.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO;','Select * from Table.Dbf')
Where Field = 'Value to delete'


At this moment I have 2 problems

1) I dont use UNC path for retrieve Database.DBC
2) I don't work with VFP9.DBF tables because odbc driver don't recognize it

Can you help me please?

ENTIRE THREAD

delete on DBF by VFP.oledb provider Posted by Gianni Sassanelli @ 5/11/2007 6:59:34 PM
RE: delete on DBF by VFP.oledb provider Posted by Borislav Borissov @ 5/11/2007 7:06:14 PM
RE: delete on DBF by VFP.oledb provider Posted by Gianni Sassanelli @ 5/11/2007 7:13:35 PM
RE: delete on DBF by VFP.oledb provider Posted by Borislav Borissov @ 5/11/2007 7:24:58 PM
RE: delete on DBF by VFP.oledb provider Posted by Gianni Sassanelli @ 5/11/2007 7:29:47 PM
RE: delete on DBF by VFP.oledb provider Posted by Borislav Borissov @ 5/11/2007 7:45:36 PM
RE: delete on DBF by VFP.oledb provider Posted by Gianni Sassanelli @ 5/11/2007 7:57:23 PM
RE: delete on DBF by VFP.oledb provider Posted by Eric den Doop @ 5/11/2007 8:43:51 PM
RE: delete on DBF by VFP.oledb provider Posted by Gianni Sassanelli @ 5/11/2007 9:02:28 PM
RE: delete on DBF by VFP.oledb provider Posted by Gianni Sassanelli @ 5/11/2007 8:59:34 PM