[AccessD] Stupid SQL Tricks

Arthur Fuller artful at rogers.com
Thu Aug 12 12:28:03 CDT 2004


An Access table called StupidSQLTricks contains these columns:

PK AutoNumber PK
Select Text
>From Text
Where Text


A row in this table contains:

PK: 1
Select: *
From: Customers
Where: PK=1

A query on this table exists:

SELECT 
   StupidSQLTricks.PK, 
   StupidSQLTricks.[Select], 
   StupidSQLTricks.From, 
   StupidSQLTricks.Where, 
   "SELECT " & [Select] & " FROM " & [From] & " WHERE " & [Where] AS
[SQL]
FROM StupidSQLTricks
WHERE (((StupidSQLTricks.PK)=1));

The output of the last column (SQL) is:

SELECT * FROM Customers WHERE CustomerID='123'

------------------
This probably means that you could retrieve such a virtual column and
EVAL() it. But I haven't checked that out yet.




More information about the AccessD mailing list