2011-06-28 15:30
Errica1983
Sveiki, gal kas pasakytų kaip taisyti tokią klaidą:
Neatpažinta klaida: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FUNCTION STATUS LIKE 'CROUND'' at line 1. No inner exception.
Objektas Object procedūra OpenPacket.
Stekas:
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at WindowsApplication1.SQLfunctions.SQLfill(String SQL, MySqlCommand& myCommand, DataTable& myData, Boolean& Klaida, Boolean Ignor, String& ErrMsg)
Per DB struktūra aktyvus mygtukas "TIKRINTI", jį paspaudus išmeta lentelę su šia klaida, o TAISYTI mygtukas neaktyvus. Del šios klaidos neatidaro nei sąskaitų registro, o kasos knygos duomenys iškraipyti.... HELP.