Cannot use schema name with table name
Posted: 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.
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.