ADO in D7

Hello,

i just started using ADO in D7 pro (update 1) and found out, that if i have
a query with one parameter, but 2 times used, like
'select cast(:id as varchar), t.* from table t where id = :id'
and in the program i only do a
query.Parameters.ParamByName('id').Value := 123;
then this will not read record with id 123, even if this record exists.
I have to do a
query.Parameters[0].Value := 123;
query.Parameters[1].Value := 123;
to get what i want.

Is this a known bug, is there an update or fix available?

thanks, Helmut
.

Relevant Pages

  • Re: i know its a floating-point imprecision...
    ... Looks like EM and ADO are both casting the value to some fixed precision ... > In Query Analyzer: ... > I understand that the value is stored in SQL Server using floating points. ... > But how is it that QA is able to show me the imprecision inherient in> floating points; while EM and ADO can transparently "fix" it? ...
    (microsoft.public.sqlserver.server)
  • RE: ODBC query in VB code Need HELP
    ... Everything for ADO is in the first 2 messages that I gave you. ... Since your pass-through query already exists (including the ... Dim STRSQL As String ...
    (microsoft.public.access.formscoding)
  • Re: Connecting to Query
    ... practice examples of the ADO Command, Parameters, etc. you explained below. ... Second, with the selected territory ... >> combo box to select a product from a query based primarily on a link ...
    (microsoft.public.access.formscoding)
  • Re: On ADSI and LDAP
    ... the problem is how can I retrieve the value for myuser using the ... would be more efficient to use ADO to query AD for the attributes values. ... For more on using ADO, ... Dim adoCommand, adoConnection, strBase, strFilter, strAttributes ...
    (microsoft.public.scripting.vbscript)
  • Re: cant get query to run over ADO, but works fine in Access inte
    ... Thanks for the suggestions, Richard. ... the query so that unchanging parts of it are stored as a query with the part ... As I've had trouble with synchronizing ADO ... > Execute method of the ADO Connection object, but the issue is the same - you ...
    (microsoft.public.data.ado)