🚀 go-pugleaf

Foo Tze Wan:

Did you ever get this to work?  I am having a similar problem, and I can not 
find a solution.

I dropped a TADOCommand component onto my form and added these 11 parameters 
to the ADOCommand1->Parameters list:

DataType  Direction  Name  NumericScale  Precision  Size  Value
ftLargeint pdInput   pSP   0             9          0     (Null)
ftString   pdInput   pDe   0             0          50    (Null)
ftLargeint pdInput   pLe   0             9          0     (Null)
ftFloat    pdInput   pRs   10            20         0     (Null)
ftFloat    pdInput   pOs   10            20         0     (Null)
ftFloat    pdInput   pMn   10            20         0     (Null)
ftFloat    pdInput   pMx   10            20         0     (Null)
ftString   pdInput   pUt   0             0          7     (Null)
ftLargeint pdInput   pSp   0             9          0     (Null)
ftLargeint pdInput   pPG   0             9          0     (Null)
ftLargeint pdInput   pBt   0             9          0     (Null)

I have created my INSERT SQL command:

  ADOCommand1->CommandText =
    AnsiString("INSERT INTO SPNs (SPN, Desc, Len, Res, Ofs, ") +
    AnsiString(         "Min, Max, Unit, Sus, PGN, start) ") +
    AnsiString("VALUES (:pSP, :pDe, :pLe, :pRs, :pOs, ") +
    AnsiString(         ":pMn, :pMx, :pUt, :pSp, :pPG, :pBt)");


When I try to assign values to any of my Parameters like this:

  ADOCommand1->Parameters->ParamByName("pSP")->Value = 94;

I get the error: "ADOCommandUser: Parameter 'pSP' not found"

How do I get around this?

Have I set up my parameters incorrectly?

Would it help to set all of the DataTypes to ftVariant?

If I use ftVariant, how do I set up the other Parameter fields to accept 
integers, strings and doubles?

Poojo