Hi Stephen, I was just wondering what component set adodb2000.pas came
from? Is that part of the Borland ADOExpress stuff, or another ADO library?
Mark
--On Wednesday, June 27, 2001 9:28 AM +1200 Stephen Barker
<[EMAIL PROTECTED]> wrote:
> 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
>
--
Vi de ud�delige inviterer dere til � sl� dere sammen med oss
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
