Views in the database

[Paul Frishert]

Since the last database update something has been changed in the views within the database.
Earlier I had a report in which I selected some fields from view_invoices, this worked perfect. Now the select for the specific fields is overruled and all fields are shown. What has been changed?
For example:

select code

from view_invoices

In the SQL viewer it reports the codes (patients) and in a report it reports all fields now.

[William]

Hi Meslogie

That does sound very strange. Although this should not make a difference I wondered if you did the first table as the “inv” table instead and then you join the “view_invoices” onto that. So it would look like the SQL below.

select code

from inv

left join view_invoices on (view_invoices.id=inv.id)

Please remember that any fields you are before the “from” will have to be prefaced with “view_invoices.”

Does this fix the problem?

[Paul Frishert]

Solves it. Thanks a lot.

[Author]

Posts