Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > FAQ > General FAQ> Using a UNION statement with MSAccess
 

Pages: 1
General FAQ
Using a UNION statement with MSAccess
Page:1/1 

  Print all messages in this thread  
Poster Message
Aglaia
LLBLGen Pro Team



Location:
Scheveningen, The Netherlands
Joined on:
07-Sep-2003 21:16:00
Posted:
534 posts
# Posted on: 21-Aug-2007 14:13:38.  
Question:
I have an MS Access stored query which returns a SELECT using a UNION statement. It doesn't show up in my LLBLGen Pro project, is this an error/bug?

Solution:
The MS Access driver uses, among other things, OleDbConnection.GetOleDbSchemaTable() for retrieving the schema information. It turns out, if you use a UNION in your stored query, it doesn't show up in the list of views in the MS Access database. To work around this, create a new stored query which simply returns all the rows of the stored query that isn't seen by LLBLGen Pro and use that one instead.
Aglaia Kuipers, The LLBLGen Pro Team

Join the LLBLGen Pro support team!
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.