Results 1 to 3 of 3

Thread: NO_BROWSETABLE - what the heck is that?

  1. #1
    Join Date
    Sep 2002
    Location
    Montreal
    Posts
    86

    Question NO_BROWSETABLE - what the heck is that?

    Hi guys, does enybody know what does it do exactly?

    SET NO_BROWSETABLE ON/OF?

    Thanks much.
    Dim

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    from KB

    SET NO_BROWSETABLE ON is an undocumented option performed for Remote Data Service (RDS) ActiveX Data Connector (ADC) connections to SQL Server. Enabling this option makes every SELECT statement act as though FOR BROWSE had been appended to the statement, but bypasses the temporary table that FOR BROWSE normally pipes the results through. The net effect is to add keys and timestamps to the query as hidden output columns so the client can update specific rows (updateable cursors) without separate trips to the server to pick up the meta-data and munging the query to get the appropriate columns.

  3. #3
    Join Date
    Sep 2002
    Location
    Montreal
    Posts
    86
    Thx MAK, pretty much this is all I needed to know

    Dim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •