I once had a similar problem when the index file went wonky and the PK
was duplicating. Check that your autonumbering has not been fouled up.
It's simple to reset it.
SET VAR vPKValue INTEGER = NULL
SELECT MAX(PKColName + 1 INTO vPKValue FROM (order table)
AUTONUM PKColName IN ordertable USING .vPKValue, 1
Try entering an order. If it now works, you found it! If it works, check
the rest of your autonumbered columns while you are in there.
Albert
On 12/27/2013 3:31 PM, Jim Belisle wrote:
Our compiled application has been working smoothly with no problems.
I made no changes to the order entry code though I made slight changes
to other areas.
Now I cannot enter orders at all. Earlier today I was able to enter on
my application.
Anyone have any suggestions as to where I should look?
It looks like sales has been able to enter the quotes are okay.
James Belisle
Making Information Systems People Friendly Since 1990
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
