Is it just a typo or my misunderstanding in the last line of your code:
missing the "401" from the temp table name compared to what you say the table
name is?
Regards,
Alastair.
On 20/01/2017 08:18, MD wrote:
Hello
I have an issue that I am simply stumped. I am transferring an application
from 9.5 (32) to Version X Enterprises. I create the invoice with temporary
tables and then when everything is right, the user saves the new invoice by
transferring the information from temporary tables to the permanent tables.
The header tables transfers without a problem but the details table fails and I
get the following error.
-ERROR- Insufficient space to process INSERT command ( 235)
Nothing special in the code (see below). Permanent table is InvD401 and the
temporary table is tInvD401.
-- NOW THE DETAILS
INSERT INTO InvD401 (InvNo400,LineOrder401,Quant401,SKUType900, +
SKU401,Description401,Taxable401,Price401,Tax401 ) +
SELECT .ivInvNo400,LineOrder401,Quant401,SKUType900,SKU401, +
Description401,Taxable401,Price401,Tax401 +
FROM tInvD ORDER BY LineOrder401
The same identical code works without problems in the 9.5(32) version currently
in production. I typed "SHOW" at the R> and all the setting are identical. I
tried increasing the files from25 to 35 and other setting to no avail.
Cannot understand what is causing it to failed under version 10 (64). Any
Blues Clues will be greatly appreciated.
Manuel de Aguiar
M|D Enterprises Los Angeles, CA
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
