[dba-SQLServer] Re: Update query through Access ADP

Francisco Tapia fhtapia at gmail.com
Fri Mar 11 13:05:34 CST 2005


IIRC you can set it to 0 for all records 


On Fri, 11 Mar 2005 08:06:33 -0600, Robert L. Stewart
<rl_stewart at highstream.net> wrote:
> Steve,
> 
> There is a property of the query where you can set the number of rows it
> returns.  The default is 10,000.  You just need to change it to 1,000,000
> so that you will always get all of them.
> 
> Robert
> 
> At 07:58 AM 3/11/2005 -0600, you wrote:
> >Date: Fri, 11 Mar 2005 07:51:53 -0600
> >From: Steve Erbach <erbachs at gmail.com>
> >Subject: [dba-SQLServer] Update query through Access ADP
> >To: dba-sqlserver at databaseadvisors.com
> >Message-ID: <39cb22f3050311055164bdfd7b at mail.gmail.com>
> >Content-Type: text/plain; charset=US-ASCII
> >
> >Dear Group,
> >
> >I've been looking through some of a client's ASP application with a
> >view to making some slight modifications. (There are almost 800 ASP
> >files. Yikes!)
> >
> >The back end is SQL Server and I've been using Access 2003 to
> >construct views and stored procedures. I've been working on a COPY of
> >the tables on my own SQL Server rather than the customer's live data.
> >
> >What's got me curious is this: I've been working with an sproc that
> >updates a column containing an email address. It looks something like
> >this:
> >
> >UPDATE Projects2
> >SET ContactEmail = NULL
> >WHERE (Contact = '') OR (Contact = ' ') OR (Contact IS NULL)
> >
> >So if the Contact name doesn't have anything in it, I want the
> >Contact's email address to be NULL. At present, there's a default
> >e-mail address in every row.
> >
> >After the sproc runs I look at the table itself. Well, this table has
> >133,000 records in it. Access 2003 shows me the first 10,000 by
> >default. But when I go past the 10,000th record, the e-mail column
> >still has addresses in it even though the Contact field is empty.
> >
> >Is there something I'm missing in the sproc? Something like a command
> >that says, "OK, I really, REALLY want to update the rows beyond
> >10,000, too."
> >
> >Regards,
> >
> >Steve Erbach
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 


-- 
-Francisco
http://pcthis.blogspot.com | PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...



More information about the dba-SQLServer mailing list