Page 1 of 1

formatting a field with SQL data.

Posted: Tue Aug 14, 2012 10:37 am
by d.m.holdawayGA2553
hello,

at the moment my my code pulls in some data from a SQL database, it works a treat but i am having trouble formatting it

at the moment it pulls in names from a address book for example and displays them

darren,dave,ian,simon

what i would like it to do is list them

darren
dave
ian
simon

any ideas?

Re: formatting a field with SQL data.

Posted: Tue Aug 14, 2012 11:08 am
by bn
How about:

Code: Select all

replace comma with return in myNames
put myNames into field "theNames"
where myNames is the variable with the names.
Kind regards
Bernd

Re: formatting a field with SQL data.

Posted: Tue Aug 14, 2012 11:13 am
by d.m.holdawayGA2553
is that it?

gosh i feel like such a idiot.... haha