🚀 go-pugleaf

I have used BCB5/ADOExpress with all versions of Windows and all version of
MDAC (up to 2.7) and have not encountered any problems like that.

If your recordset is not read only or disconnected, why not just query the
record in question, then

ADOQuery1->Edit();
ADOQuery1->FieldByName("STATUS")->AsString = "A";
ADOQuery1->Post();

or better yet, use a TADOCommand object to execute SQL commands that don't
return recordsets.

I'm not saying there is no problem just because I have not encountered one,
but using command objects for UPDATE commands always works for me.

Mark

"Mountain Lan" <swatow@sina.com> wrote in message
news:3dcc6f2b@newsgroups.borland.com...
> Hi, friends,
>
> I am using BCB5 with SP1 and ADOExpress SP. My program works well on
Windows
> 2000(SP3). But when softwares, which upgrade MDAC (such as SQL Server
2000,
> Visual Studio .Net, and so on) installed on my computer, my program
crashed.
> My program can't run on Windows XP either, which has a newer MDAC too.
>
> There is something wrong with TADOQuery when working with newer MDAC. I
> found that TADOQuery component couldn��t execute a UPDATE or INSERT
command
> once it had been used to retrieve dataset using SELECT command. My test
> codes are very simple:
>
>
>
> ADOQuery1->SQL->Text = "SELECT * FROM SYS_USER";
>
> ADOQuery1->Open();
>
> ADOQuery1->Close();
>
>
>
> ADOQuery1->SQL->Text = "UPDATE SYS_USER SET STATUS = 'A'";
>
> ADOQuery1->ExecSQL();
>
>
>
> An exception is raised here: Access violation at address xxxxxx in
> msado15.dll.
>
>
>
> If I never use TADOQuery component to open a dataset, but use it to update
> data only, this exception will never be raised.
>
>
>
> What's wrong in it? I've tried to install MDAC 2.6 SP1, MDAC2.6 SP2, MDAC
> 2.7 on my computer, but couldn't eliminate this error. Thank you very
much!
>
>
>
> Mountain
>
>
>
>
>
>
>