BDE to SDAC - Readonly data access components

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
lcoelho
Posts: 47
Joined: Wed 13 Apr 2011 13:41

BDE to SDAC - Readonly data access components

Post by lcoelho » Wed 09 May 2012 13:21

Hi, I'm migrating from Delphi5 projects that use BDE to use SDAC. I notice from the Delphi5 documentation that the default behaviour of BDE is to return resultsets as readonly.

What will I have to do to achieve the same with migrating to SDAC? Would I have to set the Read-only field of all components to True?

AndreyZ

Re: BDE to SDAC - Readonly data access components

Post by AndreyZ » Thu 10 May 2012 14:00

Hello,

The TMSTable component obtains editable result sets as well as TTable. The TMSQuery component obtains editable result sets, but TQuery obtains readonly result sets. To obtain the same behaviour with TMSQuery as with TQuery, you should set the TMSQuery.ReadOnly property to True.

lcoelho
Posts: 47
Joined: Wed 13 Apr 2011 13:41

Re: BDE to SDAC - Readonly data access components

Post by lcoelho » Thu 10 May 2012 14:07

Thank you for your kind assistance

AndreyZ

Re: BDE to SDAC - Readonly data access components

Post by AndreyZ » Thu 10 May 2012 14:24

If any other questions come up, please contact us.

Post Reply