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.
Cannot use schema name with table name
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
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.
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.