Re: SQL TRIM

2018-11-19 Thread Charles Miller via 4D_Tech
Also remember to add limit 1 to command. If you run against a real table that has 100 rows the sql will run 100 times Regards Chuck On Thu, Nov 15, 2018 at 10:23 AM Koen Van Hooreweghe via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Jim, > > You are missing the 'from' clause with a table. 4D doe

Re: SQL TRIM

2018-11-15 Thread Koen Van Hooreweghe via 4D_Tech
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 Ji

SQL TRIM

2018-11-15 Thread Jim Medlen via 4D_Tech
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