Page 1 of 1

Cannot use schema name with table name

Posted: Wed 16 Jan 2008 20:39
by jswhal
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.

Posted: Thu 17 Jan 2008 12:03
by Alexey.mdr
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.