>>I have having a problem converting my SQL data into a CHR(254) field instead of a MEMO field when using SQLEXEC. I know how to do it using remote views, but can anyone tell me how to put my data into a CHR with SQLEXEC?
>>
>>Thanks in Advance...
>
>If the contents of the fields is less them 254 chars, you could try:
>
>TEXT TO lcSQL NOSHOW PRETEXT 15
> SELECT CAST(MyField as Varchar(254)) AS MyField
> ....
> FROM .....
>ENDTEXT
>SQLEXEX(lnSql ,lcSQL,[MyCursor])
>
Borislav,
Thanks so much. That did the trick.
freddie
Frederick Kusin
NetBase Development Group
3746 Folsom Street
San Francisco, CA. 94110
www.netbasegroup.com