Re: ConnectionWrite WrapperWriteOOB Error - Urgent

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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: Do I need to close a recordset clone like a table recordset?
    ... You should always close and set to nothing recordset objects ... a recordset clone shares a recordset, so it is not safe to close. ... If you choose to global recordsets for speed anyway, ... Of course, if you are a C programmer, you will not feel comfortable ...
    (microsoft.public.access.security)
  • 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)