Nemokama apskaitos programa

Dar truputis klaidų. Ar čia man vienai?

DataPortal.Fetch failed (System.Exception: Klaida vykdant SELECT sakinį (statement): [SELECT b.Op_ID, b.Op_data, b.Op_Dok, b.Op_turinys, b.Op_dok_rusis, b.Op_analitika, a.Pavad, a.Kodas, a.Adresas, g.Op_tipas, g.Op_suma, g.Op_ana, c.Pavad, c.Kodas, c.Adresas, b.Op_korespond FROM bzdata g LEFT JOIN bz b ON g.Op_ID_BZ=b.Op_ID AND LOCATE($SS, CAST(g.Op_saskaita AS CHAR))=1 LEFT JOIN asmenys a ON a.ID=b.Op_analitika LEFT JOIN asmenys c ON c.ID=g.Op_ana WHERE b.Op_data>=$DF AND b.Op_data<=$DT ORDER BY b.Op_data, b.Op_Dok;=b.Op_ID AND LOCATE($SS, CAST(g.Op_saskaita AS CHAR))=1 LEFT JOIN asmenys a ON a.ID=b.Op_analitika LEFT JOIN asmenys c ON c.ID=g.Op_ana WHERE b.Op_data>=$DF AND b.Op_data<=$DT ORDER BY b.Op_data, b.Op_Dok;], Params: ?DF=2014.01.01; ?DT=2015.01.03; ?SS=412;
Klaidos turinys: 'SQLite error

Meta, kai darau sąskaitos apyvartos žurnalo išrašą.

Taip gali nutikti, jei duomenyse, pvz, adrese, naudojami tab ir naujos eilutės simboliai, reikia juos išgaudyti.

nukirpot klaidos tekstą...

DataPortal.Fetch failed (System.Exception: Klaida vykdant SELECT sakinį (statement): [SELECT b.Op_ID, b.Op_data, b.Op_Dok, b.Op_turinys, b.Op_dok_rusis, b.Op_analitika, a.Pavad, a.Kodas, a.Adresas, g.Op_tipas, g.Op_suma, g.Op_ana, c.Pavad, c.Kodas, c.Adresas, b.Op_korespond FROM bzdata g LEFT JOIN bz b ON g.Op_ID_BZ=b.Op_ID AND LOCATE($SS, CAST(g.Op_saskaita AS CHAR))=1 LEFT JOIN asmenys a ON a.ID=b.Op_analitika LEFT JOIN asmenys c ON c.ID=g.Op_ana WHERE b.Op_data>=$DF AND b.Op_data<=$DT ORDER BY b.Op_data, b.Op_Dok;=b.Op_ID AND LOCATE($SS, CAST(g.Op_saskaita AS CHAR))=1 LEFT JOIN asmenys a ON a.ID=b.Op_analitika LEFT JOIN asmenys c ON c.ID=g.Op_ana WHERE b.Op_data>=$DF AND b.Op_data<=$DT ORDER BY b.Op_data, b.Op_Dok;], Params: ?DF=2014.01.01; ?DT=2015.01.03; ?SS=412;
Klaidos turinys: 'SQLite error
no such function: LOCATE'. ---> System.Data.SQLite.SQLiteException: SQLite error
no such function: LOCATE
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.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 AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
--- End of inner exception stack trace ---
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.ActiveReports.BookEntryInfoListParent.DataPortal_Fetch(Criteria criteria))

Čia kai paspaudi detaliau:

Klaidos duomenys:
Klaidos tekstas:
DataPortal.Fetch failed (System.Exception: Klaida vykdant SELECT sakinį (statement): [SELECT b.Op_ID, b.Op_data, b.Op_Dok, b.Op_turinys, b.Op_dok_rusis, b.Op_analitika, a.Pavad, a.Kodas, a.Adresas, g.Op_tipas, g.Op_suma, g.Op_ana, c.Pavad, c.Kodas, c.Adresas, b.Op_korespond FROM bzdata g LEFT JOIN bz b ON g.Op_ID_BZ=b.Op_ID AND LOCATE($SS, CAST(g.Op_saskaita AS CHAR))=1 LEFT JOIN asmenys a ON a.ID=b.Op_analitika LEFT JOIN asmenys c ON c.ID=g.Op_ana WHERE b.Op_data>=$DF AND b.Op_data<=$DT ORDER BY b.Op_data, b.Op_Dok;=b.Op_ID AND LOCATE($SS, CAST(g.Op_saskaita AS CHAR))=1 LEFT JOIN asmenys a ON a.ID=b.Op_analitika LEFT JOIN asmenys c ON c.ID=g.Op_ana WHERE b.Op_data>=$DF AND b.Op_data<=$DT ORDER BY b.Op_data, b.Op_Dok;], Params: ?DF=2014.01.01; ?DT=2015.01.03; ?SS=412;
Klaidos turinys: 'SQLite error
no such function: LOCATE'. ---> System.Data.SQLite.SQLiteException: SQLite error
no such function: LOCATE
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.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 AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
--- End of inner exception stack trace ---
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.ActiveReports.BookEntryInfoListParent.DataPortal_Fetch(Criteria criteria))
Klaidos šaltinis(Ex.Source):
Apskaita5
Klaidos metodas (Ex.TargetSite):
LoadObject
Klaidos stekas:
at ApskaitaWUI.BOMapper.LoadObject[T](T ObjectInstance, String MethodName, Boolean AllowCancel, Object[] Params)
at ApskaitaWUI.F_AccountTurnoverInfo.RefreshButton_Click(Object sender, EventArgs e)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Exception has been thrown by the target of an invocation.
Klaidos šaltinis(Ex.Source):
mscorlib
Klaidos metodas (Ex.TargetSite):
_InvokeMethodFast
Klaidos stekas:
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at ApskaitaWUI.AsyncOperation`1.Fetch_DoWork(Object sender, DoWorkEventArgs e)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal.Fetch failed (System.Exception: Klaida vykdant SELECT sakinį (statement): [SELECT b.Op_ID, b.Op_data, b.Op_Dok, b.Op_turinys, b.Op_dok_rusis, b.Op_analitika, a.Pavad, a.Kodas, a.Adresas, g.Op_tipas, g.Op_suma, g.Op_ana, c.Pavad, c.Kodas, c.Adresas, b.Op_korespond FROM bzdata g LEFT JOIN bz b ON g.Op_ID_BZ=b.Op_ID AND LOCATE($SS, CAST(g.Op_saskaita AS CHAR))=1 LEFT JOIN asmenys a ON a.ID=b.Op_analitika LEFT JOIN asmenys c ON c.ID=g.Op_ana WHERE b.Op_data>=$DF AND b.Op_data<=$DT ORDER BY b.Op_data, b.Op_Dok;=b.Op_ID AND LOCATE($SS, CAST(g.Op_saskaita AS CHAR))=1 LEFT JOIN asmenys a ON a.ID=b.Op_analitika LEFT JOIN asmenys c ON c.ID=g.Op_ana WHERE b.Op_data>=$DF AND b.Op_data<=$DT ORDER BY b.Op_data, b.Op_Dok;], Params: ?DF=2014.01.01; ?DT=2015.01.03; ?SS=412;
Klaidos turinys: 'SQLite error
no such function: LOCATE'. ---> System.Data.SQLite.SQLiteException: SQLite error
no such function: LOCATE
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.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 AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
--- End of inner exception stack trace ---
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.ActiveReports.BookEntryInfoListParent.DataPortal_Fetch(Criteria criteria))
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Fetch
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.ActiveReports.BookEntryInfoListParent.DataPortal_Fetch(Criteria criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.Server.SimpleDataPortal.Fetch(Type objectType, Object criteria, DataPortalContext context)
at Csla.DataPortal.Fetch(Type objectType, Object criteria)
at Csla.DataPortal.Fetch[T](Object criteria)
at ApskaitaObjects.ActiveReports.BookEntryInfoListParent.GetBookEntryInfoListParent(DateTime nDateFrom, DateTime nDateTo, Int32 nAccount, PersonInfo nPerson, PersonGroupInfo nGroup, Boolean nIncludeSubAccounts)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal_Fetch method call failed
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
CallMethod
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.ActiveReports.BookEntryInfoListParent.DataPortal_Fetch(Criteria criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.Server.SimpleDataPortal.Fetch(Type objectType, Object criteria, DataPortalContext context)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Klaida vykdant SELECT sakinį (statement): [SELECT b.Op_ID, b.Op_data, b.Op_Dok, b.Op_turinys, b.Op_dok_rusis, b.Op_analitika, a.Pavad, a.Kodas, a.Adresas, g.Op_tipas, g.Op_suma, g.Op_ana, c.Pavad, c.Kodas, c.Adresas, b.Op_korespond FROM bzdata g LEFT JOIN bz b ON g.Op_ID_BZ=b.Op_ID AND LOCATE($SS, CAST(g.Op_saskaita AS CHAR))=1 LEFT JOIN asmenys a ON a.ID=b.Op_analitika LEFT JOIN asmenys c ON c.ID=g.Op_ana WHERE b.Op_data>=$DF AND b.Op_data<=$DT ORDER BY b.Op_data, b.Op_Dok;=b.Op_ID AND LOCATE($SS, CAST(g.Op_saskaita AS CHAR))=1 LEFT JOIN asmenys a ON a.ID=b.Op_analitika LEFT JOIN asmenys c ON c.ID=g.Op_ana WHERE b.Op_data>=$DF AND b.Op_data<=$DT ORDER BY b.Op_data, b.Op_Dok;], Params: ?DF=2014.01.01; ?DT=2015.01.03; ?SS=412;
Klaidos turinys: 'SQLite error
no such function: LOCATE'.
Klaidos šaltinis(Ex.Source):
AccDataAccessLayer
Klaidos metodas (Ex.TargetSite):
FetchCommand
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.ActiveReports.BookEntryInfoListParent.DataPortal_Fetch(Criteria criteria)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
SQLite error
no such function: LOCATE
Klaidos šaltinis(Ex.Source):
System.Data.SQLite
Klaidos metodas (Ex.TargetSite):
Prepare
Klaidos stekas:
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.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 AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)

Registruojant sąskaitą faktūrą, pasirenku sąnaudų sąskaitą iš duoto sąskaitų plano. Anksčiau būdavo, įrašai pavyzdžiui 6 (sąnaudų klasę) ir pateikiamas sąskaitų planas nuo 6-os klasės. Dabar reikia pereiti per visą sąskaitų planą, kol pasieki 6-os klasės sąskaitas.
Tiesiog langelyje pradžioje rodomas nulis.

Sveiki, paskaičiau, kad visai nebloga programa čia :) Turiu mažą įmonę kuriai naudojau BC plius programą. Už atnaujinimą ir pakeitimą į eurus nelogiškai užsiprašė, tai ieškau kažko naujo ir paprasto. Man tereikia sandėlio, SF registras ir išrašymas. Tik va ar įmanoma iš mano senos programos perkelti duominis į šią? Prekių įvairovė siekia virš kelių tūkstančių, nesinorėtu viska rankiniu būdu suvesti :(

Dabar reikia papildomai paspausti backspace, su laiku gal sugalvosiu kokį pagerinimą.

Bendrus duomenis galima importuoti. Likučius pgl sandėlius rankomis.

joooo, bus ka veikti

Darau avansinę apyskaitą.
Ten, kur reikia pridėti sąskaitą faktūrą. Su data ir kontrahentu viskas gerai. Bet nerodo, sąskaitos faktūros numerio, kurią pasirinkti, o siūlo rinktis pagal turinį. Jei yra kelios sąskaitos tos pačios dienos ir tokiu pačiu turiniu, prideda tą pačią sąskaitą du kartus.
Anksčiau leisdavo pasirinktį pagal sąskaitos numerį.
Ir dar. Kaip išmesti eilutę iš avansinės apyskaitos, kuri neteisingai įsikėlė ( du kartus ta pati sąskaita).

Pardon. Buvau nurodęs neteisingą tiekojo sąskaitą, nurodžius tiekėjo sąskaitą "443" SF įsirašė. Tik sąskaita 443, "skolos tiekėjams" vadinasi, ...o galima kaip nors be skolos užvadinti?....

Ačiū!

Sveiki dar kartą,

apyvartos žiniaraščio, bet kokią sąskaitą pasirinkus, meta klaidą.

Piniginių lėšų sąskaitos - visus skaičius suapvalina. 9,52 įvedus, vėliau atsidarius rodo 10,00.

Ar į avansinę apyskaitą galima įtraukti tik sąskaitas faktūras?
Turiu pasidariusi pirkto kuro suvestinę ( kad nereikėtų visų čekiukų suvedinėti). Kaip ją įtraukti į avansinę apyskaitą?

Sveiki, Niemand,
vedant sąskaitų likučius, pasiekus maždaug 15 ar 16 poziciją meta lentelę, kad klaidą, paspaudus detaliau rašo
(tas pats debete ir kredite kai noriu pasirinkti sąskaitos Nr. iš sąskaitų plano)
Klaidos duomenys:
Klaidos tekstas:
Cannot access a disposed object.
Object name: 'ToolStripDropDown'.
Klaidos šaltinis(Ex.Source):
System.Windows.Forms
Klaidos metodas (Ex.TargetSite):
CreateHandle
Klaidos stekas:
at System.Windows.Forms.Control.CreateHandle()
at System.Windows.Forms.ToolStripDropDown.CreateHandle()
at System.Windows.Forms.Control.get_Handle()
at System.Windows.Forms.ToolTip.get_CreateParams()
at System.Windows.Forms.ToolTip.CreateHandle()
at System.Windows.Forms.ToolTip.get_Handle()
at System.Windows.Forms.ToolTip.SetToolInfo(Control ctl, String caption)
at System.Windows.Forms.ToolTip.Hide(IWin32Window win)
at System.Windows.Forms.DataGridView.DataGridViewToolTip.Activate(Boolean activate)
at System.Windows.Forms.DataGridView.ActivateToolTip(Boolean activate, String toolTipText, Int32 columnIndex, Int32 rowIndex)
at System.Windows.Forms.DataGridViewCell.OnCellDataAreaMouseLeaveInternal()
at System.Windows.Forms.DataGridViewCell.OnMouseLeaveInternal(Int32 rowIndex)
at System.Windows.Forms.DataGridView.OnCellMouseLeave(DataGridViewCellEventArgs e)
at System.Windows.Forms.DataGridView.UpdateMouseEnteredCell(HitTestInfo hti, MouseEventArgs e)
at System.Windows.Forms.DataGridView.OnMouseMove(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseMove(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.DataGridView.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Na, dar klaidelių:
1. Ilgalaikio turto kataloge pasirinkus turto poziciją ir atsidarius Operacijų su ilgalaikiu turtu suvestinę ir spaudžiant nauja op. išmeta:
Klaida vykdant SELECT sakinį (statement): [SELECT t.Turtas, t.Vnt, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='aqs' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.Saskaita) AS AccountAcquisition, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='amr' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountAmortization) AS AccountAmmortization, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vld' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueDecrease) AS AccountValueDecrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vli' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueIncrease) AS AccountValueIncrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vam' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountRevaluedPortionAmmortization) AS AccountRevaluedPortionAmmortization, b.Op_data, t.Isigijimo_dok, t.Likutine, t.ContinuedUsage, t.Kiekis, t.Vnt_kaina, t.TotalValue, t.AcquisitionRevaluedPortionUnitValue, t.AcquisitionRevaluedPortionTotalValue, t.AccumulatedAmortizationPerUnit, t.S_Amort, t.AccumulatedAmortizationRevaluedPortionPerUnit, t.AccumulatedAmortizationRevaluedPortionTotal, IFNULL((SELECT d.NewAmortizationPeriod FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='alk' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.DefaultAmortPeriod) AS AmmortizationPeriodChanged, t.WasUsedMonths, l.AmmountChange, l.UnitValueChange, l.TotalValueChange, l.RevaluedPortionUnitValueChange, l.RevaluedPortionTotalValueChange, l.AcquisitionAccountChange, l.AcquisitionAccountChangePerUnit, l.AmortizationAccountChange, l.AmortizationAccountChangePerUnit, l.ValueDecreaseAccountChange, l.ValueDecreaseAccountChangePerUnit, l.ValueIncreaseAccountChange, l.ValueIncreaseAccountChangePerUnit, l.ValueIncreaseAmmortizationAccountChange, l.ValueIncreaseAmmortizationAccountChangePerUnit, l.AmortizationCalculatedForMonths, l.UsageStatus FROM turtas t LEFT JOIN bz b ON b.Op_ID=t.Isigijimo_dok LEFT JOIN (SELECT t.T_ID, -SUM(t.AmmountChange) AS AmmountChange, SUM(t.UnitValueChange) AS UnitValueChange, SUM(t.TotalValueChange) AS TotalValueChange, SUM(t.RevaluedPortionUnitValueChange) AS RevaluedPortionUnitValueChange, SUM(t.RevaluedPortionTotalValueChange) AS RevaluedPortionTotalValueChange, SUM(t.AcquisitionAccountChange) AS AcquisitionAccountChange, SUM(t.AcquisitionAccountChangePerUnit) AS AcquisitionAccountChangePerUnit, SUM(t.AmortizationAccountChange) AS AmortizationAccountChange, SUM(t.AmortizationAccountChangePerUnit) AS AmortizationAccountChangePerUnit, SUM(t.ValueDecreaseAccountChange) AS ValueDecreaseAccountChange, SUM(t.ValueDecreaseAccountChangePerUnit) AS ValueDecreaseAccountChangePerUnit, SUM(t.ValueIncreaseAccountChange) AS ValueIncreaseAccountChange, SUM(t.ValueIncreaseAccountChangePerUnit) AS ValueIncreaseAccountChangePerUnit, SUM(t.ValueIncreaseAmmortizationAccountChange) AS ValueIncreaseAmmortizationAccountChange, SUM(t.ValueIncreaseAmmortizationAccountChangePerUnit) AS ValueIncreaseAmmortizationAccountChangePerUnit, SUM(t.AmortizationCalculatedForMonths) AS AmortizationCalculatedForMonths, SUM(CASE WHEN t.OperationType='nau' THEN 1 ELSE 0 END) AS UsageStatus FROM turtas_op t WHERE t.ID<>$OD AND t.T_ID=$TD AND t.OperationDate<=$DT GROUP BY t.T_ID) AS l ON l.T_ID=t.ID WHERE t.ID=$TD ;=t.ID AND d.OperationType='aac' AND d.AccountOperationType='aqs' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.Saskaita) AS AccountAcquisition, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='amr' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountAmortization) AS AccountAmmortization, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vld' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueDecrease) AS AccountValueDecrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vli' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueIncrease) AS AccountValueIncrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vam' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountRevaluedPortionAmmortization) AS AccountRevaluedPortionAmmortization, b.Op_data, t.Isigijimo_dok, t.Likutine, t.ContinuedUsage, t.Kiekis, t.Vnt_kaina, t.TotalValue, t.AcquisitionRevaluedPortionUnitValue, t.AcquisitionRevaluedPortionTotalValue, t.AccumulatedAmortizationPerUnit, t.S_Amort, t.AccumulatedAmortizationRevaluedPortionPerUnit, t.AccumulatedAmortizationRevaluedPortionTotal, IFNULL((SELECT d.NewAmortizationPeriod FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='alk' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.DefaultAmortPeriod) AS AmmortizationPeriodChanged, t.WasUsedMonths, l.AmmountChange, l.UnitValueChange, l.TotalValueChange, l.RevaluedPortionUnitValueChange, l.RevaluedPortionTotalValueChange, l.AcquisitionAccountChange, l.AcquisitionAccountChangePerUnit, l.AmortizationAccountChange, l.AmortizationAccountChangePerUnit, l.ValueDecreaseAccountChange, l.ValueDecreaseAccountChangePerUnit, l.ValueIncreaseAccountChange, l.ValueIncreaseAccountChangePerUnit, l.ValueIncreaseAmmortizationAccountChange, l.ValueIncreaseAmmortizationAccountChangePerUnit, l.AmortizationCalculatedForMonths, l.UsageStatus FROM turtas t LEFT JOIN bz b ON b.Op_ID=t.Isigijimo_dok LEFT JOIN (SELECT t.T_ID, -SUM(t.AmmountChange) AS AmmountChange, SUM(t.UnitValueChange) AS UnitValueChange, SUM(t.TotalValueChange) AS TotalValueChange, SUM(t.RevaluedPortionUnitValueChange) AS RevaluedPortionUnitValueChange, SUM(t.RevaluedPortionTotalValueChange) AS RevaluedPortionTotalValueChange, SUM(t.AcquisitionAccountChange) AS AcquisitionAccountChange, SUM(t.AcquisitionAccountChangePerUnit) AS AcquisitionAccountChangePerUnit, SUM(t.AmortizationAccountChange) AS AmortizationAccountChange, SUM(t.AmortizationAccountChangePerUnit) AS AmortizationAccountChangePerUnit, SUM(t.ValueDecreaseAccountChange) AS ValueDecreaseAccountChange, SUM(t.ValueDecreaseAccountChangePerUnit) AS ValueDecreaseAccountChangePerUnit, SUM(t.ValueIncreaseAccountChange) AS ValueIncreaseAccountChange, SUM(t.ValueIncreaseAccountChangePerUnit) AS ValueIncreaseAccountChangePerUnit, SUM(t.ValueIncreaseAmmortizationAccountChange) AS ValueIncreaseAmmortizationAccountChange, SUM(t.ValueIncreaseAmmortizationAccountChangePerUnit) AS ValueIncreaseAmmortizationAccountChangePerUnit, SUM(t.AmortizationCalculatedForMonths) AS AmortizationCalculatedForMonths, SUM(CASE WHEN t.OperationType='nau' THEN 1 ELSE 0 END) AS UsageStatus FROM turtas_op t WHERE t.ID<>$OD AND t.T_ID=$TD AND t.OperationDate<=$DT GROUP BY t.T_ID) AS l ON l.T_ID=t.ID WHERE t.ID=$TD ;], Params: ?TD=1; ?OD=-1; ?DT=2115-01-03;
Klaidos turinys: 'SQLite error
no such column: l.T_ID'.
Klaidos duomenys:
Klaidos tekstas:
Exception has been thrown by the target of an invocation.
Klaidos šaltinis(Ex.Source):
mscorlib
Klaidos metodas (Ex.TargetSite):
_InvokeMethodFast
Klaidos stekas:
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at ApskaitaWUI.BOMapper.LoadObject[T](T ObjectInstance, String MethodName, Boolean AllowCancel, Object[] Params)
at ApskaitaWUI.F_LongTermAssetOperation.F_LongTermAssetOperation_Load(Object sender, EventArgs e)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal.Create failed (System.Exception: Klaida vykdant SELECT sakinį (statement): [SELECT t.Turtas, t.Vnt, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='aqs' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.Saskaita) AS AccountAcquisition, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='amr' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountAmortization) AS AccountAmmortization, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vld' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueDecrease) AS AccountValueDecrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vli' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueIncrease) AS AccountValueIncrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vam' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountRevaluedPortionAmmortization) AS AccountRevaluedPortionAmmortization, b.Op_data, t.Isigijimo_dok, t.Likutine, t.ContinuedUsage, t.Kiekis, t.Vnt_kaina, t.TotalValue, t.AcquisitionRevaluedPortionUnitValue, t.AcquisitionRevaluedPortionTotalValue, t.AccumulatedAmortizationPerUnit, t.S_Amort, t.AccumulatedAmortizationRevaluedPortionPerUnit, t.AccumulatedAmortizationRevaluedPortionTotal, IFNULL((SELECT d.NewAmortizationPeriod FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='alk' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.DefaultAmortPeriod) AS AmmortizationPeriodChanged, t.WasUsedMonths, l.AmmountChange, l.UnitValueChange, l.TotalValueChange, l.RevaluedPortionUnitValueChange, l.RevaluedPortionTotalValueChange, l.AcquisitionAccountChange, l.AcquisitionAccountChangePerUnit, l.AmortizationAccountChange, l.AmortizationAccountChangePerUnit, l.ValueDecreaseAccountChange, l.ValueDecreaseAccountChangePerUnit, l.ValueIncreaseAccountChange, l.ValueIncreaseAccountChangePerUnit, l.ValueIncreaseAmmortizationAccountChange, l.ValueIncreaseAmmortizationAccountChangePerUnit, l.AmortizationCalculatedForMonths, l.UsageStatus FROM turtas t LEFT JOIN bz b ON b.Op_ID=t.Isigijimo_dok LEFT JOIN (SELECT t.T_ID, -SUM(t.AmmountChange) AS AmmountChange, SUM(t.UnitValueChange) AS UnitValueChange, SUM(t.TotalValueChange) AS TotalValueChange, SUM(t.RevaluedPortionUnitValueChange) AS RevaluedPortionUnitValueChange, SUM(t.RevaluedPortionTotalValueChange) AS RevaluedPortionTotalValueChange, SUM(t.AcquisitionAccountChange) AS AcquisitionAccountChange, SUM(t.AcquisitionAccountChangePerUnit) AS AcquisitionAccountChangePerUnit, SUM(t.AmortizationAccountChange) AS AmortizationAccountChange, SUM(t.AmortizationAccountChangePerUnit) AS AmortizationAccountChangePerUnit, SUM(t.ValueDecreaseAccountChange) AS ValueDecreaseAccountChange, SUM(t.ValueDecreaseAccountChangePerUnit) AS ValueDecreaseAccountChangePerUnit, SUM(t.ValueIncreaseAccountChange) AS ValueIncreaseAccountChange, SUM(t.ValueIncreaseAccountChangePerUnit) AS ValueIncreaseAccountChangePerUnit, SUM(t.ValueIncreaseAmmortizationAccountChange) AS ValueIncreaseAmmortizationAccountChange, SUM(t.ValueIncreaseAmmortizationAccountChangePerUnit) AS ValueIncreaseAmmortizationAccountChangePerUnit, SUM(t.AmortizationCalculatedForMonths) AS AmortizationCalculatedForMonths, SUM(CASE WHEN t.OperationType='nau' THEN 1 ELSE 0 END) AS UsageStatus FROM turtas_op t WHERE t.ID<>$OD AND t.T_ID=$TD AND t.OperationDate<=$DT GROUP BY t.T_ID) AS l ON l.T_ID=t.ID WHERE t.ID=$TD ;=t.ID AND d.OperationType='aac' AND d.AccountOperationType='aqs' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.Saskaita) AS AccountAcquisition, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='amr' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountAmortization) AS AccountAmmortization, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vld' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueDecrease) AS AccountValueDecrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vli' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueIncrease) AS AccountValueIncrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vam' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountRevaluedPortionAmmortization) AS AccountRevaluedPortionAmmortization, b.Op_data, t.Isigijimo_dok, t.Likutine, t.ContinuedUsage, t.Kiekis, t.Vnt_kaina, t.TotalValue, t.AcquisitionRevaluedPortionUnitValue, t.AcquisitionRevaluedPortionTotalValue, t.AccumulatedAmortizationPerUnit, t.S_Amort, t.AccumulatedAmortizationRevaluedPortionPerUnit, t.AccumulatedAmortizationRevaluedPortionTotal, IFNULL((SELECT d.NewAmortizationPeriod FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='alk' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.DefaultAmortPeriod) AS AmmortizationPeriodChanged, t.WasUsedMonths, l.AmmountChange, l.UnitValueChange, l.TotalValueChange, l.RevaluedPortionUnitValueChange, l.RevaluedPortionTotalValueChange, l.AcquisitionAccountChange, l.AcquisitionAccountChangePerUnit, l.AmortizationAccountChange, l.AmortizationAccountChangePerUnit, l.ValueDecreaseAccountChange, l.ValueDecreaseAccountChangePerUnit, l.ValueIncreaseAccountChange, l.ValueIncreaseAccountChangePerUnit, l.ValueIncreaseAmmortizationAccountChange, l.ValueIncreaseAmmortizationAccountChangePerUnit, l.AmortizationCalculatedForMonths, l.UsageStatus FROM turtas t LEFT JOIN bz b ON b.Op_ID=t.Isigijimo_dok LEFT JOIN (SELECT t.T_ID, -SUM(t.AmmountChange) AS AmmountChange, SUM(t.UnitValueChange) AS UnitValueChange, SUM(t.TotalValueChange) AS TotalValueChange, SUM(t.RevaluedPortionUnitValueChange) AS RevaluedPortionUnitValueChange, SUM(t.RevaluedPortionTotalValueChange) AS RevaluedPortionTotalValueChange, SUM(t.AcquisitionAccountChange) AS AcquisitionAccountChange, SUM(t.AcquisitionAccountChangePerUnit) AS AcquisitionAccountChangePerUnit, SUM(t.AmortizationAccountChange) AS AmortizationAccountChange, SUM(t.AmortizationAccountChangePerUnit) AS AmortizationAccountChangePerUnit, SUM(t.ValueDecreaseAccountChange) AS ValueDecreaseAccountChange, SUM(t.ValueDecreaseAccountChangePerUnit) AS ValueDecreaseAccountChangePerUnit, SUM(t.ValueIncreaseAccountChange) AS ValueIncreaseAccountChange, SUM(t.ValueIncreaseAccountChangePerUnit) AS ValueIncreaseAccountChangePerUnit, SUM(t.ValueIncreaseAmmortizationAccountChange) AS ValueIncreaseAmmortizationAccountChange, SUM(t.ValueIncreaseAmmortizationAccountChangePerUnit) AS ValueIncreaseAmmortizationAccountChangePerUnit, SUM(t.AmortizationCalculatedForMonths) AS AmortizationCalculatedForMonths, SUM(CASE WHEN t.OperationType='nau' THEN 1 ELSE 0 END) AS UsageStatus FROM turtas_op t WHERE t.ID<>$OD AND t.T_ID=$TD AND t.OperationDate<=$DT GROUP BY t.T_ID) AS l ON l.T_ID=t.ID WHERE t.ID=$TD ;], Params: ?TD=1; ?OD=-1; ?DT=2115-01-03;
Klaidos turinys: 'SQLite error
no such column: l.T_ID'. ---> System.Data.SQLite.SQLiteException: SQLite error
no such column: l.T_ID
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.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 AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
--- End of inner exception stack trace ---
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.Assets.LongTermAssetOperation.GetOperationBackgroundInfo(Int32 nAssetId, Int32 nOperationID, DateTime nOperationDate)
at ApskaitaObjects.Assets.LongTermAssetOperation.Create(Int32 AssetId, LtaOperationType nNewOperationType, IChronologicValidator parentValidator)
at ApskaitaObjects.Assets.LongTermAssetOperation.DataPortal_Create(Criteria criteria))
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Create
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.Assets.LongTermAssetOperation.GetOperationBackgroundInfo(Int32 nAssetId, Int32 nOperationID, DateTime nOperationDate)
at ApskaitaObjects.Assets.LongTermAssetOperation.Create(Int32 AssetId, LtaOperationType nNewOperationType, IChronologicValidator parentValidator)
at ApskaitaObjects.Assets.LongTermAssetOperation.DataPortal_Create(Criteria criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.Server.SimpleDataPortal.Create(Type objectType, Object criteria, DataPortalContext context)
at Csla.DataPortal.Create(Type objectType, Object criteria)
at Csla.DataPortal.Create[T](Object criteria)
at ApskaitaObjects.Assets.LongTermAssetOperation.NewLongTermAssetOperation(Int32 AssetId)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal_Create method call failed
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
CallMethod
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.Assets.LongTermAssetOperation.GetOperationBackgroundInfo(Int32 nAssetId, Int32 nOperationID, DateTime nOperationDate)
at ApskaitaObjects.Assets.LongTermAssetOperation.Create(Int32 AssetId, LtaOperationType nNewOperationType, IChronologicValidator parentValidator)
at ApskaitaObjects.Assets.LongTermAssetOperation.DataPortal_Create(Criteria criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.Server.SimpleDataPortal.Create(Type objectType, Object criteria, DataPortalContext context)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Klaida vykdant SELECT sakinį (statement): [SELECT t.Turtas, t.Vnt, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='aqs' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.Saskaita) AS AccountAcquisition, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='amr' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountAmortization) AS AccountAmmortization, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vld' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueDecrease) AS AccountValueDecrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vli' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueIncrease) AS AccountValueIncrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vam' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountRevaluedPortionAmmortization) AS AccountRevaluedPortionAmmortization, b.Op_data, t.Isigijimo_dok, t.Likutine, t.ContinuedUsage, t.Kiekis, t.Vnt_kaina, t.TotalValue, t.AcquisitionRevaluedPortionUnitValue, t.AcquisitionRevaluedPortionTotalValue, t.AccumulatedAmortizationPerUnit, t.S_Amort, t.AccumulatedAmortizationRevaluedPortionPerUnit, t.AccumulatedAmortizationRevaluedPortionTotal, IFNULL((SELECT d.NewAmortizationPeriod FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='alk' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.DefaultAmortPeriod) AS AmmortizationPeriodChanged, t.WasUsedMonths, l.AmmountChange, l.UnitValueChange, l.TotalValueChange, l.RevaluedPortionUnitValueChange, l.RevaluedPortionTotalValueChange, l.AcquisitionAccountChange, l.AcquisitionAccountChangePerUnit, l.AmortizationAccountChange, l.AmortizationAccountChangePerUnit, l.ValueDecreaseAccountChange, l.ValueDecreaseAccountChangePerUnit, l.ValueIncreaseAccountChange, l.ValueIncreaseAccountChangePerUnit, l.ValueIncreaseAmmortizationAccountChange, l.ValueIncreaseAmmortizationAccountChangePerUnit, l.AmortizationCalculatedForMonths, l.UsageStatus FROM turtas t LEFT JOIN bz b ON b.Op_ID=t.Isigijimo_dok LEFT JOIN (SELECT t.T_ID, -SUM(t.AmmountChange) AS AmmountChange, SUM(t.UnitValueChange) AS UnitValueChange, SUM(t.TotalValueChange) AS TotalValueChange, SUM(t.RevaluedPortionUnitValueChange) AS RevaluedPortionUnitValueChange, SUM(t.RevaluedPortionTotalValueChange) AS RevaluedPortionTotalValueChange, SUM(t.AcquisitionAccountChange) AS AcquisitionAccountChange, SUM(t.AcquisitionAccountChangePerUnit) AS AcquisitionAccountChangePerUnit, SUM(t.AmortizationAccountChange) AS AmortizationAccountChange, SUM(t.AmortizationAccountChangePerUnit) AS AmortizationAccountChangePerUnit, SUM(t.ValueDecreaseAccountChange) AS ValueDecreaseAccountChange, SUM(t.ValueDecreaseAccountChangePerUnit) AS ValueDecreaseAccountChangePerUnit, SUM(t.ValueIncreaseAccountChange) AS ValueIncreaseAccountChange, SUM(t.ValueIncreaseAccountChangePerUnit) AS ValueIncreaseAccountChangePerUnit, SUM(t.ValueIncreaseAmmortizationAccountChange) AS ValueIncreaseAmmortizationAccountChange, SUM(t.ValueIncreaseAmmortizationAccountChangePerUnit) AS ValueIncreaseAmmortizationAccountChangePerUnit, SUM(t.AmortizationCalculatedForMonths) AS AmortizationCalculatedForMonths, SUM(CASE WHEN t.OperationType='nau' THEN 1 ELSE 0 END) AS UsageStatus FROM turtas_op t WHERE t.ID<>$OD AND t.T_ID=$TD AND t.OperationDate<=$DT GROUP BY t.T_ID) AS l ON l.T_ID=t.ID WHERE t.ID=$TD ;=t.ID AND d.OperationType='aac' AND d.AccountOperationType='aqs' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.Saskaita) AS AccountAcquisition, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='amr' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountAmortization) AS AccountAmmortization, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vld' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueDecrease) AS AccountValueDecrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vli' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountValueIncrease) AS AccountValueIncrease, IFNULL((SELECT d.AccountCorresponding FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='aac' AND d.AccountOperationType='vam' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.AccountRevaluedPortionAmmortization) AS AccountRevaluedPortionAmmortization, b.Op_data, t.Isigijimo_dok, t.Likutine, t.ContinuedUsage, t.Kiekis, t.Vnt_kaina, t.TotalValue, t.AcquisitionRevaluedPortionUnitValue, t.AcquisitionRevaluedPortionTotalValue, t.AccumulatedAmortizationPerUnit, t.S_Amort, t.AccumulatedAmortizationRevaluedPortionPerUnit, t.AccumulatedAmortizationRevaluedPortionTotal, IFNULL((SELECT d.NewAmortizationPeriod FROM turtas_op d WHERE d.T_ID=t.ID AND d.OperationType='alk' AND d.ID<>$OD AND d.OperationDate<=$DT ORDER BY d.OperationDate DESC LIMIT 1), t.DefaultAmortPeriod) AS AmmortizationPeriodChanged, t.WasUsedMonths, l.AmmountChange, l.UnitValueChange, l.TotalValueChange, l.RevaluedPortionUnitValueChange, l.RevaluedPortionTotalValueChange, l.AcquisitionAccountChange, l.AcquisitionAccountChangePerUnit, l.AmortizationAccountChange, l.AmortizationAccountChangePerUnit, l.ValueDecreaseAccountChange, l.ValueDecreaseAccountChangePerUnit, l.ValueIncreaseAccountChange, l.ValueIncreaseAccountChangePerUnit, l.ValueIncreaseAmmortizationAccountChange, l.ValueIncreaseAmmortizationAccountChangePerUnit, l.AmortizationCalculatedForMonths, l.UsageStatus FROM turtas t LEFT JOIN bz b ON b.Op_ID=t.Isigijimo_dok LEFT JOIN (SELECT t.T_ID, -SUM(t.AmmountChange) AS AmmountChange, SUM(t.UnitValueChange) AS UnitValueChange, SUM(t.TotalValueChange) AS TotalValueChange, SUM(t.RevaluedPortionUnitValueChange) AS RevaluedPortionUnitValueChange, SUM(t.RevaluedPortionTotalValueChange) AS RevaluedPortionTotalValueChange, SUM(t.AcquisitionAccountChange) AS AcquisitionAccountChange, SUM(t.AcquisitionAccountChangePerUnit) AS AcquisitionAccountChangePerUnit, SUM(t.AmortizationAccountChange) AS AmortizationAccountChange, SUM(t.AmortizationAccountChangePerUnit) AS AmortizationAccountChangePerUnit, SUM(t.ValueDecreaseAccountChange) AS ValueDecreaseAccountChange, SUM(t.ValueDecreaseAccountChangePerUnit) AS ValueDecreaseAccountChangePerUnit, SUM(t.ValueIncreaseAccountChange) AS ValueIncreaseAccountChange, SUM(t.ValueIncreaseAccountChangePerUnit) AS ValueIncreaseAccountChangePerUnit, SUM(t.ValueIncreaseAmmortizationAccountChange) AS ValueIncreaseAmmortizationAccountChange, SUM(t.ValueIncreaseAmmortizationAccountChangePerUnit) AS ValueIncreaseAmmortizationAccountChangePerUnit, SUM(t.AmortizationCalculatedForMonths) AS AmortizationCalculatedForMonths, SUM(CASE WHEN t.OperationType='nau' THEN 1 ELSE 0 END) AS UsageStatus FROM turtas_op t WHERE t.ID<>$OD AND t.T_ID=$TD AND t.OperationDate<=$DT GROUP BY t.T_ID) AS l ON l.T_ID=t.ID WHERE t.ID=$TD ;], Params: ?TD=1; ?OD=-1; ?DT=2115-01-03;
Klaidos turinys: 'SQLite error
no such column: l.T_ID'.
Klaidos šaltinis(Ex.Source):
AccDataAccessLayer
Klaidos metodas (Ex.TargetSite):
FetchCommand
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.Assets.LongTermAssetOperation.GetOperationBackgroundInfo(Int32 nAssetId, Int32 nOperationID, DateTime nOperationDate)
at ApskaitaObjects.Assets.LongTermAssetOperation.Create(Int32 AssetId, LtaOperationType nNewOperationType, IChronologicValidator parentValidator)
at ApskaitaObjects.Assets.LongTermAssetOperation.DataPortal_Create(Criteria criteria)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
SQLite error
no such column: l.T_ID
Klaidos šaltinis(Ex.Source):
System.Data.SQLite
Klaidos metodas (Ex.TargetSite):
Prepare
Klaidos stekas:
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.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 AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)

na o Kompleksiniai operacijų su ilgalaikiu turtu dokumentai iš viso neiššaukia ilgalaikio turto sąrašo.

Sveiki,
ar atsirastų Kaune žmogus galintis paleisti naują versiją programos? Žinoma ne už ačiū :)
Kaip suprantu jei naudojau prekių apskaitą, tai duombazės padaręs atsarginę kopiją, į naują programą neperkelsiu. Ar tuomet reikia daryti naują sask planą (naudoju ne tipinį) ir susivedineti likučius jau eurais, ar kaip? O gal sąsk planą galima iš senos versijos paiimti?
Vaje, vaje dar su euru viskas ok, bet kad sena versija nebepalaikoma, ir reikia į naują keltis, tai jau baisu.

vakar neleido rasyti nauju saskaitu, senoje versijoje padariau praeitu metu likut, pasidariau noja kopija, bet naujoje versijoje neleidzia ikelti naujos, meta kliada:
Klaida transakcijoje vykdant SQL sakinį [INSERT INTO invoicesreceived(ID, CurrencyCode, CurrencyRate, CommentsInternal, AccountSupplier, InsertDate, UpdateDate, InvoiceType, ExternalID, IndirectVatSum, IndirectVatAccount, IndirectVatCostsAccount, ActualDate) SELECT b.Op_ID, 'LTL', 1, '', IFNULL(d.Op_saskaita, 0), UTC_TIMESTAMP(), UTC_TIMESTAMP(), 0, '', 0, 0, 0, null FROM bz b LEFT JOIN bzdata d ON d.Op_tipas='Kreditas' AND d.Op_ID_BZ=b.Op_ID LEFT JOIN sfg f ON f.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='sg' GROUP BY b.Op_ID;='Kreditas' AND d.Op_ID_BZ=b.Op_ID LEFT JOIN sfg f ON f.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='sg' GROUP BY b.Op_ID;], Params:
Klaidos turinys: 'Klaida vykdant SQL komandą: [INSERT INTO invoicesreceived(ID, CurrencyCode, CurrencyRate, CommentsInternal, AccountSupplier, InsertDate, UpdateDate, InvoiceType, ExternalID, IndirectVatSum, IndirectVatAccount, IndirectVatCostsAccount, ActualDate) SELECT b.Op_ID, 'LTL', 1, '', IFNULL(d.Op_saskaita, 0), UTC_TIMESTAMP(), UTC_TIMESTAMP(), 0, '', 0, 0, 0, null FROM bz b LEFT JOIN bzdata d ON d.Op_tipas='Kreditas' AND d.Op_ID_BZ=b.Op_ID LEFT JOIN sfg f ON f.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='sg' GROUP BY b.Op_ID;='Kreditas' AND d.Op_ID_BZ=b.Op_ID LEFT JOIN sfg f ON f.BZ_ID=b.Op_ID WHERE b.Op_dok_rusis='sg' GROUP BY b.Op_ID;], Params:
Klaidos turinys: 'Duplicate entry '51' for key 'PRIMARY''.'.

nezianu ka padariau, bet ar galima naujai perinstaliuoti programa, kad neliktu jau sukurtu vartotoju? viska istryniau, peristaliavau, bet vis vien atsikuria jau neveikiantys vartotojai... Ka daryti?
Niemand kiek kainuos jusu asmenine konsultacija ar pagalba? parasykit prasau zydruna@rambler.ru