Dayle, By way of information "Page" is a reserved word and should not be used as a column name.
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ----- Original Message ---- > From: "Coxen, Dayle" <[email protected]> > To: RBASE-L Mailing List <[email protected]> > Sent: Wed, August 4, 2010 9:38:21 AM > Subject: [RBASE-L] - RE: Update form will not save changes > > Thanks Dennis. > I tried both expressions but got the same result. > > I finally copied the table to a new name, removed the computed column, > created >a new form on the new table and it worked fine. > Is there a problem with having a computed column? I have attached image. >(Hopefully) > > > Dayle Coxen > Office of Maintenance > (850) 410-5635 > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath > Sent: Wednesday, August 04, 2010 10:15 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: Update form will not save changes > > The expression should be: > > (CREW & CTXT(datex) & PAGE) > > or > > ((CREW) & (CTXT(datex)) & (PAGE)) > > Dennis McGrath > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Coxen, Dayle > Sent: Wednesday, August 04, 2010 9:11 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: Update form will not save changes > > Sorry, I tried to include the images. > > The Expression for the computed column is: (CREW) & (CTXT(datex)) & (PAGE) > That is 3 other columns in the same row with filed properties. Crew (text) >date (date) and page (text) > > Dayle Coxen > Office of Maintenance > (850) 410-5635 > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Coxen, Dayle > Sent: Wednesday, August 04, 2010 10:01 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: Update form will not save changes > > I am using the same basic grid form and DB Navigator for all my other tables >and it seems to work fine. > > > > The DB Navigator object properties only gives me the visible buttons > (checked >or not). > > [cid:[email protected]] > > > > Here is the Column expression. > > [cid:[email protected]] > > > > > > Dayle Coxen > > Office of Maintenance > > (850) 410-5635 > > > > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring > Sent: Wednesday, August 04, 2010 9:47 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: Update form will not save changes > > > > Dayle, > > > > Add these lines to the forms On After Start Eep: > > > > property Rbase_form dontshowdeletedialog 'true' > > property Rbase_form dontshowsavedialog 'true' > > Ret > > > > This will get rid of the Save changes question. > > > > What are the contents of the Save Button and what type of button are you > > using ? > > All buttons can contain either Predefined or Custom eep actions. Which are > > you using ? > > > > What is the exact syntax of the variable giving you a problem ? > > > > Bill Eyring > > > > > > > > -----Original Message----- > > From: [email protected] [mailto:[email protected]] On Behalf Of Coxen, Dayle > > Sent: Wednesday, August 04, 2010 9:25 AM > > To: RBASE-L Mailing List > > Subject: [RBASE-L] - Update form will not save changes > > > > Hello Group - > > > > I am using R:BASE Release 7.6. I am trying to create simple forms to update > > tables. > > Following the "7.6 Beginners Tutorial" "Part V - Lesson 4" I created basic > > forms, using the form wizard, for each of my application tables. Everything > > seems to work fine except for one table (table B). > > > > When use the new form to update any column in any row in table B, I cannot > > save it. The SAVE button does not work. I cannot navigate to any other > > row. > > > > The only way to get out is to select the X in the upper right corner. Then > > I am prompted to "Save Changes?". If I select YES it just stays in the > > updated row. (A few times I have seen "Data Has Been Changed by Another > > User Since Last Refresh. Do You Want to Save Changes?") I then can only > > choose NO and loose the changes. > > > > What is unique about table B is that one of the columns is a computed > > expression. The expression is a combination of 3 columns in the row as a > > Check Value. (CREW) & (CTXT(datex)) & (PAGE) > > > > Any suggestions would be greatly appreciated. > > > > Dayle Coxen > > Floida DOT > > (850) 410-5635 > > > > --- RBASE-L > > =======================3D======================= > > 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======================= > > D= > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [email protected] In the message SUBJECT, put > > just one word: INTRO =======================3D======================= > > D= > > TO UNSUBSCRIBE: > > Send a plain text email to [email protected] In the message SUBJECT, put > > just one word: UNSUBSCRIBE =======================3D======================= > > 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======================= > > D= > > >
