LeanneGodney
Technical User
Hehe... Does my subject make sense? ;0)
I need an adodb.recordset to grab data from two separate tables using a typical join. But when this recordset is created it refuses to allow additions to it (although I am able to edit existing records). I'm not interested in the unique table property, as my data is disconnected.
Does anyone know how to create a stored procedure that returns a table variable that can be added to and also edited?
My current work around is that I've created an empty table with the fields that I want, etc, disconnects from the actual table , and my code then adds the relevant records and allows the user to add/update/delete etc. On closing the form the disconnected recordset then triggers an update/append/delete statement depending on what the user does to the data.
Any ideas on using a store proc as the basis for this recordset would be most appreciated!!
I need an adodb.recordset to grab data from two separate tables using a typical join. But when this recordset is created it refuses to allow additions to it (although I am able to edit existing records). I'm not interested in the unique table property, as my data is disconnected.
Does anyone know how to create a stored procedure that returns a table variable that can be added to and also edited?
My current work around is that I've created an empty table with the fields that I want, etc, disconnects from the actual table , and my code then adds the relevant records and allows the user to add/update/delete etc. On closing the form the disconnected recordset then triggers an update/append/delete statement depending on what the user does to the data.
Any ideas on using a store proc as the basis for this recordset would be most appreciated!!