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
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
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
3 matches
Mail list logo