disable option SET NO_BROWSETABLE

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 5
Joined: Mon 17 Sep 2012 23:24

disable option SET NO_BROWSETABLE

Post by douglasfabiano » Mon 17 Sep 2012 23:35

hello people ..

I need to find out what the driver option that disables the option UniDAC SET NO_BROWSETABLE ON \ OFF because I'm not able to figure out which communication option that disables this option.




Re: disable option SET NO_BROWSETABLE

Post by AndreyZ » Tue 18 Sep 2012 10:07


The SET NO_BROWSETABLE option is automatically added by the provider (OLEDB or SQL Native Client) that SDAC uses to work with SQL Server. The SET NO_BROWSETABLE option is not set automatically in two situations:
- the TCustomMSDataSet.CursorType property is set not to ctDefaultResultSet;
- the TCustomMSDataSet.Options.UniqueRecords property is set to False and the TCustomMSDataSet.ReadOnly property is set to True.

Post Reply