New AdoRDD (free)

User avatar
Rick Lipkin
Posts: 2397
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA

Post by Rick Lipkin »

Enrico

This could be a complicated issue for Antonio and the ADO rdd developers .. RDD is so engrained with the concept of indexes .. for me ( with your help ) .. I have been able to leverage my rdd knowledge in substituting the ADO methods and have almost finished my complete re-write of a very complicated and robust application in MS SQL.

I see where the current ADO rdd builds on indexes for relations .. to me .. going into this ADO project .. I have totally abandoned indexes and sharpened my SQL to to just query what I want and not ( never, never ) do a SELECT * from TABLE unless I have to do an APPEND addnew() and that cursor is a bit UGLY 25k worth of records with a complete field recorset.

For the most part .. ( day to day ) data entry is limited to editing existing records and adding or editing related records spun off with a seperate recordset SELECT * ( or fields ) from <relational table> where <condition> = <primary key> .. returns only a cursor with limited records and I might add with no INDEXES... very fast.

I have noticed a 'severe' limitation to the SQL part of the ( open ) connection string in that if you list fields to limit your query .. if you add more than 6 or 7 .. xHarbours ADO will lock up .. apparently there is a limit on the length of the charactor string you can pass ..

I have taken a fresh approach to ADO and have totally wiped indexes off my radar scope. Now .. with that said .. I think the FIND method could be wrapped up into seek .. however if you use .dbf and ADO in combination you are going to have a translation problem .. what perhaps could happen is leave traditional seek in the ADO rdd for those developers that can use those databases that support indexes .. but spin off a new command like SeekAdo ( cSQL ) that one could use the oRs:Find() wrapper.

Also needed is the <order by> clause in the USE command which I have found to have very little overhead in presenting a records fetch.. plus I think it helps if the <order by> is your primary key ..

Lots of potential here .. could open up the whole RDMS world to xBase !!

Rick Lipkin
Willy
Posts: 117
Joined: Thu Mar 02, 2006 11:06 am
Location: Belgium

How to connect to MS SQL server

Post by Willy »

I have installed a free MS SQL 2005 server on a server.

I've build a database with some tables.

How can I connect to it. Do I have to use a path or an ip adress.

Do I need a client dll ??

I think the examples in the adordd are working for a local file.

Thanks,

Willy Hermans.
User avatar
Baxajaun
Posts: 853
Joined: Wed Oct 19, 2005 2:17 pm
Location: Gatika. Bizkaia

Post by Baxajaun »

Hi Willy,

try http://fivetechsoft.com/forums/viewtopic.php?t=7312

You can use Server Name if you use DNS Server or hosts file with names and ips.

No, you don't need a client.

Best regards,

Felix
Willy
Posts: 117
Joined: Thu Mar 02, 2006 11:06 am
Location: Belgium

Post by Willy »

Use "MediBank" Via "ADORDD" Table "Provider" FROM "Server\SQLEXPRESS" User "sa" PASSWORD "" SQL
If I run this I have an error code 16389 E_Fail:Open

The User is sa and there is no password

It works in visual studio

Any idea

Thanks,

Willy Hermans
Ehab Samir Aziz
Posts: 334
Joined: Fri Oct 14, 2005 1:54 pm

Post by Ehab Samir Aziz »

How can I change my buildh.bat . I did some chnages with some errors :

Code: Select all

echo c0w32.obj + > b32.bc
echo %1.obj, + >> b32.bc
echo %1.exe, + >> b32.bc
echo %1.map, + >> b32.bc
echo %fwhdir%\lib\FiveH.lib %fwhdir%\lib\FiveHC.lib + >> b32.bc
echo %hdir%\lib\rtl.lib + >> b32.bc
echo %hdir%\lib\vm.lib + >> b32.bc
echo %hdir%\lib\gtgui.lib + >> b32.bc
echo %hdir%\lib\lang.lib + >> b32.bc
echo %hdir%\lib\macro.lib + >> b32.bc
echo %hdir%\lib\rdd.lib + >> b32.bc
echo %hdir%\lib\dbfntx.lib + >> b32.bc
echo %hdir%\lib\dbfcdx.lib + >> b32.bc
echo %hdir%\lib\dbffpt.lib + >> b32.bc
echo %hdir%\lib\hbsix.lib + >> b32.bc
echo %hdir%\lib\debug.lib + >> b32.bc
echo %hdir%\lib\common.lib + >> b32.bc
echo %hdir%\lib\pp.lib + >> b32.bc
echo %hdir%\lib\codepage.lib + >> b32.bc

rem Uncomment these two lines to use Advantage RDD
echo %fwhdir%\lib\adordd.lib + >> b32.bc
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
echo %hdir%\lib\Ace32.lib + >> b32.bc
echo %hdir%\lib\Ads32.lib + >> b32.bc

echo %bcdir%\lib\cw32.lib + >> b32.bc
echo %bcdir%\lib\import32.lib + >> b32.bc
echo %bcdir%\lib\psdk\odbc32.lib + >> b32.bc
echo %bcdir%\lib\psdk\nddeapi.lib + >> b32.bc
echo %bcdir%\lib\psdk\iphlpapi.lib + >> b32.bc
echo %bcdir%\lib\psdk\rasapi32.lib + >> b32.bc
echo %fwhdir%\lib\hboleaut.lib, >> b32.bc
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
errors :
Compiling...
Harbour Alpha build 1.0 Intl.
Copyright 1999-2007, http://www.harbour-project.org/
Compiling 'access1.prg' and generating preprocessed output to 'access1.ppo'...
Lines 3712, Functions/Procedures 1
Generating C source output to 'access1.c'... Done.
Borland C++ 5.5.1 for Win32 Copyright (c) 1993, 2000 Borland
access1.c:
Turbo Incremental Link 5.00 Copyright (c) 1997, 2000 Borland
Error: Unresolved external '_HB_FUN_USRRDD_RDDDATA' referenced from E:\COMPILER
CLIPPER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_USRRDD_AREADATA' referenced from E:\COMPILE
\CLIPPER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_USRRDD_ID' referenced from E:\COMPILER\CLIP
ER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_UR_SUPER_ERROR' referenced from E:\COMPILER
CLIPPER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_HB_ISLOGICAL' referenced from E:\COMPILER\C
IPPER\FWH\LIB\HBOLEAUT.LIB|win32ole
Error: Unresolved external '_HB_FUN_UR_SUPER_SETFIELDEXTENT' referenced from E:
COMPILER\CLIPPER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_UR_SUPER_ADDFIELD' referenced from E:\COMPI
ER\CLIPPER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_UR_SUPER_OPEN' referenced from E:\COMPILER\
LIPPER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_UR_SUPER_CLOSE' referenced from E:\COMPILER
CLIPPER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_USRRDD_GETFUNCTABLE' referenced from E:\COM
ILER\CLIPPER\FWH\LIB\ADORDD.LIB|adordd
* There are errors

E:\programs\Database\clipper\FWH\adordd>
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Post by Antonio Linares »

Ehab,

You have to link usrrdd.lib too
regards, saludos

Antonio Linares
www.fivetechsoft.com
Ehab Samir Aziz
Posts: 334
Joined: Fri Oct 14, 2005 1:54 pm

Post by Ehab Samir Aziz »

I got that error :

Compiling...
Harbour Alpha build 1.0 Intl.
Copyright 1999-2007, http://www.harbour-project.org/
Compiling 'access1.prg' and generating preprocessed output to 'access1.ppo'...
Lines 3712, Functions/Procedures 1
Generating C source output to 'access1.c'... Done.
Borland C++ 5.5.1 for Win32 Copyright (c) 1993, 2000 Borland
access1.c:
Turbo Incremental Link 5.00 Copyright (c) 1997, 2000 Borland
Error: Unresolved external '_hb_rddGetWorkAreaPointer' referenced from E:\COMPIL
ER\CLIPPER\FWH\LIB\USRRDD.LIB|usrrdd
Error: Unresolved external '_HB_FUN_HB_ISLOGICAL' referenced from E:\COMPILER\CL
IPPER\FWH\LIB\HBOLEAUT.LIB|win32ole
* There are errors

Code: Select all

rem Uncomment these two lines to use Advantage RDD
echo %fwhdir%\lib\adordd.lib + >> b32.bc
echo %fwhdir%\lib\usrrdd.lib + >> b32.bc
echo %fwhdir%\lib\hboleaut.lib + >> b32.bc

echo %hdir%\lib\Ace32.lib + >> b32.bc
echo %hdir%\lib\Ads32.lib + >> b32.bc

echo %bcdir%\lib\cw32.lib + >> b32.bc
echo %bcdir%\lib\import32.lib + >> b32.bc
echo %bcdir%\lib\psdk\odbc32.lib + >> b32.bc
echo %bcdir%\lib\psdk\nddeapi.lib + >> b32.bc
echo %bcdir%\lib\psdk\iphlpapi.lib + >> b32.bc
echo %bcdir%\lib\psdk\rasapi32.lib , >> b32.bc

User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Post by Antonio Linares »

Ehab,

Download the most recent Harbour build for FWH from www.fivetechsoft.com/files/harbour.exe
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Nop
Posts: 107
Joined: Tue Apr 11, 2006 4:36 pm
Location: Uberaba/Brazil

Post by Nop »

hi, when i down last code of adordd? thanks
User avatar
jose_murugosa
Posts: 943
Joined: Mon Feb 06, 2006 4:28 pm
Location: Uruguay
Contact:

Post by jose_murugosa »

Antonio,
Está en este foro la última versión de AdoRDD?

Cual es el link para bajarla?

Gracias de antemano.
Saludos/Regards,
José Murugosa
FWH + Harbour + Bcc7. Una seda!
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Post by Antonio Linares »

regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
jose_murugosa
Posts: 943
Joined: Mon Feb 06, 2006 4:28 pm
Location: Uruguay
Contact:

Post by jose_murugosa »

Antonio Linares wrote:José,

www.fivetechsoft.com/files/adordd.zip
Muchas gracias Antonio.
Saludos/Regards,
José Murugosa
FWH + Harbour + Bcc7. Una seda!
User avatar
Maurizio
Posts: 705
Joined: Mon Oct 10, 2005 1:29 pm
Contact:

Post by Maurizio »

Hello Antonio

is it possible create a table with MySql ?
I try this but doesn't work

DbCreate( "licenze;rag;MYSQL;localhost;root;mauri",;
{ { "FIRST", "C", 10, 0 },;
{ "LAST", "C", 10, 0 },;
{ "AGE", "N", 8, 0 } }, "ADORDD" )

Regards MAurizio
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Post by Antonio Linares »

Maurizio,

In our tests we have not been able to create it, probably because we were using a remote MySQL host free website. If you are able to create it using standard ADO, then ADORDD should also work as ADORDD is just a wrapper on top of ADO and USRRDD
regards, saludos

Antonio Linares
www.fivetechsoft.com
gibaf
Posts: 15
Joined: Thu Sep 21, 2006 2:04 pm
Location: Brasil - Toledo - PR
Contact:

Post by gibaf »

O ADORDD funciona com Postgres ?
Se sim, como ?

Obrigado
Post Reply