[AccessD] Faking an SQL record

Eric Barro ebarro at verizon.net
Wed Feb 28 11:36:40 CST 2007


John,

What interface are you using? Is this in the Access query or SQL query
analyzer? If you run it in SQL query analyzer it runs fine.

Eric 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Wednesday, February 28, 2007 9:25 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Faking an SQL record

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". 


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 Eric Barro
Sent: Wednesday, February 28, 2007 12:18 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Faking an SQL record

SELECT  'HSomeCompanyName20061227' as MadeUp

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Wednesday, February 28, 2007 9:14 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Faking an SQL record

I vaguely remember someone supplying a syntax for "faking" a record in SQL
without having to actually supply a table name.
 
I want to return a single record from SQL that looks like:
 
HSomeCompanyName20061227
 
This is not data pulled out of any table, it is just "made up".
 
I can do this by aliasing the three fields and then telling SQL that it came
FROM SomeRealTable and then use a distinct clause etc.  But I seem to
remember some way of doing this without even supplying the name of a real
table.
 
Anyone have a clue what I am saying and how to do this?
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.4/705 - Release Date: 2/27/2007
3:24 PM
 

--
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

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.4/705 - Release Date: 2/27/2007
3:24 PM
 




More information about the AccessD mailing list