M MikeJ Apr 22, 2007 #1 hi i can't seem to find the readonly for sql How to set when reading Recordset from Sql as Readonly Tia MikeJ
hi i can't seem to find the readonly for sql How to set when reading Recordset from Sql as Readonly Tia MikeJ
? =?ISO-8859-1?Q?G=F6ran_Andersson?= Apr 22, 2007 #2 MikeJ said: hi i can't seem to find the readonly for sql How to set when reading Recordset from Sql as Readonly Tia MikeJ Click to expand... You specify the cursor type and lock type when you open the recordset. That decides how you can use the recordset.
MikeJ said: hi i can't seem to find the readonly for sql How to set when reading Recordset from Sql as Readonly Tia MikeJ Click to expand... You specify the cursor type and lock type when you open the recordset. That decides how you can use the recordset.
? =?ISO-8859-1?Q?G=F6ran_Andersson?= Apr 24, 2007 #4 Mike said: Right....i am having problems finding it on msdn... i'll look again Göran Andersson said: You specify the cursor type and lock type when you open the recordset. That decides how you can use the recordset. Click to expand... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthrstopen.asp Click to expand...
Mike said: Right....i am having problems finding it on msdn... i'll look again Göran Andersson said: You specify the cursor type and lock type when you open the recordset. That decides how you can use the recordset. Click to expand... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthrstopen.asp Click to expand...
? =?ISO-8859-1?Q?G=F6ran_Andersson?= Apr 27, 2007 #6 Mike said: your link is Ado 2.8 not net how is this implemented in net 2.0 MJ Göran Andersson said: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthrstopen.asp Click to expand... There is no Recordset object in the .NET framework, that's why I assumed that you meant the ADO Recordset. The DataReader classes in .NET are always read-only. Click to expand...
Mike said: your link is Ado 2.8 not net how is this implemented in net 2.0 MJ Göran Andersson said: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthrstopen.asp Click to expand... There is no Recordset object in the .NET framework, that's why I assumed that you meant the ADO Recordset. The DataReader classes in .NET are always read-only. Click to expand...