[AccessD] Faking an SQL record

Bueno, Thanks Gustav, that's the one.


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, February 28, 2007 12:49 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Faking an SQL record

Hi John

  SELECT TOP 1 
    "HSomeCompanyName20061227" AS Company
  FROM 
    MSysObjects;

/gustav

>>> jwcolby at colbyconsulting.com 28-02-2007 18:24:46 >>>
Eric, if I don't include a FROM clause, the bang symbol doesn't ungray and
allow me to run the query.  If I put in FROM SomeMadeUpTableName I get an
error when I run the query that it "can't find SomeMadeUpTableName". 



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