Hello Robert,

De Source is Labosys from Philips Medical Systems.

The query gives still the same error with pnr 27085070017

Another pnr 24084205019 gives this as result:

24084205019||2021-03-15 09:19:00||3422||2021-03-16 14:51:24||4  2021-03-15 09:19:00     2021-03-16 14:51:24

Hello Robert,

Thank you for the support. unfortunately I get the same error.

This is the first time that i run a query at the shell prompt.

These are my actions (the table GLPPatTcActie belongs to namespace LABSQL):

Namespace: LABSQL
You're in namespace LABSQL
Default directory is f:\databases\labsql\
LABSQL>do $system.SQL.Shell()
SQL Command Line Shell
----------------------------------------------------
 
The command prefix is currently set to: <<nothing>>.
Enter q to quit, ? for help.
LABSQL>>select ID,%INTERNAL(VerzamelDatTijd),%ODBCout(VerzamelDatTijd),DateTijdSec from GLPPatTcActie where pnr = '27085070017' and LTestId->Makey='BLA' and glpactieid->makey in ('TAV','TMA')
1.      select ID,%INTERNAL(VerzamelDatTijd),%ODBCout(VerzamelDatTijd),DateTijdSec from GLPPatTcActie where pnr = '27085070017' and LTestId->Makey='BLA' and glpactieid->makey in ('TAV','TMA')
 
ID      Expression_2    Expression_3    DateTijdSec
 
 
[SQLCODE: <-400>:<Fatale fout >]
[%msg: <Unexpected error occurred:  <ILLEGAL VALUE>zVerzamelDatTijdStorageToLogica+1^User.GLPPatTcActie.1>]
0 Rows(s) Affected
statement prepare time: 0.8245s, elapsed execute time: 0.0167s.
---------------------------------------------------------------------------
LABSQL>>  << entering multiline statement mode >>
        1>>

This is the complete error:

<eb1>[C:\Program Files (x86)\George Poulose\QTODBC50\QTODBC50.exe]
[SQLCODE: <-400>:<Fatale fout >]
[Cache Error: <<ILLEGAL VALUE>zVerzamelDatTijdStorageToLogica+1^User.GLPPatTcActie.1>]
[Location: <ServerLoop - Query Fetch>]
[%msg: <Unexpected error occurred:  <ILLEGAL VALUE>zVerzamelDatTijdStorageToLogica+1^User.GLPPatTcActie.1>]
State:S1000,Native:400,Origin:[Cache ODBC][State : S1000][Native Code 400]</eb1>

Hallo Robert,

I made a mistake.

This is the query:

select  top 1 DateTijdSec from 
 GLPPatTcActie 
 where pnr = '27085070017' and LTestId->Makey='BLA' and VerzamelDatTijd < '2021-01-29 14:48' and glpactieid->makey in ('TAV','TMA') order by DateTijdSec desc