Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
Refresh problem |
Tue, Jul 20 2010 1:46 AM | Permanent Link |
Bill Z ZED Data Solutions | Hi,
Working on a WinCE application using Lazarus and ElevateDB. Have a form with a grid that displays column data for a vending machine to enable recording of sale quantities for each column. There is a menu option to change the item and impress for a selected record (vending column) which is handled by another form. The actual data update in this form is handled by SQL update call on the table. The record update sets a flag to indicate there has been a change, closes the form and returns to the original form. On return to the original form, this flag is checked and Refresh is called (ie. SaleTbl.Refresh) for the table to update the selected record. The refresh doesn't work and I have to close the form and return to see the change. What am I doing wrong?? regards Bill Zwirs |
Tue, Jul 20 2010 5:31 AM | Permanent Link |
John Hay | Bi
> Working on a WinCE application using Lazarus and ElevateDB. Have a form with a grid that displays column data for a vending machine to enable recording of sale quantities for each column. There is a menu option to change the item and impress for a selected record (vending column) which is handled by another form. The actual data update in this form is handled by SQL update call on the table. The record update sets a flag to indicate there has been a change, closes the form and returns to the original form. On return to the original form, this flag is checked and Refresh is called (ie. SaleTbl.Refresh) for the table to update the selected record. > > The refresh doesn't work and I have to close the form and return to see the change. If the query is not live you will have to close and open it. John |
Wed, Jul 21 2010 5:22 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Bill,
<< Working on a WinCE application using Lazarus and ElevateDB. Have a form with a grid that displays column data for a vending machine to enable recording of sale quantities for each column. There is a menu option to change the item and impress for a selected record (vending column) which is handled by another form. The actual data update in this form is handled by SQL update call on the table. The record update sets a flag to indicate there has been a change, closes the form and returns to the original form. On return to the original form, this flag is checked and Refresh is called (ie. SaleTbl.Refresh) for the table to update the selected record. The refresh doesn't work and I have to close the form and return to see the change. >> Hmm, Refresh should work no matter what. Can you send me the Lazarus code that you're using ? I want to try it out here and see what is going on. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jul 21 2010 5:24 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | John,
<< If the query is not live you will have to close and open it. >> Actually EDB can Refresh insensitive result sets - it actually goes out and checks if any of the referenced tables have changed, and refreshes the result set if they have. This avoids all of that nasty close/re-open business that DBISAM required. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jul 21 2010 6:25 AM | Permanent Link |
John Hay | Tim
> Actually EDB can Refresh insensitive result sets - it actually goes out and > checks if any of the referenced tables have changed, and refreshes the > result set if they have. This avoids all of that nasty close/re-open > business that DBISAM required. Thanks for the clarification. I guess this differs from DBISAM in that insensitive queries are not editable in EDB. John |
Thu, Jul 22 2010 8:56 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | John,
<< Thanks for the clarification. I guess this differs from DBISAM in that insensitive queries are not editable in EDB. >> Correct. That's why the Refresh now works, although I'm playing around with some things like editable/indexable views and insensitive result sets along with triggers that re-update the source tables. Hopefully I can get this type of functionality in the product at some point. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |