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
