Error using Parameters in TUniQuery

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
kaiserilich
Posts: 23
Joined: Tue 23 Mar 2010 08:36
Location: spain
Contact:

Error using Parameters in TUniQuery

Post by kaiserilich » Mon 24 Mar 2014 14:34

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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Error using Parameters in TUniQuery

Post by AlexP » Wed 26 Mar 2014 07:46

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.

kaiserilich
Posts: 23
Joined: Tue 23 Mar 2010 08:36
Location: spain
Contact:

Re: Error using Parameters in TUniQuery

Post by kaiserilich » Wed 26 Mar 2014 08:01

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.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Error using Parameters in TUniQuery

Post by AlexP » Wed 26 Mar 2014 09:20

We plan to release a new version in the next month.

kaiserilich
Posts: 23
Joined: Tue 23 Mar 2010 08:36
Location: spain
Contact:

Re: Error using Parameters in TUniQuery

Post by kaiserilich » Tue 13 May 2014 11:19

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.

Post Reply