ODBC & browse box

[dEraCh2000]

Hi,

I hapy to say that we have resoved the problem. The thing was, that before this invoice items list we had a window with two browse boxes. One was the list of invoices, and other one was the list of items, that populates as you click the certain invoice. Problem was in the second list, the item list. Items table has relations with two other tables. In the first window we did not need data from them so they were not included in the table list of the browse. And when we opened the second window, with the problematic browse, that made a huge problem, since there were no relations activ, table was opened prior without relations. When we included them in the first window, it all worked fine.

This problem only happened with PostgreSql. It works fine when connected to MSSQL via ODBC.

Regards

 

[dEraCh2000]

Just i little update on the subject

We have also solved the problem by using aliases. We changed all of the relations to aliases becouse we had some problems with entering the invoice item. We were tired of searching for all of those relations in the application. So we tryed with aliases and all the problems were solved.

Thats all