Ahh, well. Syntax. Missing continuation character after "VALUES" in the original code.
Time to go home. Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Tuesday, January 14, 2014 4:57 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Error #118: "Incorrect Number of Values for This Table" Problem: I get error message "Incorrect Number of Values for This Table (118)" when attempting to insert two variable values into a two-column table. Syntax, or bad data? TRACE shows that prior to entering the IF/ENDIF structure, these three variables: vColNAME vRecordCNT vSerialNUM ... are properly formed and data-typed, with expected test values. The code crashes at the line indicated. --******************************** IF vRecordCNT > 1 THEN SWITCH vColNAME CASE 'ColNAME1' INSERT INTO Inspect_ColNAME1 + ( SerialNUM, RecordCNT ) + VALUES + ( .vSerialNUM, .vRecordCNT ) BREAK CASE 'ColNAME2' INSERT INTO Inspect_ColNAME2 + ( SerialNUM, RecordCNT ) + VALUES + ( .vSerialNUM, .vRecordCNT ) -- *** ERROR HERE *** BREAK CASE DEFAULT INSERT INTO Inspect_OtherNAME + ( SerialNUM, ColNAME, RecordCNT ) + VALUES + ( .vSerialNUM, .vColNAME, .vRecordCNT ) BREAK ENDSW GOTO BlahBlah ENDIF Appreciate any perspective, Bruce
