Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #10970 > unrolled thread
| Started by | Frank M <frank_muessner@gmx.de> |
|---|---|
| First post | 2017-09-11 07:54 -0700 |
| Last post | 2017-09-18 04:09 -0700 |
| Articles | 14 — 6 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | Frank M <frank_muessner@gmx.de> |
|---|---|
| Date | 2017-09-11 07:54 -0700 |
| Subject | Postgres 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]
| From | Franz Rachbauer <office@rachbauer.org> |
|---|---|
| Date | 2017-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]
| From | Frank M <frank_muessner@gmx.de> |
|---|---|
| Date | 2017-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]
| From | Franz Rachbauer <office@rachbauer.org> |
|---|---|
| Date | 2017-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2017-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]
| From | Frank M <frank_muessner@gmx.de> |
|---|---|
| Date | 2017-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]
| From | "Karl-Heinz" <invalid@invalid.invalid> |
|---|---|
| Date | 2017-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]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2017-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]
| From | Frank M <frank_muessner@gmx.de> |
|---|---|
| Date | 2017-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2017-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]
| From | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| Date | 2017-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]
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Date | 2017-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]
| From | Frank M <frank_muessner@gmx.de> |
|---|---|
| Date | 2017-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]
| From | Frank M <frank_muessner@gmx.de> |
|---|---|
| Date | 2017-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