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: [email protected] [mailto:[email protected]] On Behalf Of
gary.wend
Sent: Friday, January 20, 2017 3:58 PM
To: [email protected]
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 <[email protected]>
Date: 1/20/17 8:19 AM (GMT-06:00)
To: [email protected]
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: [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.
--
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.
