The only reasons I use temp tables is primarily for speed or the keep the data local to the user. I would try it with the real table and see how it works. Dan Goldberg
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Belisle Sent: Monday, November 17, 2008 6:22 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Inserting into temporary table Buddy, Alastair, Maybe I am going about this the hard way. Would it be easier for me to bring the information up in a form accessing the real table, give component ID to the columns that would get updates (I.E. Quantities, etc.) and just either recalc or refresh the information? I am new to 7.6 and am not familiar with these functions but need to use them if it is easier. Jim _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Walker, Buddy Sent: Monday, November 17, 2008 7:34 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Inserting into temporary table Jim If in your column list the last item is a comma you will get that error. You have one other choice to add the information to your temporary table with the APPEND if the column names are the same in both tables. APPEND QuoteHeader TO tQuoteHeader WHERE quoteid = .vquoteid The append will ignore the computed columns Buddy From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Belisle Sent: Monday, November 17, 2008 8:15 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Inserting into temporary table Buddy, I did list the columns as you suggested. It seemed to work with me putting two commas next to each other, since one of my computed columns is in the middle of other columns. Also I traced the code again and I now get this error: "Cannot end with a binary operation". Here is my last line before the error: INSERT INTO tquoteheader SELECT (I list the columns here) FROM quoteheader WHERE quoteid = .vquoteid Jim _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Walker, Buddy Sent: Monday, November 17, 2008 7:08 AM To: RBASE-L Mailing List 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
