One more thought, Is the data type for the variable the same as the data type for the column? Run the program and stop before the insert command. Then do a show var at the command prompt. What is the data type of the variable. Compare that to the data type of the column in the table. Gary
Sent from my Verizon, Samsung Galaxy smartphone -------- Original message --------From: MD <m...@mdenterprises.net> Date: 1/21/17 12:14 AM (GMT-06:00) To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - -ERROR- Insufficient space to process INSERT command ( 235) Thank you for your suggestions that I tried. I narrow down the issue to the ability to insert a row into the InvD401 (detail) table. I there is no problem inserting rows into the other tables but I get this message with the permanent table InvD401. Autochk shows no error and I just order RScope Enterprise to make sure it is not an issue with the table. The interesting thing is that if I perform an EDIT USING InvD401 I can add and delete rows at will but it fails when using the INSERT comment. I expect sometime Monday for my order to be processed and once I download it, I will discard the corruption theory and move to other possibilities for the cause.Thank you again,Manuel From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of gary.wend Sent: Friday, January 20, 2017 3:58 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - -ERROR- Insufficient space to process INSERT command ( 235) Have you tried to trace the command. It can generally give you an idea on what could be happening. Gary Sent from my Verizon, Samsung Galaxy smartphone -------- Original message --------From: Stephen Markson <smark...@pebc.ca> Date: 1/20/17 8:19 AM (GMT-06:00) To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - -ERROR- Insufficient space to process INSERT command ( 235) I would definitely try putting ".ivInvNo400" in parentheses. Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 -----Original Message----- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of MD Sent: January-20-17 3:18 AM To: rbase-l@googlegroups.com 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 rbase-l+unsubscr...@googlegroups.com. 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 rbase-l+unsubscr...@googlegroups.com. 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 rbase-l+unsubscr...@googlegroups.com. 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
