Jim The computed columns will cause the problem.
You could also do this. It will give you the data from computed columns but they will not be computed in the temp table. PROJECT TEMPORARY tQuoteHeader FROM QuoteHeader USI ALL WHERE quoteid = .vquoteid The other option would be to list all the columns by name excluding the computed columns from INSERT. Buddy From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Belisle Sent: Monday, November 17, 2008 7:42 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Inserting into temporary table 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
