I have code in which I want to insert existing information from a table into a temporary table. The temporary table has the exact number of columns as the real table and in the same sequence. I get the error "incorrect number of values for this table". The temporary table does have two computed columns. The code I am using is:
INSERT INTO tQuoteHeader SELECT * FROM QuoteHeader WHERE quoteid = .vquoteid I have also used the following with the same result. INSERT INTO tQuoteHeader SELECT all FROM QuoteHeader WHERE quoteid = .vquoteid Is it the computed columns in the temporary table that are causing the problem? Jim
