Mark,
I found the following in adodb2000.pas
// Constants for enum ParameterAttributesEnum
type
ParameterAttributesEnum = TOleEnum;
const
adParamSigned = $00000010;
adParamNullable = $00000040;
adParamLong = $00000080;
// Constants for enum ParameterDirectionEnum
type
ParameterDirectionEnum = TOleEnum;
const
adParamUnknown = $00000000;
adParamInput = $00000001;
adParamOutput = $00000002;
adParamInputOutput = $00000003;
adParamReturnValue = $00000004;
// Constants for enum CommandTypeEnum
type
CommandTypeEnum = TOleEnum;
const
adCmdUnspecified = $FFFFFFFF;
adCmdUnknown = $00000008;
adCmdText = $00000001;
adCmdTable = $00000002;
adCmdStoredProc = $00000004;
adCmdFile = $00000100;
adCmdTableDirect = $00000200;
regards,
Steve
> -----Original Message-----
> From: Mark Derricutt [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 27 June 2001 00:38
> To: Multiple recipients of list database
> Subject: [DUG-DB]: ADODB.Command
>
>
> '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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
