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
To: RBASE-L Mailing List
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
