uncommitted change

Dear Sir/ Madam,

I created a form and press a button with the command to operate the Edit
mode. While I made amendment on a field (e.g. apple) of one of the records
from the table, says abc.dbf, then when I close the edit mode, it¡¦s okay;
but when I close the form with the button mentioned above, the error message
was shown:

=CursorSetProp(¡§buffering¡¨,THIS oldBuffering,aTablesUsed[m.i,1])
&&optimistic table buffering

Error 1545



Table buffer for alias ¡§abc.dbf¡¨ contains uncommitted changes.

Method: destroy

Line: 68



How can I solve this with my scenario??



Thank you for your kind attention!!



Patrick

Man-wai
Tue Jun 06 08:19:56 CDT 2006

> =CursorSetProp(¡§buffering¡¨,THIS oldBuffering,aTablesUsed[m.i,1])
> &&optimistic table buffering
> Error 1545
> Table buffer for alias ¡§abc.dbf¡¨ contains uncommitted changes.
> Method: destroy
> Line: 68

You should use getfldstate() to check all the fields in the current,
tableupdate() or tablerevert() any pending changes.

--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.06) Linux 2.6.16.20
^ ^ 21:19:01 up 7:02 0 users load average: 1.00 1.00 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk

PatrickHO
Thu Jun 01 18:10:25 CDT 2006

but can you give me the detail information on how to do, or make an
example??/

Thanks ^_^

"Patrick" <someone@microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:ehmhE1QiGHA.3956@TK2MSFTNGP02.phx.gbl...
>
> Dear Sir/ Madam,
>
> I created a form and press a button with the command to operate the Edit
> mode. While I made amendment on a field (e.g. apple) of one of the records
> from the table, says abc.dbf, then when I close the edit mode, it¡¦s okay;
> but when I close the form with the button mentioned above, the error
> message
> was shown:
>
> =CursorSetProp(¡§buffering¡¨,THIS oldBuffering,aTablesUsed[m.i,1])
> &&optimistic table buffering
>
> Error 1545
>
>
>
> Table buffer for alias ¡§abc.dbf¡¨ contains uncommitted changes.
>
> Method: destroy
>
> Line: 68
>
>
>
> How can I solve this with my scenario??
>
>
>
> Thank you for your kind attention!!
>
>
>
> Patrick
>
>

Imaginecorp
Tue Jun 06 21:43:44 CDT 2006

Hello Patrick:
seems like you have the table set to Buffering = 5 Table. So when you skip
it will not save the record. either change the buffering to a 3 Record, or
do an implicit Tableupdate(). The record is not being saved, that's all
Mohammed

"Patrick" <someone@microsoft.com> wrote in message
news:ehmhE1QiGHA.3956@TK2MSFTNGP02.phx.gbl...
>
> Dear Sir/ Madam,
>
> I created a form and press a button with the command to operate the Edit
> mode. While I made amendment on a field (e.g. apple) of one of the records
> from the table, says abc.dbf, then when I close the edit mode, it¡¦s okay;
> but when I close the form with the button mentioned above, the error
> message
> was shown:
>
> =CursorSetProp(¡§buffering¡¨,THIS oldBuffering,aTablesUsed[m.i,1])
> &&optimistic table buffering
>
> Error 1545
>
>
>
> Table buffer for alias ¡§abc.dbf¡¨ contains uncommitted changes.
>
> Method: destroy
>
> Line: 68
>
>
>
> How can I solve this with my scenario??
>
>
>
> Thank you for your kind attention!!
>
>
>
> Patrick
>
>