DescribeParams

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jan.javurek@floresps.cz
Posts: 20
Joined: Fri 29 Jan 2010 10:05
Contact:

DescribeParams

Post by jan.javurek@floresps.cz » Mon 29 Nov 2010 03:52

ENGLISH:
Hello,

Query.SQL.Text: = 'SELECT * FROM STORECARS.Code = :Code'
Query.Prepare;

Evaluate Query.FieldDefs [0]. DataType = ftUnknown

How do I keep TMSQuery returned the correct data type parameter?

The solution is somehow characteristic DescribeParams how to turn it on and use?
Thank you for your reply.

CZECH:
Dobrý den,

Query.SQL.Text := 'SELECT * FROM STORECARS.Code = :Code'
Query.Prepare;

Query.FieldDefs[0].DataType = ftUnknown

Jak zajistím, aby TMSQuery vrátilo správný datový typ parametru?

Řeší to nějak vlastnost DescribeParams, jak jí zapnout a používat?
Děkuji za odpoveď.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 30 Nov 2010 08:26

To solve the problem set the TMSQuery.Options.DescribeParams property to True.

jan.javurek@floresps.cz
Posts: 20
Joined: Fri 29 Jan 2010 10:05
Contact:

thank you

Post by jan.javurek@floresps.cz » Thu 02 Dec 2010 23:24

thank you

Post Reply