Page 1 of 1
Name of parameters in
Posted: Fri 05 Nov 2004 12:04
by jabu
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
Re: Name of parameters in
Posted: Mon 08 Nov 2004 14:46
by Ikar
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.