State-Changed-From-To: open-open
State-Changed-By: Cedric
State-Changed-When: Mon Apr 30 16:04:02 PDT 2001
State-Changed-Why:
Dear Loryn,

I looked into this problem and the problem seem to be that ODBC requires (in
'SQLBindParameter') to have the number of the parameter to replace, while
Oracle for instance needs the parameter name. EiffelStore implementation
(the HASH_TABLE) is only adapted for the Oracle interface and the
information "parameter number", required for ODBC, is not available. The
current implementation suggests to call the parameters used by their number
to solve this problem, for instance:

author, pages: STRING
selection: DB_SELECTION
(...)
selection.set_map_name (author, "1")
selection.set_map_name (pages, "2")
selection.query ("select * from BOOKS where author = :1 and pages = :2")

--
I unfortunately don't have a better short-term solution for this problem.

Concerning the EiffelStore/2809 bug, did you find out what was the problem?
(was it a problem with your ODBC driver?)