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

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

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

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

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

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