Buddy: Thanks, that made good sense. But, same error. My bad.
Turns out, upon reflection, that the fourth column is a computed column; so, duh: Razzaks Clue from the other day holds. By reframing the code as: INSERT INTO TargetTable + SELECT BuildingNUM , + 0 , + 0 + FROM Building + WHERE BuildingClassID = 1 + AND BuildingNUM NOT IN + ( SELECT DISTINCT BuildingNUM + FROM SourceTable ) ... it works. I've avoided computed columns previously, so I'm on a learning curve. For charting purposes, the NULL(s) in that fourth column need be Zero/Naught/'0'. I may just populate that column from external code, but glad to take any suggestion. Thanks again. Bruce From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Saturday, February 28, 2015 4:18 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Error Message 118: "Incorrect Number of values for this table" Try INSERT INTO TargetTable (TargetColName1,TargetColName2,TargetColName3,TargetColName4) + SELECT . Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Saturday, February 28, 2015 7:04 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Error Message 118: "Incorrect Number of values for this table" All: I'm attempting to add one or more records to a FOUR COLUMN table with the following construct: Four columns, Four values. Datatypes all match, unless the zeros (integer) are interpreted ambiguously. What might I be missing here? Bruce
