Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #31205
    roelofwielinga
    Participant

    Hi,
    on my database (locally hosted) the line

    select * from view_patients_full;

    works fine.

    On the IMC (serverside hosted) it gives an error. Is this normal behaviour?

    #32731
    Support
    Keymaster

    Hi Roelof,

    >> On the IMC (serverside hosted) it gives an error. Is this normal behaviour?

    I’m sorry – I don’t understand what this means. What is “IMC (serverside hosted)”? Also, what error message are you seeing? Please give as many details as possible.

    #32732
    roelofwielinga
    Participant

    The SQL source of my report is as follows:

    select
    id,
    per.id as per_id,
    per.code,
    @ADDRESSNAME:per as _name,
    @FORMALNAME:per as _formalname,
    @INFORMALNAME:per as _informalname,
    @ADDRESS:per as _address
    from per

    select * from view_patients_full;

    I think this makes it possible to choose between most of the fields when designing the template.

    This works for me (local database) but at the IMC it doesn’t. It gives an SQL-error. Does this have anything to do with the fact that their database runs on a server?

    Thanks for your time.

    #32733
    Support
    Keymaster

    You have two SELECT statements in your source. There should only ever be one SELECT statement. Simply change the source to :-

    select * from view_patients_full;
    #32734
    roelofwielinga
    Participant

    Thanks, I’ll try that. :D/

Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.