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
