Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Wolfgang Riedmann" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: Postgres general Question Date: Tue, 12 Sep 2017 07:34:28 +0200 Lines: 56 Message-ID: References: <6d3a0a33-250f-4f2b-884e-5e13f78b40b9@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 X-Trace: individual.net SWB8PxdyfULGFhKCXldkAQjZZJhTOERaClSL4ki2TpF1LLGJQ= Cancel-Lock: sha1:A/B0t30+fxAfPV4z+dO5TLADtb0= User-Agent: XanaNews/1.18.1.6 Xref: csiph.com comp.lang.clipper.visual-objects:10974 Hi Frank, there is an architectural difference between DBF and any SQL engine. DBF is record-based, whereas SQL is selection based. That means that in DBF you are reading record per record and you can stop at any time. In SQL you need to make a selection first, and the server returns the selected records - all. Therefore you should rethink your applicationif you are moving to any SQL engine. It may possible that there is some software that works with PostgreSQL directly on the record level and hides the SQL interface, but VO2ADO is it not. In SQL engines you can have indexes, but they are used by the engine automatically to speed up your queries. To have your records ordered, in SQL you need the orderby clause. SQL has much more power than DBF, but not everything works better with SQL than with DBF. Therefore I have used the Advantage Database Server in a few projects: I was able to move my DBF applications fast to a server based engine, and could add SQL selects where needed. Of course, the next generation of my software is SQL based because DBFs don't work very well with newer server and client versions, and customers are asking more and more features that are difficult to implement with DBF databases. Wolfgang Frank M wrote: > Hello, > > my first beginning with VO2ADO and PostgreSQL, and beginners Problems > :-) > > I can connect and open PG Tables with VO2ADO, that work. When try to > open or set an Index with AdoServer:SetOrder("Ordername") i get the > Error: "SETINDEX not supported by provider" I try two different > Driver. It is general possible to use AdoServer like DbServer? Is > this not possible with PG? I know that i have later to rewrite the > Syntax to real SQL Select, but i like the way, step for step to do > this later. > > Frank --