I would definitely try putting ".ivInvNo400" in parentheses. Regards,
Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MD Sent: January-20-17 3:18 AM To: [email protected] Subject: [RBASE-L] - -ERROR- Insufficient space to process INSERT command ( 235) 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. -- 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.
