This was an ADO problem, but I have changed the data access to BDE
and the problem is still the same.....
D6, XP SP2
So,
I have an app that creates a T(ADO)StoredProcedure at runtime using a TADOConnection, sets the connection/database and creates 3 params.
Problem is, the params are being passed to the stored proc (on Sybase) by position, not name (I have proved this). The BDE version has ParamBindMode explictly set to ByName (but still seems to be using ByPosition), ADO doesn't appear to have a similar property.
Haven't seen this before!
Any ideas?
Cheers,
Martin.
and the problem is still the same.....
D6, XP SP2
So,
I have an app that creates a T(ADO)StoredProcedure at runtime using a TADOConnection, sets the connection/database and creates 3 params.
Problem is, the params are being passed to the stored proc (on Sybase) by position, not name (I have proved this). The BDE version has ParamBindMode explictly set to ByName (but still seems to be using ByPosition), ADO doesn't appear to have a similar property.
Haven't seen this before!
Any ideas?
Cheers,
Martin.