Is the update happening in a different session of RBASE? If so there was a lively discussion about this a couple days ago.
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dave McCann Sent: Friday, April 01, 2011 6:57 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DB Grid using View Update Problem Razzak: Sorry to say I just tried that and it still does not refresh the db grid properly. As I indicated, I have a button on same form which through code updates a column value, that shows up, nothing when I use an edit form though. Very strange. On 4/1/2011 3:49 PM, A. Razzak Memon wrote: > At 06:42 PM 4/1/2011, Dave McCann wrote: > >> I have an odd problem using a DB Grid based on a view in a form, >> information is displayed from the view and I have options to edit the >> underlying data by using double-click to edit opens a form to edit >> selected row of data. When data is saved and I return to the form >> with the view in a DB Grid, the updated data does not display. I am >> using a RECALC TABLES and have also tried PROPERTY TABLE >> <formtablename> 'REFRESH'. The data IS saved, it just doesn't >> refresh on the DB Grid. >> >> I also have a button on the same DB Grid form that updates one of the >> values (using UPDATE in code) to change a value in the underlying >> table for the selected row. Doing this with RECALC TABLES does >> properly show the updated value in the View. It is doing the same >> thing really, just through code vs an edit form. >> >> Any thoughts? > > > Dave, > > In your specific situation, instead of PROPERTY REFRESH > <formtablename> 'REFRESH', > try the following: > > Here's how: > > PROPERTY TABLE <formtablename> 'CLOSE' > PROPERTY TABLE <formtablename> 'OPEN' > > First PROPERTY command will close the dataset. > Second PROPERTY command will re-open/refresh the dataset. > > That's all there is to it! > > Very Best R:egards, > > Razzak. > > --- 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=
