Delphi 7 and VFP OLE DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craig Oberfield - 05 Aug 2004 02:42 GMT

I get the correct 40 records returned in this query, but the table
never gets written. I have tried using key word TABLE instead of DBF
and have also tried 'c:\xxxxxx' and "c:\xxxxxx". Also with a '.dbf' in
the file names.

I also tried the TO FILE keywords.

My Code:
procedure TForm1.Button4Click(Sender: TObject);
var
QResult : integer;
begin
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('SELECT * FROM qnnotes INTO DBF xxxxxx');
//ADOQuery1.Open;
QResult := ADOQuery1.ExecSQL;
Showmessage('There were ' + inttostr(QResult) + ' records copied.');
end;

Thank You

Craig.

Reply to this Message

Stefan Wuebbe - 06 Aug 2004 19:40 GMT

Select .. Into Table .. works for me via ADO (tested in FoxPro code).
Assumed the current directory from the OleDB driver's point of view
is not what you expected, what happens when you use a full-path
file name?

-Stefan

> I get the correct 40 records returned in this query, but the table
> never gets written. I have tried using key word TABLE instead of DBF
[quoted text clipped - 18 lines]
>
> Craig.

Reply to this Message