FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

Some problem related to use of param language using ctlib
- lang_ct_param test success but seem to add wrong value for date
(1900-1-1 instead of 2003-2-1)
- do not work in tds7+
mssql do not support language with params however has similar procedure
(sp_executesql). However current implementation (I wrote) in query.c is
completely wrong:
- sp_executesql want language before param description
sp_executesql statement, param_description, param1, param2...
(param_description is something like "@param1name int @param2name
vachar(20)" and so on..)
- params in ct lang are not specified with '?' (like dynamic query in
tds5) but with params convention (@name), so we should build param
description. For unnamed parameters specification we can extract params
name from statement but pay attention to statement like
"declare @i int select @param1" (require accurate statement parsing to
discover local variable names..)

freddy77