Try looking in your H2 "bin" directory, but maybe you should specify a path
in you CSVWRITE command, eg:
CALL CSVWRITE('C:\PATH_I_KNOW\export.csv', 'SELECT * FROM TBLCUSTOMERS');
Cheers
Kerry
On Sat, Jan 23, 2010 at 2:20 AM, Ewald <[email protected]> wrote:
> Hi.
>
> I have a table, TBLCUSTOMERS that I'd like to dump to a CSV file.
>
> In my code I have an export button that performs the following query :
>
> CALL CSVWRITE('export.csv', 'SELECT * FROM TBLCUSTOMERS');
>
> It runs and returns that 36 records were written to disk. I have not
> been able to find the export.csv file anywhere. I've even dumped the
> table and created a dummy one, but alas, no joy,
>
> Could someone a lot smarter please point out what I'm doing wrong?
>
> I'm using 1.2.127 (2010-01-15), currently on WinXP, Java 1.6.0_17-b04
>
> Thank you
> Ewald
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<h2-database%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
