Skip to Content.
Sympa Menu

freetds - [freetds] ctlib - param language

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS <freetds AT lists.ibiblio.org>
  • Subject: [freetds] ctlib - param language
  • Date: 12 Mar 2003 14:48:34 +0100

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




  • [freetds] ctlib - param language, Frediano Ziglio, 03/12/2003

Archive powered by MHonArc 2.6.24.

Top of Page