Niemand rašė:
Prisijunkit prie įmonės; Bendras\Query browser; įvykdykite užklausas:
"SELECT * FROM turtas t;"
"SELECT * FROM turtas t LEFT JOIN bz b ON b.Op_ID=t.Isigijimo_dok;"
(be kabučių su kabliataškiu, paeiliui)
Tada parašykite: ar pirma užklausa išmetė turto sąrašą; ar antra užklausa pridėjo stulpelius su įsigijimo doko duomenimis.
Man IT masinės operacijos sąraše neatsirado. Įvykdžius užklausas rodo atitinkamai:
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 '"SELECT * FROM turtas t;"' 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)
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 '"SELECT * FROM turtas t LEFT JOIN bz b ON b.Op_ID=t.Isigijimo_dok;"' 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)