
DAO 3.5 ODBCDirect and stored procs help
you're right.. if the sql statement can't be parsed, for whatever reason, then
the parameters collection will be empty. if you're calling a stored procedure,
make sure the stored procedure is there, and executable. if it's a
parameterized query, make sure it's syntax is correct. try a simple 'SELECT *
FROM table WHERE column = ?' parameterized query to see if it gets parsed
correctly.
--
..........................................................
Fred Woolard
a4 Health Systems