Thanks Brian.. it took me a few hours, but I figured that out this morning.
I'm new to this whole coding thing and I find it all so exciting.
thanks again!
On Thursday, September 27, 2012 8:03:02 AM UTC-7, Brian wrote:
>
> You'll need to explicitly name and order them in your select statement.
> select date,name,location,phone from data_push
>
> On Thursday, September 27, 2012 6:28:54 AM UTC-7, sc8132 wrote:
>>
>> Hi,
>>
>> I have a call csvwrite script for my database. How can I change script so
>> that it allows me to "control" the sort order of the columns?
>> I want specific columns of my table to be in specific order (ie: Date,
>> Name, Location, Phone, etc).
>>
>> CALL CSVWRITE('C:\TEMP\exportdata.csv','SELECT "DATA_PUSH".* FROM
>> "PUBLIC"."DATA_PUSH"
>> "DATA_PUSH"','fieldDelimiter= writeColumnHeader=false');
>>
>> Thanks!
>> Sherry
>>
>>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/XMuupRW4RZcJ.
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.
