API tools faq
paste
eliteapp

WOTRPPPP

eliteapp
Feb 1st, 2013
50
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 14.57 KB | None | 0 0
raw download clone embed print report
  1. //Verze 2.2013.170.0
  2. //STANICE
  3. //Windows 7 x86 Service Pack 1 v6.1.7601
  4. //1.2.2013 13:52:43
  5.  
  6. DevExpress.Xpo.DB.Exceptions.SqlExecutionErrorException: Spuštění SQL příkazu 'select  first 1 N0."OID",N0."DatumNarozeni",N0."RodneCisloFmt",N0."Poznamka",N1."Kod",N2."Kod",N0."PojistenOd",N3."KOD",(select max(N4."Hodnota") from "PacientPolozka" N4 where ((N0."OID" = N4."Pacient") and N4."GCRecord" is null and (N4."Pacient" = N0."OID") and N4."Pracoviste" in (1,2) and (N4."Polozka" = 48) and (N4."Datum" = (select max(N5."Datum") from "PacientPolozka" N5 where ((N0."OID" = N5."Pacient") and N5."GCRecord" is null and (N5."Pacient" = N0."OID") and N5."Pracoviste" in (1,2) and (N5."Polozka" = 48)))))),(select max(N6."Hodnota") from "PacientPolozka" N6 where ((N0."OID" = N6."Pacient") and N6."GCRecord" is null and (N6."Pacient" = N0."OID") and N6."Pracoviste" in (1,2) and (N6."Polozka" = 49) and (N6."Datum" = (select max(N7."Datum") from "PacientPolozka" N7 where ((N0."OID" = N7."Pacient") and N7."GCRecord" is null and (N7."Pacient" = N0."OID") and N7."Pracoviste" in (1,2) and (N7."Polozka" = 49)))))),(select max(N8."Hodnota") from "PacientPolozka" N8 where ((N0."OID" = N8."Pacient") and N8."GCRecord" is null and (N8."Pacient" = N0."OID") and N8."Pracoviste" in (1,2) and (N8."Polozka" = 50) and (N8."Datum" = (select max(N9."Datum") from "PacientPolozka" N9 where ((N0."OID" = N9."Pacient") and N9."GCRecord" is null and (N9."Pacient" = N0."OID") and N9."Pracoviste" in (1,2) and (N9."Polozka" = 50)))))),CASE WHEN CASE WHEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END IS NULL AND N0."Prijmeni" IS NULL THEN NULL WHEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END IS NULL AND N0."Prijmeni" IS NOT NULL THEN N0."Prijmeni" WHEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END IS NOT NULL AND N0."Prijmeni" IS NULL THEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END ELSE CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END||' '||N0."Prijmeni" END IS NULL AND N0."TitulZa" IS NULL THEN NULL WHEN CASE WHEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END IS NULL AND N0."Prijmeni" IS NULL THEN NULL WHEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END IS NULL AND N0."Prijmeni" IS NOT NULL THEN N0."Prijmeni" WHEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END IS NOT NULL AND N0."Prijmeni" IS NULL THEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END ELSE CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END||' '||N0."Prijmeni" END IS NULL AND N0."TitulZa" IS NOT NULL THEN N0."TitulZa" WHEN CASE WHEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END IS NULL AND N0."Prijmeni" IS NULL THEN NULL WHEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END IS NULL AND N0."Prijmeni" IS NOT NULL THEN N0."Prijmeni" WHEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END IS NOT NULL AND N0."Prijmeni" IS NULL THEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END ELSE CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END||' '||N0."Prijmeni" END IS NOT NULL AND N0."TitulZa" IS NULL THEN CASE WHEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END IS NULL AND N0."Prijmeni" IS NULL THEN NULL WHEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END IS NULL AND N0."Prijmeni" IS NOT NULL THEN N0."Prijmeni" WHEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END IS NOT NULL AND N0."Prijmeni" IS NULL THEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END ELSE CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END||' '||N0."Prijmeni" END ELSE CASE WHEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END IS NULL AND N0."Prijmeni" IS NULL THEN NULL WHEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END IS NULL AND N0."Prijmeni" IS NOT NULL THEN N0."Prijmeni" WHEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END IS NOT NULL AND N0."Prijmeni" IS NULL THEN CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END ELSE CASE WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NULL THEN NULL WHEN N0."TitulPred" IS NULL AND N0."Jmeno" IS NOT NULL THEN N0."Jmeno" WHEN N0."TitulPred" IS NOT NULL AND N0."Jmeno" IS NULL THEN N0."TitulPred" ELSE N0."TitulPred"||' '||N0."Jmeno" END||' '||N0."Prijmeni" END||', '||N0."TitulZa" END from ((("Pacient" N0
  7. left join "Pojistovna" N1 on (N0."Pojistovna" = N1."OID"))
  8. left join "DruhPojisteni" N2 on (N0."DruhPojisteni" = N2."OID"))
  9. left join "vzpDiagnozy" N3 on (N0."Diagnoza" = N3."OID"))
  10. where (N0."GCRecord" is null and (N0."OID" = -1))' s parametry '' vyvolalo výjimku 'FirebirdSql.Data.FirebirdClient.FbException: Error reading data from the connection. ---> Error reading data from the connection.
  11.   --- Konec trasování zásobníku pro vnitřní výjimku ---
  12.   v FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction()
  13.   v FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
  14.   v FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
  15.   v FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
  16.   v FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior behavior)
  17.   v System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
  18.   v DevExpress.Xpo.DB.ConnectionProviderSql.<>c__DisplayClass6.<InternalGetData>b__4()
  19.   v DevExpress.Xpo.Logger.LogManager.Log[T](String category, LogHandler`1 handler, MessageHandler`1 createMessageHandler)
  20.   v DevExpress.Xpo.DB.ConnectionProviderSql.InternalGetData(IDbCommand command, CriteriaOperatorCollection targets, Int32 skipClause, Int32 topClause, Boolean includeMetadata)
  21.   v DevExpress.Xpo.DB.ConnectionProviderSql.SelectDataSimple(Query query, CriteriaOperatorCollection targets, Boolean includeMetadata)' ---> FirebirdSql.Data.FirebirdClient.FbException: Error reading data from the connection. ---> Error reading data from the connection.
  22.    --- Konec trasování zásobníku pro vnitřní výjimku ---
  23.    v FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction()
  24.    v FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
  25.    v FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
  26.    v FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
  27.    v FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior behavior)
  28.    v System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
  29.    v DevExpress.Xpo.DB.ConnectionProviderSql.<>c__DisplayClass6.<InternalGetData>b__4()
  30.    v DevExpress.Xpo.Logger.LogManager.Log[T](String category, LogHandler`1 handler, MessageHandler`1 createMessageHandler)
  31.    v DevExpress.Xpo.DB.ConnectionProviderSql.InternalGetData(IDbCommand command, CriteriaOperatorCollection targets, Int32 skipClause, Int32 topClause, Boolean includeMetadata)
  32.    v DevExpress.Xpo.DB.ConnectionProviderSql.SelectDataSimple(Query query, CriteriaOperatorCollection targets, Boolean includeMetadata)
  33.    --- Konec trasování zásobníku pro vnitřní výjimku ---
  34.    v DevExpress.Xpo.DB.ConnectionProviderSql.SelectDataSimple(Query query, CriteriaOperatorCollection targets, Boolean includeMetadata)
  35.    v DevExpress.Xpo.DB.ConnectionProviderSql.SelectData(Query query, CriteriaOperatorCollection targets)
  36.    v DevExpress.Xpo.DB.ConnectionProviderSql.ProcessSelectData(SelectStatement selects)
  37.    v DevExpress.Xpo.DB.DataStoreBase.ProcessSelectData(SelectStatement[] selects)
  38.    v DevExpress.Xpo.DB.DataStoreSerializedBase.SelectData(SelectStatement[] selects)
  39.    v DevExpress.Xpo.DB.ConnectionProviderSql.SelectData(SelectStatement[] selects)
  40.    v DevExpress.Xpo.SimpleDataLayer.SelectData(SelectStatement[] selects)
  41.    v DevExpress.Xpo.SimpleObjectLayer.SelectData(Session session, ObjectsQuery query, CriteriaOperatorCollection properties, CriteriaOperatorCollection groupProperties, CriteriaOperator groupCriteria)
  42.    v DevExpress.Xpo.Session.SelectDataInternal(XPClassInfo classInfo, CriteriaOperatorCollection properties, CriteriaOperator criteria, CriteriaOperatorCollection groupProperties, CriteriaOperator groupCriteria, Boolean selectDeleted, Int32 skipSelectedRecords, Int32 topSelectedRecords, SortingCollection sorting)
  43.    v DevExpress.Xpo.Session.<>c__DisplayClass2.<SelectData>b__0()
  44.    v DevExpress.Xpo.Logger.LogManager.Log[T](String category, LogHandler`1 handler, MessageHandler`1 createMessageHandler)
  45.    v DevExpress.Xpo.Session.SelectData(XPClassInfo classInfo, CriteriaOperatorCollection properties, CriteriaOperator criteria, CriteriaOperatorCollection groupProperties, CriteriaOperator groupCriteria, Boolean selectDeleted, Int32 skipSelectedRecords, Int32 topSelectedRecords, SortingCollection sorting)
  46.    v DevExpress.Xpo.XPView.EndLoad(CriteriaOperatorCollection properties, CriteriaOperatorCollection groupProperties, SortingCollection sorting)
  47.    v DevExpress.Xpo.XPView.Load()
  48.    v DevExpress.Xpo.XPView.get_Objects()
  49.    v DevExpress.Xpo.XPView.get_Count()
  50.    v System.Windows.Forms.CurrencyManager.UpdateIsBinding(Boolean raiseItemChangedEvent)
  51.    v System.Windows.Forms.CurrencyManager.UpdateIsBinding()
  52.    v System.Windows.Forms.CurrencyManager.List_ListChanged(Object sender, ListChangedEventArgs e)
  53.    v System.ComponentModel.ListChangedEventHandler.Invoke(Object sender, ListChangedEventArgs e)
  54.    v DevExpress.Xpo.XPView.Reset(Boolean metadataChanged)
  55.    v DevExpress.Xpo.XPView.Reload()
  56.    v DevExpress.Xpo.XPView.set_Criteria(CriteriaOperator value)
  57.    v Elite.Gui.Controls.PacientInfoControl.SetObject(Object Object)
  58.    v Elite.Gui.Controls.PacientInfoControl.EliteApplication_OnPacientContextChanged(Object sender, EventArgs e)
  59.    v Elite.Gui.EliteApplication.setPacientContext(Nullable`1 pacient)
  60.    v Elite.Gui.EliteApplication.SetPacientContext(Pacient pacient)
  61.    v Elite.Gui.Controls.PacientBrowseControl.PacientBrowseControl_Enter(Object sender, EventArgs e)
  62.    v System.Windows.Forms.Control.OnEnter(EventArgs e)
  63.    v System.Windows.Forms.Control.NotifyEnter()
  64.    v System.Windows.Forms.ContainerControl.UpdateFocusedControl()
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!