Re: 4GL Concatenation Problem

This is a multipart message in MIME format --------------InterScan_NT_MIME_Boundary Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable Concatenating strings in 4GL is done with a comma, ie =20 insert into datsum (vend_id, <snip!>) select distinct vend_id, <snip!> and campshift=2Eweekdays like '%', weekday(jdate), '%' Davin ______________________________ Reply Separator ____________________________= _____ Subject: 4GL Concatenation Problem Author: PC {jhannah@mammoth=2Eorg} at INTERNET Date: 26/02/98 01:46 Greetings -- =20 I have a long SQL statement that I am trying to pass to Informix from 4GL,=20= and=20 am having some syntax problems=2E '||' works fine in dbaccess and E/SQL, bu= t 4GL=20 chokes: =20 =20 insert into datsum (vend_id, <snip!>) select distinct vend_id, <snip!> and campshift=2Eweekdays like '%' || weekday(jdate) || '%'|__________________________________^=20 | | There is an invalid character in the above line=2E=20 | See error number -4409=2E =20 =20 I cannot load the %weekday(jdate)% string into a 4GL variable, because=20 the result of weekday(jdate) changes from line to line=2E =20 I cannot let, prepare, and then execute the command because it is longer th= an=20 255 characters (a varchar(255) will not hold it)=2E In theory, I guess I co= uld=20 load it into strSQL1, strSQL2, etc=2E but I was hoping for a prettier solut= ion=2E =20 Any ideas? =20 Thanks, =20 Jay Hannah =20 DB-Access Version 7=2E20=2EUC5 INFORMIX-4GL Version 6=2E05=2EUD1 =20 -----=3D=3D Posted via Deja News, The Leader in Internet Discussion =3D=3D-= ----=20 http://www=2Edejanews=2Ecom/ Now offering spam-free web-based newsreading =20 ********************************************************************** DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu= k=20 This message and any attachments to it is intended only for the=20 individual or company to which it is addressed and may contain=20 information which is privileged, confidential or prohibited from=20 disclosure or unauthorised use=2E If the recipient of this=20 transmission is not the intended recipient, or the employee or agent=20 responsible for delivering such materials to the intended recipient,=20 you are hereby notified that any use, any form of reproduction,=20 dissemination, copying, disclosure, modification, distribution and/or=20 publication of this e-mail message or its attachments other than by=20 its intended recipient is strictly prohibited by the sender=2E =20 If you have received it in error, please notify us immediately by=20 telephone on the number above and destroy the message and all copies=20 in your possession=2E ********************************************************************** --------------InterScan_NT_MIME_Boundary--