[RESOLVED] Frontbase into outfile?

[csousley]

MySQL Query:

select * from table into outfile 'filename.txt';

I'm looking for what query FrontBase would need to create the same result as the above MySQL query. The select part is fine, but as far as I can tell there is no into outfile command in Frontbase.

Basically a tab or comma delimited file of the query results.

Any thoughts? Thanks.

[csousley]

Incase anyone else is ever looking for this answer I did eventually find it. Here it is:

WRITE TABLE SELECT * FROM table OUTPUT('filename.txt', '\t', '\n');