TAstaSelectSQLOptionSet

unit
AstaDBTools

Declaration
type

  TAstaSelectSQLOptions = (soFetchMemos, soFetchBlobs,soPackets,soFieldProperties,soCyclopsSQL,

  soCompress,soIgnoreAutoIncrement,soExecStoredProc,soFetchBytes,SoDelayed);

  TAstaSelectSQLOptionSet = set of TAstaSelectSQLOptions;

Description

soFetchMemos      This will fetch all the ftmemo fields in selects and also allow them to be part of any Insert or Edit’s applied to the server. Note that since all fields in the select statement that translate to ftmemos will be fetched, using this feature could cause large memos to be streamed from the server to the client.

soFetchBlobs      This will fetch all ftblob or ftgraphic fields similar to the way that soFetchMemos works will the same performance considerations.

soPackets      When this is set, and the RowsToReturn is a positive number, and the AstaServer is running in the PersistentSessions threading model, this will cause the original select to be opened as a cursor on the server bringing back only RowsToReturn rows initially. See the discussion on GetNextPackets.

soCompress      When this is set the select statement will be compressed on the server using AstaCompression and and will be uncompressed on the client. This is ignored if you are have compression set on in the TAstaClientSocket. You may gain significant performance benefits by using this property on larger queries and if your server has sufficient CPU.

soIgnoreAutoIncrement      Used to allow AutoIncrement fields to be updated.

soExecStoredProc      Some stored procedures return result sets and others do not. If a stored Procedure does not return a result      set then call ExecSQL which is the same as setting soExecStoredProc to true. This will pass the NoResultSet:Boolean to the AstaServerSocket.OnStoredProcedure event as true.

soCyclopsSQL            This allows for select statements to be written, one for each item in the SQL:TStrings property and a result set will be returned that contains the SQL and an AstaDataSet saved as a string in a blob field. Used internally by ExpresswaySQL.

soFetchBytes      This will fetch all ftBytes or ftVarBytes fields similar to the way that soFetchMemos works will the same                  performance considerations.

soDelayed            This works only with client side SQL and when the AstaServer is running in Pooled Sessions threading and            allows for