i would like to update a single row in a table. in the past, i've set the source parameter for the recordset's Open method to a command text like
"SELECT * FROM table WHERE id=111". i know i can set the source to the
table name, but how do i get my single row? the Filter method? is there a
better way?
Re: extra index scans on update ... Perhaps datatype of colx and x are different. ... Only a single row is updated for each ... > If I run the same command again, it works much faster because there are ... When I run the same command again, the row is in the cache and things ... (microsoft.public.sqlserver.programming)
Reversing Dates on First Insert in DataEnvironment and VB6 ... I am using a Command to INSERT a single row INTO an Access table. ... Date/Time fields are causing me grief by reversing the Day and Month - but ...Dim dtEnd As Date ... (microsoft.public.vstudio.development)
Re: What is the Visual Basic command to select an entire row in Excel. ... Where Range is a cell address on the row you want to select. ... > single row in an Excel spreadsheet it selects all the rows in the ... Is there another command that will select a single row??... (microsoft.public.excel.programming)
Unix script question (basic) ... if we were to put this into a loop to read every single row in the file and ... if so what can we have for 'command'?...cat looks at a field at a time ... (comp.unix.questions)
Re: How do I do multiple asynchronous ADO connections ? ... >Look into the adAsyncFetch option of the Open Method on the Recordset ... I can't use that connection for another command.... 3711 "Operation cannot be performed while executing synchronously".... (microsoft.public.vb.general.discussion)
