Getting valid DataType's for params

[chkaufmann]

Hi,

I have a TUniQuery with parameters (:PID, :PDATA). After I set the connection and the SQL.Text, is there a way to know, what DataType values will be valid, depending on the database behind the connection?

Or is it possible to get these details if I know, that it is a certain database, e.g. MS SQL Server?


Example:

"select * from DATATABLE where ID = :PID"

Here I would like to know, what DataType I should use for the parameter.

cu Christian

[Dimon]

You can set the DescribeParams specific option of TUniQuery to get parameter types. But this functionality works only for InterBase server, and we will support it for MSSQL Server in the next UniDAC build.