Hmm, I will add us to that as well with a compiled app and the database, same issue a PK was lower than it should have been and I had to alter table to set it back. Only occurred once and fingers crossed, not happened since, so I did not bother trying to report an issue.
Which brings forth this question, where can I see or select from a system table that will show what the last Autonumber was for the table, thus allow me to check to see if the max(autonumbered col) in a table is greater then what the system shows for that table and would generate at insert -- Frank Frank Taylor - Director of Information Technology F.J. O'Hara & Sons, Inc - Araho Transfer Inc. Boston, MA - Rockland, ME - Miami, FL Direct Dial - 617-790-3093 email: [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Saturday, December 28, 2013 1:10 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: COMPILED APP PROBLEM 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. ================================================ --- RBASE-L =======================3D=======================3 D= 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) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= 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. =======================3D=======================3 D=
