Page 1 of 1

disable option SET NO_BROWSETABLE

Posted: Mon 17 Sep 2012 23:35
by douglasfabiano
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.


thanks


Douglas

Re: disable option SET NO_BROWSETABLE

Posted: Tue 18 Sep 2012 10:07
by AndreyZ
Hello,

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.