Autoedit still a problem

Hi All,
A while ago I posted a question about AutoEdit not behaving as expected 
and I still have not been able to resolve the issue.

I have a form with a query. The query points to a table on a MSSQL 
server.

   this.VTRACK1 = new QUERY()
   this.VTRACK1.parent = this
   with (this.VTRACK1)
      left = 37.0
      top = 11.0
      database = form.vtrackdb
      sql = "select * from dbo.vtrack vt where vt.truckid =
:nTruckID"
      params["nTruckID"] = -1
      active = true
   endwith

   with (this.VTRACK1.rowset)
      autoEdit = false
   endwith

I have placed a button on the form to show the .state of this rowset in 
a msgbox. When I set the params and requery, the record is retrieved and 
the .state is 1, but as soon as I type anything in a datalinked field 
the .state changes to 2. It's driving me MAD, perhaps MSSQL does not 
support autoedit=false?

Regards

Hi Again,
Never mind, I found it. Doing a requery() resets autoedit to true.

Regards

Hi Trevor,
i have the same problems with firebird. After a save, abandon or requery 
autoedit changes automatic to true. You have set the state of autoedit in 
your sourcecode after this commands to false.

Ugi
"Trevor" <trannnospam@nospammpx.xom.au> schrieb im Newsbeitrag 
news:MPG.224c4d0a72a97b4b9896a1@news.dbase.com...
> Hi Again,
> Never mind, I found it. Doing a requery() resets autoedit to true.
>
> Regards
> Trevor 

In article <gcT1hHniIHA.1460@news-server>, udursun@t-online.de says...
> Hi Trevor,
> i have the same problems with firebird. After a save, abandon or requery 
> autoedit changes automatic to true. You have set the state of autoedit in 
> your sourcecode after this commands to false.
> 
> Ugi
Hi Ugi,
Yes, after a requery I set the rowset.autoedit=false. This fixed the 
problem,

Regards