Page 1 of 1

What Unit are the SQLTypes Defined in ???

Posted: Wed 07 Nov 2012 20:14
by markmoss
Help

What Unit are the SQLTypes Defined in? They are in IBSQL in Interbase.

case IBSQL.SQLType of
SQLUnknown : Result := 'Unknown';
SQLSelect : Result := 'Select';
SQLInsert : Result := 'Insert';
SQLUpdate : Result := 'Update';
SQLDelete : Result := 'Delete';
SQLDDL : Result := 'DDL';
SQLGetSegment : Result := 'GetSegment';
SQLPutSegment : Result := 'PutSegment';
SQLExecProcedure : Result := 'ExecProcedure';
SQLStartTransaction : Result := 'StartTransaction';
SQLCommit : Result := 'Commit';
SQLRollback : Result := 'Rollback';
SQLSelectForUpdate : Result := 'SelectForUpdate';
SQLSetGenerator : Result := 'SetGenerator';
else
Result := '????';


Mark Moss
:mrgreen:

Re: What Unit are the SQLTypes Defined in ???

Posted: Thu 08 Nov 2012 12:21
by AndreyZ
You can use the TIBCSQL.SQLType property. The values for this property are defined in the IBCCall unit:

Code: Select all

SQL_UNKNOWN       
SQL_SELECT        
SQL_INSERT        
SQL_UPDATE        
SQL_DELETE        
SQL_DDL           
SQL_GET_SEGMENT   
SQL_PUT_SEGMENT   
SQL_EXEC_PROCEDURE
SQL_START_TRANS   
SQL_COMMIT        
SQL_ROLLBACK      
SQL_SELECT_FOR_UPD
SQL_SET_GENERATOR