Page 1 of 1

Error using Parameters in TUniQuery

Posted: Mon 24 Mar 2014 14:34
by kaiserilich
hi

I have a query write inside of a TUniQuery component

some like this:

Code: Select all

select data1.Id, data1.RS,
    :TipoP TPres
  from.....
but when try to execute display this error message:

Image

somebody can help me to solve this.?

i use:
Delphi 6 up 2
Unidac 5.2.7
ASE 12.5.4


thanks

Re: Error using Parameters in TUniQuery

Posted: Wed 26 Mar 2014 07:46
by AlexP
This problem only occurs in drivers v.12.5.1 and below, and is associated with the PrepareMethod ODBC parameter settings. We have fixed the problem by adding an option that is responsible for this parameter. This fix will be available in the next version of UniDAC.

Re: Error using Parameters in TUniQuery

Posted: Wed 26 Mar 2014 08:01
by kaiserilich
AlexP wrote:This problem only occurs in drivers v.12.5.1 and below, and is associated with the PrepareMethod ODBC parameter settings. We have fixed the problem by adding an option that is responsible for this parameter. This fix will be available in the next version of UniDAC.
thanks a lot, I wait for the new version.

Re: Error using Parameters in TUniQuery

Posted: Wed 26 Mar 2014 09:20
by AlexP
We plan to release a new version in the next month.

Re: Error using Parameters in TUniQuery

Posted: Tue 13 May 2014 11:19
by kaiserilich
just to informed to others users about the solution present on the version 5.3.8

on the UniConnection component must set the prepareMetrod option to pmFull

thanks a lot DevArt support Team.