When I run this Query:
     SQL.Add('EXPORT TABLE patient');
     SQL.Add('TO ''C:\Users\Michael\Desktop\Patient.csv''');
     SQL.Add('Include Headers');
     Prepare;
     ExecSQL;
I get an error #600 "Path is invalid", But the path is good and I can use CreateFile() with no problems.

Michael,

<< When I run this Query:
     SQL.Add('EXPORT TABLE patient');
     SQL.Add('TO ''C:\Users\Michael\Desktop\Patient.csv''');
     SQL.Add('Include Headers');
     Prepare;
     ExecSQL;
I get an error #600 "Path is invalid", But the path is good and I can use
CreateFile() with no problems. >>

What is the full error message ?  If it includes an "OS Error" section, then
the error is coming from the OS and we really have no control over the "why"
of the error.

--
Tim Young
Elevate Software
www.elevatesoft.com

I changed the query to
    SQL.Add('EXPORT TABLE "Patient"');
    SQL.Add('TO ''C:\Patient.csv''');
    SQL.Add('Include Headers');
    Prepare;
    ExecSQL;

And it runs with no errors but The is no Paatient.csv file to be found anywhere.

If I run this same query in the EDB Manager everything works fine.

Michael,

<< And it runs with no errors but The is no Paatient.csv file to be found
anywhere.

If I run this same query in the EDB Manager everything works fine. >>

Is this running over a local or remote session ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

I'm using a Remote Session


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Michael,

<< And it runs with no errors but The is no Paatient.csv file to be found
anywhere.

If I run this same query in the EDB Manager everything works fine. >>

Is this running over a local or remote session ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Michael,

<< I'm using a Remote Session >>

And are you looking on the ElevateDB Server's c:\ driver for the exported
file ?  With remote sessions, the export is done from the perspective of the
ElevateDB Server, not the client application.

--
Tim Young
Elevate Software
www.elevatesoft.com

It's is a local database 127.0.0.1


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Michael,

<< I'm using a Remote Session >>

And are you looking on the ElevateDB Server's c:\ driver for the exported
file ?  With remote sessions, the export is done from the perspective of the
ElevateDB Server, not the client application.

--
Tim Young
Elevate Software
www.elevatesoft.com

I'm sorry your right I checked the server and the file were there.

I thought I had the address set for 127.0.0.1 but it was set for my server.

That explains why it could not find the path error I was getting.
I am going to bang my head against the wall now.