>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])
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
