View / SQL-Queries in Postgres and PHPR

Punch,
I guess this is the page you looking for:

http://www.xlinesoft.com/phprunner/docs/us...sql_queries.htm
If this doesn't help post your SQL query along with the error message.

Sergey,
i do not really get a error messag. My problem ist changing the query form mysql to postgres.

In mysql the query which works looks like this:
-----

select

´tbtbWirtschaftseinheit.Wirtschaftseinheit´,

´tbtbWirtschaftseinheit.ID_LE´,

´tbtbWirtschaftseinheit.Leistung´

From ´tbtbWirtschaftseinheit´ INNER JOIN ´tbtbLeistung´ ON ´tbtbWirtschaftseinheit.Wirtschaftseinheit´ = ´tbtbLeistung.Wirtschaftseinheit´

-----
With postgres, PHPR is setting a "public." in front of the tablenames, like "public.tablename"
So i tried a few versions of my query like this:
------

select

"tbtbWirtschaftseinheit.Wirtschaftseinheit",

"tbtbWirtschaftseinheit.ID_LE",

"tbtbWirtschaftseinheit.Leistung"

From "public.tbtbWirtschaftseinheit" INNER JOIN "public.tbtbLeistung" ON "tbtbWirtschaftseinheit.Wirtschaftseinheit" = "tbtbLeistung.Wirtschaftseinheit"

-----
PHPR doesn´t occures an error message. It doesn´t shows any fields in the following tabs, most parts of the tabs are empty. I guess, PHPR doesn´t recognizes the fields. My problem is, that i don´t know, where to set the prefix "public." in the query and where not.
Maybe there is instead a way that PHPR shows tables without this prefix (like in mysql)?
Best regards
Punch

instead of "tbtbWirtschaftseinheit.Wirtschaftseinheit", use "tbtbWirtschaftseinheit"."Wirtschaftseinheit"

Sergey,
i was sure, i did try this, but maybe i didn´t.
I will try it again without a "public." today and give you a feedback.
Patrick

Sergey,
i doesn´t work at now.
If i use ab table, PHPR generates the code like:
---

select

"ID_WE",

"Wirtschaftseinheit"

From "public"."tbtbWirtschaftseinheit"

----
an i can generate all forms as usual.
If i try to add a view, PHPR doesn´t show any fields. That means, that tab "choose pages" doens´t show any fields for key columns and tab "choose fields" is empty.
I tried a query like this:
---

select

"tbtbWirtschaftseinheit"."ID_WE",

"tbtbLeistung"."Datum_Leistung"

FROM "public"."tbtbWirtschaftseinheit" INNER JOIN "public"."tbtbLeistung" ON "public"."tbtbWirtschaftseinheit"."Wirtschaftseinheit" = "public"."tbtbLeistung"."Wirtschaftseinheit"

---
and like this:
---

select

"tbtbWirtschaftseinheit"."ID_WE",

"tbtbLeistung"."Datum_Leistung"

FROM "tbtbWirtschaftseinheit" INNER JOIN "tbtbLeistung" ON "tbtbWirtschaftseinheit"."Wirtschaftseinheit" = "tbtbLeistung"."Wirtschaftseinheit"

---
I guess, the problem is the prefix which postgres serves, but postgres doesn´t allow to delete this prefix.

For some reason or other PHPR can read the tables from postgres, so i hope there is a way to add views too.
If it would help, i could send you access-data to the postgres-database by mail so that you can see the problem?
Best regards
Punch