Re: TADOTable exception when post second time

Hi again,

"Man Utd" <alanpltseNOSPAM@xxxxxxxxxxxx> escribió en el mensaje
news:42f152f9@xxxxxxxxxxxxxxxxxxxxxxxxx
> How does the autoedit affect the operation ?
> Does it harm if I leave that on ? Because in the source code, I found
> there
> are places of this autoedit := true whenever we need to edit the dataset.

AutoEdit is true by default. In that state, if a user tries to change the
data displayed by a data-aware control the data source calls the dataset's
Edit method. In your case i supposed that AutoEdit was first set to false,
because otherwise it would make no sense to put it to true.

If you want to prevent the user from unintentional modifications, then set
AutoEdit to false and call Edit whenever you need it.

>
> My TADOTable is connected to the TADOConnection component.

i would suggest to change any TADOTable for TADODataset or TADOQuery.
They're better in performance, as TADOTable has the nasty custom of always
trying to load all the possible data

> The TADOTable cursor type is ctStatic.

sorry, i think i miswrote it. i was not referring to the CursorType, but to
the CursorLocation, i.e., if the cursor is client-side (all necessary data
retrieved to the client, provides more flexibility) or server-side (data
remains in server, less flexibility but very useful for large sets of data).
See the help for more info.

>
> I got two forms have the same problem, each TADOTable connects to
> different
> table, but use the same approach.
> As I am the only user when testing this exception, so no other user is
> using
> the application, I am the onlyl user to modify the database.
> It only happened when I 'Second' edit and 'Second' save the dataset.

See Brian's reply
--
Best regards :)

Guillem Vicens
Dep. Informática Green Service S.A.
www.clubgreenoasis.com
--
in order to contact me remove the -nospam


.