Re: ConnectionWrite WrapperWriteOOB Error - Urgent

2. I am shocked that 'connUsers.execute "DELETE FROM Table1"' was your
second choice. Never use a recordset to do what can be done via a single
set operation. I can offer an improvement:

Me too. The programmer would be dismissed in under a day here.
I am stunned that RecordSets is considered as a first option compared to 1
line of SQL.

Stephen Howe






.

Relevant Pages

  • Re: ADO Shape and Subqueries
    ... > the second recordset, since you suggest making two recordsets insted of ... I have no idea if it is a limitaiton of the provider or SQL Server or ADO. ... That means the programmer asking for help here has got to be prepared to do ...
    (microsoft.public.data.ado)
  • Re: Recordset or Object is closed HELP PLEASE!
    ... The reason why I was trying to move to the next recordset ... somehow SQL Server was returning two or three recordsets ... other SET operation. ... why are you moving to the next ...
    (microsoft.public.excel.programming)
  • Find without a recordset?
    ... I am running SQL2K on Win2K. ... through a recordset and using the .find method. ... Programmer / Processor ...
    (microsoft.public.sqlserver.programming)
  • Re: SELECT * Happy!
    ... You need a recordset that contains all of the fields, ... The programmer only ever does AddNew so I ... ' OPEN THE LOAD LOG ...
    (microsoft.public.access.modulesdaovba)