I am trying to learn to use SQL in 4D.

I wrote the code below to try a test using the TRIM function.

I have rewritten this several times but it throws a general parsing error every 
time.

C_TEXT(vText)
vText:="         sql Text!       "
Begin SQL
SELECT TRIM(BOTH FROM :VTEXT) INTO :vText ;
End SQL
ALERT(vText)
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[email protected]
**********************************************************************

Reply via email to