This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I get an SQL exception after I changed the entity name in the designer.
Is it at all possible to have for example a table 'tbl_User' linked to an entity 'User'.
Thanks for your response. |
|
|
|
|
... Please forgive my ignorance :o)
I can see that it is possible to set a different name and table name property. I just altered it in the designer, but that is clearly not the way to go. |
|
|
|
|
Au contraire, that's exactly the way to go -- this is exactly what the Table Name setting is for *grin*. Drag the tbl_User table on from the database. This creates an entity called tblUser. Click on the name tblUser, and change it to User. Then (with the entity still selected) go to the Properties window and find the Table Name setting. If this doesn't already say tbl_User, then change it to tbl_User. You should now be good to go! |
|
|
|
