Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #10970 > unrolled thread

Postgres general Question

Started byFrank M <frank_muessner@gmx.de>
First post2017-09-11 07:54 -0700
Last post2017-09-18 04:09 -0700
Articles 14 — 6 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  Postgres general Question Frank M <frank_muessner@gmx.de> - 2017-09-11 07:54 -0700
    Re: Postgres general Question Franz Rachbauer <office@rachbauer.org> - 2017-09-11 18:14 +0200
      Re: Postgres general Question Frank M <frank_muessner@gmx.de> - 2017-09-11 09:27 -0700
        Re: Postgres general Question Franz Rachbauer <office@rachbauer.org> - 2017-09-12 07:13 +0200
    Re: Postgres general Question "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-09-12 07:34 +0200
      Re: Postgres general Question Frank M <frank_muessner@gmx.de> - 2017-09-12 00:06 -0700
    Re: Postgres general Question "Karl-Heinz" <invalid@invalid.invalid> - 2017-09-12 13:53 +0200
    Re: Postgres general Question James Martin <james@northwoodlumber.com> - 2017-09-12 17:11 -0400
      Re: Postgres general Question Frank M <frank_muessner@gmx.de> - 2017-09-12 23:58 -0700
        Re: Postgres general Question "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-09-13 10:01 +0200
        Re: Postgres general Question "Rene J. Pajaron" <rjpajaron@gmail.com> - 2017-09-13 23:36 -0700
        Re: Postgres general Question James Martin <james@northwoodlumber.com> - 2017-09-14 14:08 -0400
          Re: Postgres general Question Frank M <frank_muessner@gmx.de> - 2017-09-16 07:17 -0700
            Re: Postgres general Question Frank M <frank_muessner@gmx.de> - 2017-09-18 04:09 -0700

#10970 — Postgres general Question

FromFrank M <frank_muessner@gmx.de>
Date2017-09-11 07:54 -0700
SubjectPostgres general Question
Message-ID<6d3a0a33-250f-4f2b-884e-5e13f78b40b9@googlegroups.com>
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 

[toc] | [next] | [standalone]


#10971

FromFranz Rachbauer <office@rachbauer.org>
Date2017-09-11 18:14 +0200
Message-ID<op6col$1kcu$1@gioia.aioe.org>
In reply to#10970
Hi Frank,
I don't know VO2ADO, I'm using SQLTable and ODBC: Maybe it's 
Server:OrderBy() like in SQLTable.

Regards Franz

Am 11.09.2017 um 16:54 schrieb Frank M:
> 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
>

[toc] | [prev] | [next] | [standalone]


#10972

FromFrank M <frank_muessner@gmx.de>
Date2017-09-11 09:27 -0700
Message-ID<503984c6-354b-46be-a351-ba52fcbecb6a@googlegroups.com>
In reply to#10971
Hi Franz, 
if is the same Error. Server:Orderby() or Server:Seek()

You have VO SQL and PG ? 

Frank 
 

Am Montag, 11. September 2017 18:14:16 UTC+2 schrieb Franz Rachbauer:
> Hi Frank,
> I don't know VO2ADO, I'm using SQLTable and ODBC: Maybe it's 
> Server:OrderBy() like in SQLTable.
> 
> Regards Franz
> 
> Am 11.09.2017 um 16:54 schrieb Frank M:
> > 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
> >

[toc] | [prev] | [next] | [standalone]


#10973

FromFranz Rachbauer <office@rachbauer.org>
Date2017-09-12 07:13 +0200
Message-ID<op7qdt$7i8$1@gioia.aioe.org>
In reply to#10972
Hi Frank,
no PG, I use VO SQL, MySQL/Oracle/SQLite and ODBC.
Franz

Am 11.09.2017 um 18:27 schrieb Frank M:
> Hi Franz,
> if is the same Error. Server:Orderby() or Server:Seek()
>
> You have VO SQL and PG ?
>
> Frank
>
>
> Am Montag, 11. September 2017 18:14:16 UTC+2 schrieb Franz Rachbauer:
>> Hi Frank,
>> I don't know VO2ADO, I'm using SQLTable and ODBC: Maybe it's
>> Server:OrderBy() like in SQLTable.
>>
>> Regards Franz
>>
>> Am 11.09.2017 um 16:54 schrieb Frank M:
>>> 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
>>>
>

[toc] | [prev] | [next] | [standalone]


#10974

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2017-09-12 07:34 +0200
Message-ID<f1p9v6Fidp2U1@mid.individual.net>
In reply to#10970
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 



-- 

[toc] | [prev] | [next] | [standalone]


#10975

FromFrank M <frank_muessner@gmx.de>
Date2017-09-12 00:06 -0700
Message-ID<ba05bbd2-3770-424b-a522-b17e06183658@googlegroups.com>
In reply to#10974
Hi Wolfgang, 

yes that is true. I have to rethink and rewrite the logic. 
That i want to make step by step. At first i want to take the same code. And there a run into trouble with PG with VO2ADO or VOSQL. Specially with Datatyp Boolean/Logic. I try to find a solution. 

Frank  

Am Dienstag, 12. September 2017 07:34:33 UTC+2 schrieb Wolfgang Riedmann:
> 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 
> 
> 
> 
> --

[toc] | [prev] | [next] | [standalone]


#10977

From"Karl-Heinz" <invalid@invalid.invalid>
Date2017-09-12 13:53 +0200
Message-ID<f1q07nFnbojU1@mid.individual.net>
In reply to#10970
Hi Frank,

>
> It is general possible to use AdoServer like DbServer?
>

from my understanding VO2ADO does only work like the VO DBserver class when
you use the "AdoDbServer" class in conjunction with the  "VO2ADO"  RDD .

regards
Karl-Heinz

[toc] | [prev] | [next] | [standalone]


#10978

FromJames Martin <james@northwoodlumber.com>
Date2017-09-12 17:11 -0400
Message-ID<op9ij0$tet$1@dont-email.me>
In reply to#10970
In my experience the Postgres ADO driver is old and deficient. There are 
drivers by other companies that likely work well.

James

On 2017-09-11 10:54 AM, 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
> 

[toc] | [prev] | [next] | [standalone]


#10979

FromFrank M <frank_muessner@gmx.de>
Date2017-09-12 23:58 -0700
Message-ID<f6385b8a-169c-4703-8f51-678a5648c099@googlegroups.com>
In reply to#10978
James, 

have you a ODBC or ADO Driver recommendation?
I found Devart, but expensive for each user to buy. 

Frank 

Am Dienstag, 12. September 2017 23:12:12 UTC+2 schrieb James Martin:
> In my experience the Postgres ADO driver is old and deficient. There are 
> drivers by other companies that likely work well.
> 
> James
> 
> On 2017-09-11 10:54 AM, 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
> >

[toc] | [prev] | [next] | [standalone]


#10980

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2017-09-13 10:01 +0200
Message-ID<f1s6ubF8ad9U1@mid.individual.net>
In reply to#10979
Hi Frank,

> have you a ODBC or ADO Driver recommendation?
> I found Devart, but expensive for each user to buy. 

I had a similar problem with SQLite. There a working ADO.NET driver was
available, and so I built a COM library with X#.
My VO applications use these to access my SQLite databases, but I must
admit that I need only limited database access.

Wolfgang


-- 

[toc] | [prev] | [next] | [standalone]


#10984

From"Rene J. Pajaron" <rjpajaron@gmail.com>
Date2017-09-13 23:36 -0700
Message-ID<646afcd0-c825-424d-9b93-a5584eb3609e@googlegroups.com>
In reply to#10979
Hi Frank M,

I am using Devart dotConnect for PostgreSQL.  It is royalty free distribution.  Although, to get updated (developers), it has yearly subscription which is affordable in our end.

But today while checking devart website, I saw this: https://www.devart.com/news/2017/odbc-xbase-beta.html

Rene

On Wednesday, September 13, 2017 at 2:58:55 PM UTC+8, Frank M wrote:
> James, 
> 
> have you a ODBC or ADO Driver recommendation?
> I found Devart, but expensive for each user to buy. 
> 
> Frank 
> 
> Am Dienstag, 12. September 2017 23:12:12 UTC+2 schrieb James Martin:
> > In my experience the Postgres ADO driver is old and deficient. There are 
> > drivers by other companies that likely work well.
> > 
> > James
> > 
> > On 2017-09-11 10:54 AM, 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
> > >

[toc] | [prev] | [next] | [standalone]


#10986

FromJames Martin <james@northwoodlumber.com>
Date2017-09-14 14:08 -0400
Message-ID<opegj7$q31$1@dont-email.me>
In reply to#10979
I used the native driver (PGOLEDB). Strings work fine, but many ADO 
commands do not work.

James

On 2017-09-13 02:58 AM, Frank M wrote:
> James,
> 
> have you a ODBC or ADO Driver recommendation?
> I found Devart, but expensive for each user to buy.
> 
> Frank
> 
> Am Dienstag, 12. September 2017 23:12:12 UTC+2 schrieb James Martin:
>> In my experience the Postgres ADO driver is old and deficient. There are
>> drivers by other companies that likely work well.
>>
>> James
>>
>> On 2017-09-11 10:54 AM, 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
>>>
> 

[toc] | [prev] | [next] | [standalone]


#10994

FromFrank M <frank_muessner@gmx.de>
Date2017-09-16 07:17 -0700
Message-ID<586e0af5-edb8-4931-806b-b2f678e57af3@googlegroups.com>
In reply to#10986
thanks for the Info. 
I try with VO-SQL and there no possible to use PGOLEDB, that is free in Basic Version. 
Have only i the Problem with PG Boolean´s and ODBC Driver? PG have a Option "Boolean as Char", when use this, i can convert the Logic Values to Char translate in "Fieldget and Fieldput", But no Datawindow can handle this. 
Problem is that PG Datatype for Boolean is String in VO SQL-Classes. 

I think later with X# i have not the Problem, but still in VO i want to move from DBF to SQL. 

Frank 

 

Am Donnerstag, 14. September 2017 20:08:41 UTC+2 schrieb James Martin:
> I used the native driver (PGOLEDB). Strings work fine, but many ADO 
> commands do not work.
> 
> James
> 
> On 2017-09-13 02:58 AM, Frank M wrote:
> > James,
> > 
> > have you a ODBC or ADO Driver recommendation?
> > I found Devart, but expensive for each user to buy.
> > 
> > Frank
> > 
> > Am Dienstag, 12. September 2017 23:12:12 UTC+2 schrieb James Martin:
> >> In my experience the Postgres ADO driver is old and deficient. There are
> >> drivers by other companies that likely work well.
> >>
> >> James
> >>
> >> On 2017-09-11 10:54 AM, 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
> >>>
> >

[toc] | [prev] | [next] | [standalone]


#10996

FromFrank M <frank_muessner@gmx.de>
Date2017-09-18 04:09 -0700
Message-ID<8985fcea-9b82-4c4f-b0f3-839f87a11e1b@googlegroups.com>
In reply to#10994
I have convert all DBF Logical Fields to Numeric. I think that is the best way to manage this. 

Frank

Am Samstag, 16. September 2017 16:17:06 UTC+2 schrieb Frank M:
> thanks for the Info. 
> I try with VO-SQL and there no possible to use PGOLEDB, that is free in Basic Version. 
> Have only i the Problem with PG Boolean´s and ODBC Driver? PG have a Option "Boolean as Char", when use this, i can convert the Logic Values to Char translate in "Fieldget and Fieldput", But no Datawindow can handle this. 
> Problem is that PG Datatype for Boolean is String in VO SQL-Classes. 
> 
> I think later with X# i have not the Problem, but still in VO i want to move from DBF to SQL. 
> 
> Frank 
> 
>  
> 
> Am Donnerstag, 14. September 2017 20:08:41 UTC+2 schrieb James Martin:
> > I used the native driver (PGOLEDB). Strings work fine, but many ADO 
> > commands do not work.
> > 
> > James
> > 
> > On 2017-09-13 02:58 AM, Frank M wrote:
> > > James,
> > > 
> > > have you a ODBC or ADO Driver recommendation?
> > > I found Devart, but expensive for each user to buy.
> > > 
> > > Frank
> > > 
> > > Am Dienstag, 12. September 2017 23:12:12 UTC+2 schrieb James Martin:
> > >> In my experience the Postgres ADO driver is old and deficient. There are
> > >> drivers by other companies that likely work well.
> > >>
> > >> James
> > >>
> > >> On 2017-09-11 10:54 AM, 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
> > >>>
> > >

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web