New AdoRDD (free)

[Gale FORd]

I compiled and linked provided prg's with xHarbour commercial and FWH and it is working ok so far.

Thanks,

[Antonio Linares]

Code: Select all  Expand view  RUN

2007-04-27 19:33 UTC+0100 Antonio Linares (alinares@fivetechsoft.com)
   * contrib/adordd/adordd.ch
   * contrib/adordd/adordd.prg
      * QUERY support and MS SQL support (thanks to Vikthor!)

Vikthor already successfully tested the ADORDD on Microsoft SQL server and added a new clause QUERY :-)

Regards,

Antonio


[Vikthor]

A.S.K.

You just need AdoRdd.lib and HbOleAut.lib if you use Harbour. For xharbour users, just AdoRdd.lib

Antonio I use xharbour but I don't have ADORDD.LIB .Can you please tell me where I can found it?

Thank you in advance
A.S.K.

if you are using xHarbour and got this errors :

Code: Select all  Expand view  RUN

Error: Unresolved external '_HB_FUN_USRRDD_RDDDATA' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_USRRDD_AREADATA' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_USRRDD_ID' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_UR_SUPER_ERROR' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_UR_SUPER_SETFIELDEXTENT' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_UR_SUPER_ADDFIELD' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_UR_SUPER_OPEN' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_UR_SUPER_CLOSE' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_USRRDD_GETFUNCTABLE' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd


you must be add usrrdd library into linked

by the way , if you are using Microsoft SQL Server 2005 , and wish use adordd , you must be make little changes to adordd.prg file

Code: Select all  Expand view  RUN


       case s_cEngine == "SQL"
              oAdo:CursorType      = adOpenStatic
              oAdo:CursorLocation = adUseClient
              oAdo:LockType         = adLockPessimistic
              oAdo:Open( "SELECT * FROM " + s_cTableName,;
                                "Provider=SQLOLEDB;" + ;
                                "server=" + s_cServer + ;
                                ";database=" + aOpenInfo[ UR_OI_NAME ] + ;
                                ";uid=" + s_cUserName + ;
                                ";pwd=" + s_cPassword, adOpenKeyset, adLockOptimistic )


and need modify this line into Adordd.ch

Code: Select all  Expand view  RUN

[ <dbEngine: ACCESS, MYSQL, ORACLE, INFORMIX, SQL> ];


USE northwind VIA "ADORDD" TABLE "Customer" SQL ;
FROM "ServerSql2005" USER "sa" PASSWORD "super"
Browse()
[/code]



Y finally , like said Rene, SQL dosen'n need ODBC

Fernando y Antonio...¡¡ felicitaciones por este aporte !!

and .... remote connections with SQL y MySQL works perfect


Sorry, but my english is very , very bad.

[RAMESHBABU]

Hi Friends

you must be add usrrdd library into linked

Can a get a copy of USRRDD.LIB please.

My email : aksharasoft@hotmail.com

Thanks

- Ramesh Babu P

[Eugeniusz Owsiak]

You can get it from http://www.harbour-project.org/ downloading the latest stable binaries.

Regards Eugeniusz

[Antonio Linares]

Here it is usrrdd.lib for Harbour:

http://rapidshare.com/files/28329001/usrrdd.zip.html

And here it is for xharbour:

http://rapidshare.com/files/28329167/usrrdd.zip.html

[Antonio Linares]

SET FILTER TO ... support

i.e.: SET FILTER TO First = "Homer"

To use special SQL expressions, place quotation marks around them, i.e.:
SET FILTER TO "City LIKE 'Chi*'"

http://rapidshare.com/files/28522792/adordd.zip.html

[Enrico Maria Giordano]

It should be

Code: Select all  Expand view  RUN

SET FILTER TO "City LIKE 'Chi%'"

as far as I know.

EMG

[Antonio Linares]

Enrico,

Thanks for your info

Anyhow, SET FILTER TO "City LIKE 'Chi*'" seems to be working fine too:

[Enrico Maria Giordano]

I wonder if the used character is db engine dependent...

EMG

[Enrico Maria Giordano]

I used '%' with Jet, MSDE, MSSQL and MSVFP driver.

EMG

[Antonio Linares]

Enrico,

Yes, probably.

We are doing the tests with MySQL and Access and it worked fine.

[Baxajaun]

Antonio,

Enrico is right !

http://www.techonthenet.com/sql/like.php

http://en.wikipedia.org/wiki/SQL

Regards,

Felix

[Antonio Linares]

Felix,

Thanks

[Antonio Linares]

2007-04-29 17:34 UTC+0100 Antonio Linares (alinares@fivetechsoft.com)
* contrib/adordd/adordd.prg
* Oracle support, thanks to Srdjan Dragojlovic

* contrib/adordd/adordd.ch
* formatting

You may download it from here:
http://rapidshare.com/files/28565058/adordd.zip.html