Error when attempting to upgrade

3 posts, 1 answers
  1. cayates
    cayates avatar
    71 posts
    Member since:
    Feb 2007

    Posted 17 Nov 2008 Link to this post

    I am getting a table or view cannot be found error after upgrading to telerik.  I turned on logging output and see it's because the new version is putting quotes arround voa_keygen.  The previous version did not so it was not case sensitive, however, now it is because of the quotes.

    I tried accessing the backend configuration dialog that used to be there but the only menu options I have are "Launch Telerik ORM Wizard" and "Enable Project to use ORM".  I tried running the enable project wizard and it finishes succesfully but the menu options don't change.

    When I right click in the project and try to expand the "Open Access" menu on the popup menu it just shows a blank sub-menu.

    Any help on how to get to the backend configuration and modify the keygen table name would be great.

    Thanks,

    Chris
  2. cayates
    cayates avatar
    71 posts
    Member since:
    Feb 2007

    Posted 17 Nov 2008 Link to this post

    As a follow up, I would also like to mention that I found that I could add:

    <ext.db-key-generator.keyColumnName>VOA_KEYGEN</ext.db-key-generator.keyColumnName>

    but it also puts double quotes around the column names as well, so it complains that the "last_used_id" and "table_name" column can't be found.  I see there's a way to specify the column name for "table_name" but I don't see the option for the "last_used_id" column name.  Even if I could I fear that I'm going to keep running into this case sensitivity problem.  So I need a way to turn off Telerik's use of the double quote in the generated SQL.

    Thank you,

    Chris
  3. DevCraft banner
  4. Answer
    Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 18 Nov 2008 Link to this post

    Hi Chris,

    the default highlow key generator can be configured in the backend section with

    <ext.db-key-generator.keyColumnName>table_name</ext.db-key-generator.keyColumnName>
    <ext.db-key-generator.valueColumnName>last_used_id</ext.db-key-generator.valueColumnName>
    <ext.db-key-generator.tableName>voa_keygen</ext.db-key-generator.tableName>

    so you can control all names used.

    But what you seem to need is to turn off the delimiting of identifiers, which is a different backend setting:

     <useDelimitedSQL>False</useDelimitedSQL>

    You can only turn it off, and when done so, there will be no delimitation been done in the SQL generated.

    Hope this helps,
    Thomas
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Back to Top