[AccessD] Selecting entire record

Max Wanadoo max.wanadoo at gmail.com
Thu Sep 17 14:13:22 CDT 2009


Did we just get a posting from SqlCentral as to why we should'nt use "*"?

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: 17 September 2009 19:53
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Selecting entire record

Isn't that what Select * is for?

Charlotte 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Thursday, September 17, 2009 11:20 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Selecting entire record

Is there a way, using code, to select an entire record using SQL? I
don't think there is, but I thought I'd ask, just in case.

It would nice to avoid a loop through the entire Fields collection, but
I think that's the only way to do it.

Susan H. 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list