'llo - a bit offtopic ish, i'm working with low level ADO objects to do
some DB stuff and am running into difficulty with creating query
parameters, everything works, or would work, if I knew what the constants
were...
sql.CommandType := adCmdSql;
sql.CommandText := 'SELECT * FROM Company WHERE company_ref = :ref';
param := CreateOleObject('ADODB.Parameter');
param.Type := adInteger;
param.Size := 3;
param.Direction := adParamInput;
param.value := 1;
sql.parameters.append(param);
I need to know the values for the .Type .Direction and .CommandType
properties (or, a list of all the ADO constants), I can't seem to find them
anywhere :(
Does anyone know them?
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
