Cannot use schema name with table name

Cannot use schema name with table name

Postby jswhal » Wed 16 Jan 2008 20:39

I have a MySqlDataSource bound to a gridview on an ASP.NET page. I need to specify the schema name with the table name, as I access tables in two different schemas.

DeleteCommand="DELETE FROM `chims.tasking` WHERE `ID` = ?">

When I click Delete on the grid, I get an error saying "Incorrect table name 'chims.tasking'. When I try and edit a row, when I click on Update, nothing happens - the row stays in edit mode.

The select statement works fine with the schema.table.
Posts: 6
Joined: Fri 28 Dec 2007 18:11

Postby Alexey.mdr » Thu 17 Jan 2008 12:03

We cannot reproduce the error.
Please send us a small test project to reproduce the problem. It is desirable to use 'test' schema objects, otherwise include the definition of your own database objects.
Do not use third party components.
If it is impossible for you to create the test project, send us a piece of your code where the error occurs.
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Return to dotConnect for MySQL