Name of parameters in

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jabu
Posts: 16
Joined: Fri 05 Nov 2004 11:47

Name of parameters in

Post by jabu » Fri 05 Nov 2004 12:04

Hello, when I use SQLGenerator (part of MSQuery Editor) it generate SQL scripts for Insert, Update, etc. with numeric notation of parameters (:1, :Old_1). Is possible to change mechanism of generation to name of field notation of parameters (for example - field "ID" -> :ID, :Old_ID)?

Thanks

Jabu

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: Name of parameters in

Post by Ikar » Mon 08 Nov 2004 14:46

jabu wrote:Hello, when I use SQLGenerator (part of MSQuery Editor) it generate SQL scripts for Insert, Update, etc. with numeric notation of parameters (:1, :Old_1). Is possible to change mechanism of generation to name of field notation of parameters (for example - field "ID" -> :ID, :Old_ID)?

Thanks

Jabu
No, this mechanism isn't provided. Using a numeric notation instead of a name lets greatly increase speed of processing queries with huge number of fields.

Post Reply