Re: CSVWRITE - How do you sort the order of the columns?

[Brian]

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

[sc8132]

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!