Clarion Community

Search Sort Posts:  Oldest to newest Newest to oldest

04-30-2008, 5:02 AM dEraCh2000 Joined on 04-30-2008 Sarajevo, B&H Posts 11 Postgre-ODBC & browse box Hello, I'm using an ODBC connection to database server. Reason for ODBC is that I'm using Postgre database. When I use the file loading method in the browse box, it takes some time until it loades the data. Then i change to page load method. It works very fast, but there is a new problem. When i scrol down it does not load new data it just repeats the last one that was displayed when the data was loaded the first time. If anyone has encountered such a problem, or has an advice in how to fix this, I would be very grateful. Regards      Report

05-08-2008, 1:20 AM dEraCh2000 Joined on 04-30-2008 Sarajevo, B&H Posts 11 Re: Postgre-ODBC & browse box 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 iinvoice. 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    Report

05-08-2008, 7:52 AM Shankar Joined on 10-24-2005 Dubai, UAE Posts 219 Re: Postgre-ODBC & browse box Hi! MS-SQL is very good Query-optimizing server and what normally works on MS-SQL may not work properly on other DB Servers unless the Indexes are set up correctly and queries are coded in a way that allows these indexes to be used. MS-SQL might have other faults but Query-optyimization is not one of them. Fact is, most users create only the Primary & Foreign key constraints and leave the indexes to the server. Regards Shankar    Report

05-13-2008, 2:06 AM dEraCh2000 Joined on 04-30-2008 Sarajevo, B&H Posts 11 Re: Postgre-ODBC & browse box 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     Report

Clarion Communi... » Clarion » Databases and D... » Re: Postgre-ODBC & browse box

(please select) Forums Home |- Search Forums |- Active Topics |- Unanswered Posts User Options |- Sign In |- Join this community |- Forgot Password Clarion |- Clarion Language and Runtime Library |- Databases and Drivers |- Clarion 6 - General Clarion.Net |- General