Unfortunately... The ONLY place I use the command object is in BD_SendSQLCommand() and I don't allow for it returning the single recordset that I give access to.
CommandTimeout and ConnectionTimeout aren't available to me in the recordset object (I use recset.Open "",...) to get the recordset. I can certainly change this but it would require me to rewrite almost all of my commands that use the recordset.
There's a lot of benefit to using the command object to return a recordset. Threre's a lot of options to run stored procedures and such.
So for now... I'm going to have to say no to the timeout thing. I will revist the issue though and rewrite the entire library.
Planned To Do:
Timeout implementation on queries, commands, connections
Metadata access
Here's the biggie... Multiple recordsets and connections.
But. I'm going to work on my game first so I'm thinking it's about 3 months out.
However, any bugs you find in this will be addressed promptly. Just let me know. I'll give it a few more days for any bugs found, and in the meantime I'll finish up docs. Make a few real demo programs for samples. And polish it up a bit before I release it in it's final form.
Kanati
CommandTimeout and ConnectionTimeout aren't available to me in the recordset object (I use recset.Open "",...) to get the recordset. I can certainly change this but it would require me to rewrite almost all of my commands that use the recordset.
There's a lot of benefit to using the command object to return a recordset. Threre's a lot of options to run stored procedures and such.
So for now... I'm going to have to say no to the timeout thing. I will revist the issue though and rewrite the entire library.
Planned To Do:
Timeout implementation on queries, commands, connections
Metadata access
Here's the biggie... Multiple recordsets and connections.
But. I'm going to work on my game first so I'm thinking it's about 3 months out.
However, any bugs you find in this will be addressed promptly. Just let me know. I'll give it a few more days for any bugs found, and in the meantime I'll finish up docs. Make a few real demo programs for samples. And polish it up a bit before I release it in it's final form.
Kanati