Search results for query: *

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...

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

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...

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...

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...

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...

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...

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...

/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...

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...

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...

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:=...

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...