🚀 go-pugleaf

Hi Ephraim,

> The form method below results in a Sybase OCBC Error "Wrong Number of
> Parameters"
> I observe (cmd.parameters) that 16 parameters are created although only 5
> are populated, the rest are null. Is this normal?

Doesn't appear normal to me. Perhaps you could clear the parameter list 
before you start to add your five?

> function TForm4.InsertMoc(const SerialId, CallOrigin, CallDestination,
> TransactionID, TimeStamp: String): Integer;
> const
>   c_cnstr='DSN=sybCK';
>   c_sp='sp_InsertNOC';
> var
>   k: Integer;
>   sqlcn: ODBCConnection;
>   cmd: ODBCCommand;
>   param: ODBCParameter;
> begin
>   try
>     sqlcn:=ODBCConnection.Create(c_cnstr);
>     cmd:=ODBCCommand.Create(c_sp, sqlcn);
>     cmd.CommandType:=CommandType.StoredProcedure;

       cmd.Parameters.Clear; // or a similar method to clear the list

>     param:=cmd.Parameters.Add('serialid', ODBCType.Char, 20);
>     param.Value:=SerialID;

Groetjes,
           Bob Swart

-- 
Bob Swart Training & Consultancy (eBob42.com)  Forever Loyal to Delphi
Blog: http://www.drbob42.com/blog - RSS: http://drbob42.com/weblog.xml
New Delphi 2006 Courseware e-books at http://www.eBob42.com/courseware