qsAdoRdd alfa 3
qsAdoRdd alfa 3
Saludos
Quique
Quique
advantages over AdoRDD?
What are the advantages over AdoRDD (free)?
- Antonio Linares
- Site Admin
- Posts: 37481
- Joined: Thu Oct 06, 2005 5:47 pm
- Location: Spain
- Contact:
Re: advantages over AdoRDD?
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.Otto wrote:What are the advantages over AdoRDD (free)?
Saludos
Quique
Quique
- Rick Lipkin
- Posts: 2397
- Joined: Fri Oct 07, 2005 1:50 pm
- Location: Columbia, South Carolina USA
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
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 needRick 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
Saludos
Quique
Quique