Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by BrianGooch

  1. BrianGooch

    Feedback on TADO ... Delphi 2009

    Good Morning, A number of the issues concerning failures as set out in recent posts have been covered by CodeGear updates. Download Update3/4 from http://cc.embarcadero.com/item/26921 A list of items for Update 3 is in http://edn.embarcadero.com/article/39387 If you have Delphi...
  2. BrianGooch

    Runtime error TADOQuery, TADOCommand

    /Daddy, Thanks! Now I know I'm not going mad. Kind Regards, Brian Gooch
  3. BrianGooch

    Runtime error TADOQuery, TADOCommand

    Runtime Error from TADOQuery and TADOCommand Error message: 'Arguments of the wrong type, out of range, or in conflict with one another.' The following may help to explain some of our questions in previous posts. The whole of these TADO aspects have arisen because we wish to take the...
  4. BrianGooch

    Feedback: TADO Parameter failures

    whosrdaddy Thanks for the comment. The fatal error message from Delphi is always that it cannot find ClientQry parameter named 'xxxx'. It always fails to find it, or any of them, and the Parameters.Count = 0. As the on-line help stated: ParamByName for TADOQuery is not available; ParamByName is...
  5. BrianGooch

    Feedback: TADO Parameter failures

    Delphi 2009: why some TADO Parameter operations fail. TADOQuery: ParamByName not available - a little note in parentheses tucked away in the on-line help; nothing obvious about it. As a result you cannot create a collection of ADOQuery parameters: thus Parameters.AddParameter, CreateParameter...
  6. BrianGooch

    Assigning TADO Parameter Values

    Hi All, This isolates an explicit failure from my previous TADO posts. Reminder: Delphi 2009, Firebird 1.5, Win32, driver MSDASQL, Firebird driver ODBC 2.0.0.148. What is successful: 1. Retrieve from Server system tables SP parameter details via ADOQry1 2. Retrieve USERdata from Server SP...
  7. BrianGooch

    TADO Parameters behaving badly

    whosrdaddy Thankyou for your quick reply. However, it seems a little clarification is needed. Step 1: ADOQry1 reads the parameter details of the stored proc on the server. This gives all the Firebird metadata info for the input parameters of the QryClient, the direction being reversed prior to...
  8. BrianGooch

    TADO Parameters behaving badly

    whosrdaddy, Here's one which seems to have just one crucial failing - if I can solve that, we might be getting somewhere. start here>> // copy parameters from ADOQry1 to QryClient // Parameters.CreateParameter works but does not have all the attributes **** commence snippet **** for...
  9. BrianGooch

    TADO Parameters behaving badly

    /Daddy Good question. I had this idea of retrieving from the system tables via a TADOcommand the output parameters of an SP on a Server and using them as input parameters to a DB on to a client machine elsewhere on the network. The value of the parameters is USER data read from the Server via...
  10. BrianGooch

    TADO Parameters behaving badly

    Delphi 2009, Win32, Firebird 1.5 TADO parameters do not perform as stated in the on-line Help. All 3 examples are based on the same query with SQL on the fly, and Prepared 1. Parameters.AddParameter followed by Refresh clears the Parameters - thus, none in the Collection 2...
  11. BrianGooch

    TADOCommand.Parameters.GetParamList returns empty

    DjangMan Thanks, and for the example. Test Results: Just using the P[0] parameter docid, 113: remove Parameters.Clear : data retrieved Ok. also apply CreateParameters : empty result then apply Parameters.Refresh: data retrieval incorrect The incentive behind the GetParamList arises from not...
  12. BrianGooch

    TADOCommand.Parameters.GetParamList returns empty

    DjangMan Thankyou for your response. Unfortunately it does not resolve the issue. A code fragment follows. A number of combinations have been tried as can be seen from the commenting out - the errors have also been noted. This is test code only. try with AConnServer do begin Connected:=...
  13. BrianGooch

    TADOCommand.Parameters.GetParamList returns empty

    Hi Delphi 2009, Firebird 1.5, ODBC Driver Firebird 2.0.0 on win32. I have the following TADOCommand set as cmdType = cmdStoredProc cmdText ='StoredProcName' ConnectionString or Connection == Firebird/Interbase(r) Driver..... etc Provider = MSDASQL Connection works fine and the results...
See more

Part and Inventory Search

Back
Top