Hi Jim, You are missing the 'from' clause with a table. 4D does not support sql queries without table.
Eg in Oracle I would write: select trim(both from :vtext) from dual into :vtext; But it seems 4D sql does not support the dual phantom table either. Koen > Op 15 nov. 2018, om 15:50 heeft Jim Medlen via 4D_Tech <[email protected]> > het volgende geschreven: > > > 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] > ********************************************************************** ********************************************************************** 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] **********************************************************************
