Print Page | Close Window

Query exception

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=416
Printed Date: 11-Jun-2026 at 8:54pm


Topic: Query exception
Posted By: hfeijt
Subject: Query exception
Date Posted: 08-Sep-2007 at 5:14am
Hello,
I'm a newbee to IdeaBlade and downloaded the express edition. I have generated a model from an Access database. Generation went well and connection is correct.
 
To test IdeaBlade I created a small WinForms application to show all the entities in a datagrid.
But I get an exception:
 
"Query contains syntax error. A query component is incomplete".
 
Below the code snippet of the code:
 

[DataObject]

public class DataService : IDataService

{

  private PersistenceManager _persistenceManager;

  protected PersistenceManager PersistenceManager

  {

    get

    {

       if (_persistenceManager == null)

{

_persistenceManager = new PersistenceManager();

}

return _persistenceManager;

}

}

public DataService()

{

PersistenceManager.Connect();

}

[DataObjectMethod(DataObjectMethodType.Select, true)]

public EntityList<Book> GetBooks()

{

EntityList<Book> result = null;

try

{

result = PersistenceManager.GetEntities<Book>();

}

catch (PersistenceServerException exc)

{

System.Windows.Forms.MessageBox.Show(exc.Message);

}

return result;

}

}




Replies:
Posted By: davidklitzke
Date Posted: 10-Sep-2007 at 9:37am
DevForce does not currently support the Access database.


Posted By: dbdemigod
Date Posted: 21-Sep-2007 at 1:03pm
Is there a timeline for Access support? I have a small data entry app that will end up on SQL Server, but not for a year or so... thank.


Posted By: davidklitzke
Date Posted: 21-Sep-2007 at 2:45pm
There is no timeline.



Print Page | Close Window