Funny you mention that. I had a similar problem just yesterday. Somehow the autonumber on an id column was lower than the last number. It would not let us add new rows because it was a unique key.
So I changed the autonumber to the highest number plus one and it works again. I am not sure how this happened but it is strange. Dan Goldberg -----Original Message----- From: Albert Berry Sent: Friday, December 27, 2013 4:03 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: COMPILED APP PROBLEM 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. ================================================ --- 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. ================================================
