H HirAsk Member Dec 15, 2007 #1 I am working over an SQL application and when I put this command: ALTER TALBE table1 RENAME TO newname And execute with: cmd.CommandText = ComandoString.Text cmd.ExecuteTable("Dbgrid",0) I receive this error: cmd.ExecuteTable("DBgrid",0) Error Description: Arithmetic operation resulted an overlow. How can I control that from the sintax error in the SQL command entry? Sorry for my very poor english... :sign0013: Last edited: Dec 15, 2007
I am working over an SQL application and when I put this command: ALTER TALBE table1 RENAME TO newname And execute with: cmd.CommandText = ComandoString.Text cmd.ExecuteTable("Dbgrid",0) I receive this error: cmd.ExecuteTable("DBgrid",0) Error Description: Arithmetic operation resulted an overlow. How can I control that from the sintax error in the SQL command entry? Sorry for my very poor english... :sign0013:
Erel B4X founder Staff member Licensed User Longtime User Dec 16, 2007 #2 You should use cmd.ExecuteNonQuery instead of cmd.ExecuteTable(...) as this command doesn't return any data.
You should use cmd.ExecuteNonQuery instead of cmd.ExecuteTable(...) as this command doesn't return any data.