Alastair,
Thanks for the caution. I will use the column list since I plan to be able to add or update the information then insert it back into the table after deleting the original information. This is for an edit form I have built. Jim ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Alastair Burr Sent: Monday, November 17, 2008 7:16 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Inserting into temporary table But, be careful if you use the PROJECT method _and_ you need to do any changes to the temp table's structure as you will have columns with different definitions in the original and the temp tables. Regards, Alastair. ----- Original Message ----- From: Walker, Buddy <mailto:[EMAIL PROTECTED]> To: RBASE-L Mailing List <mailto:[email protected]> Sent: Monday, November 17, 2008 1:07 PM Subject: [RBASE-L] - RE: Inserting into temporary table 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 ________________________________ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date: 17/11/2008 08:48
