Thank you and the dream team Kontema IT AB Gunnar Ekblad H�stholmsv�gen 32 131 30 NACKA Tel +46 8 714 59 00 Mobil +46 705455038 E-mail [EMAIL PROTECTED]
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: den 13 augusti 2003 16:37 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SQL problem Gunner, Actually, the "Release Candidate 2" is scheduled to be released sometime today! Very Best R:egards, Razzak. At 04:25 PM 8/13/2003 +0200, you wrote: >Razzak >Are you telling candidate 2 is here, how come I can not download it? >By the way I don't mind if you delay release candidate 2 as long as the >release is not delayed beyond my birthday (coming august 29) >All the best from a R:estless user/developer/fan/...... > >Crasy gunnar from Sweden > > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of A. >Razzak Memon >Sent: den 13 augusti 2003 15:28 >To: RBASE-L Mailing List >Subject: [RBASE-L] - Re: SQL problem > > >GREAT Example, Randy! > >Hmmmmm.... I have tried all your examples below in >R:BASE 7.0 for Windows (Release Candidate 2) and >they all work accordingly. > >Very Best R:egards, > >Razzak. > > >At 02:45 AM 8/12/2003 -0500, Randy Peterson wrote: > > >What is truly perplexing to me is that the following syntax works from > >the numbers 1 - 8. I tested each insert command into a table beginning > >with: > >INSERT INTO Test01 (t01,t02,t03) values 1245,'N', ',''1'' ' > >which inserts the following into the table: > >1245, 'N', '1' > > > >INSERT INTO Test01 (t01,t02,t03) values 1245,'N',',''1'',''2'' ' > >--------------------- > >1245, 'N', '1', '2' > > > >INSERT INTO Test01 (t01,t02,t03) values 1245,'N',',''1'',''2'', ''3'' ' > >------------------------ > >1245, 'N','1', '2', '3' > >and so forth until: > > > >INSERT INTO Test01 (t01,t02,t03) values 1245,'N', > >',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'' ' > > > >which results in: > >,'1','2','3','4','5','6','7','8' > > > >This command does not work although it uses the identical pattern: > >INSERT INTO Test01 (t01,t02,t03) values 1245,'N', > >',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'' ' > > > >So the issue is more than parenthesis or double quotes. > >The syntax works until it reaches some internal limit, > >and then it will not work without additional punctuation. > > > >Randy Peterson
