topic-8203

quique

Posts: 408

Joined: Sun Aug 13, 2006 05:38 AM

qsAdoRdd alfa 3
Posted: Mon Sep 17, 2007 05:02 AM

ftp://quique.quiquesoft.com/qsAdoRdd_Alfa_3.zip

Saludos

Quique

Otto

Posts: 6983

Joined: Fri Oct 07, 2005 07:07 PM

advantages over AdoRDD?
Posted: Mon Sep 17, 2007 05:37 AM

What are the advantages over AdoRDD (free)?

Antonio Linares

Posts: 44158

Joined: Thu Oct 06, 2005 05:47 PM

qsAdoRdd alfa 3
Posted: Mon Sep 17, 2007 06:44 AM

Quique,

Is your RDD based on ADORDD ?

regards, saludos

Antonio Linares
www.fivetechsoft.com

quique

Posts: 408

Joined: Sun Aug 13, 2006 05:38 AM

Re: advantages over AdoRDD?
Posted: Mon Sep 17, 2007 12:51 PM

Otto wrote:What are the advantages over AdoRDD (free)?

The unque advantage I can say is use of index, because I try to use ADORDD of xharbour and it doesn't work, I ask to antonio, and he told me the same, for this I do it. I didn't do but tests.

Saludos

Quique

Rick Lipkin

Posts: 2706

Joined: Fri Oct 07, 2005 01:50 PM

qsAdoRdd alfa 3
Posted: Mon Sep 17, 2007 12:57 PM

ADOrdd is based on Win32ole class included in xHarbour. I use MSSql and Oracle databases .. mostly MS Sql and have found no matter what I do ( programatically ) there is no way to manipulate those indexes. The Server only uses indexes in its execution plan if it will help speed up its query .. and that is a function of the Database .. not the programmer. So I am curious .. have you tried to use MS Sql indexes and can you set orders and seeks on your keys ??

Rick Lipkin
SC Dept of Health, USA

quique

Posts: 408

Joined: Sun Aug 13, 2006 05:38 AM

qsAdoRdd alfa 3
Posted: Mon Sep 17, 2007 01:05 PM

Antonio Linares wrote:Quique,

Is your RDD based on ADORDD ?

Some things are based in idea in xharbour's adordd, but not in code.

Saludos

Quique

quique

Posts: 408

Joined: Sun Aug 13, 2006 05:38 AM

qsAdoRdd alfa 3
Posted: Mon Sep 17, 2007 01:20 PM

Rick Lipkin wrote:ADOrdd is based on Win32ole class included in xHarbour. I use MSSql and Oracle databases .. mostly MS Sql and have found no matter what I do ( programatically ) there is no way to manipulate those indexes. The Server only uses indexes in its execution plan if it will help speed up its query .. and that is a function of the Database .. not the programmer. So I am curious .. have you tried to use MS Sql indexes and can you set orders and seeks on your keys ??

Rick Lipkin
SC Dept of Health, USA

I use MySql, I don't try in MS Sql, but yes, the idea is use xbase commands based in index the most same possible, and yes, it is based on index on slq tables, but it need some help, if you see ejemplo.prg you can see how to do it. The idea is try to use the same code of dbf to ado, because in this moment, I need it, I have a program that use dbf and the boss is offering the same program for mysql, therefore the need

Saludos

Quique

FiveTech Support Forums

Continue the discussion