the sample-file SAMPLES\POSTGRESQL.5\tstpgrdd.prg throws a syntax error in the line
Code: Select all
use "select <fields,...> from <table> order by <same order as dbf>" alias <table> via "pgrdd" connection nConn
http://www.matrixlist.com/pipermail/har ... 03857.html
Master Roberto, please be so kind as to add the following definition to the top of the program file.
Code: Select all
#command USE <(db)> [VIA <rdd>] [ALIAS <a>] [<nw: NEW>] ;
[<ex: EXCLUSIVE>] [<sh: SHARED>] [<ro: READONLY>] ;
[CODEPAGE <cp>] [CONNECTION <nConn>] [INDEX <(index1)> [, <(indexN)>]] => ;
dbUseArea( <.nw.>, <rdd>, <(db)>, <(a)>, ;
if(<.sh.> .or. <.ex.>, !<.ex.>, NIL), <.ro.>, [<cp>], [<nConn>] ) ;
[; dbSetIndex( <(index1)> )] ;
[; dbSetIndex( <(indexN)> )]
Code: Select all
nConn := dbpgconnection( "<host>;<database>;<user>;<password>;<port>;<scheme>" )
I could not find any documentation on the pgrdd-driver, so I don't know how to fix this other than to leave out port and scheme and alter the line to
Code: Select all
nConn := dbpgconnection( "<host>;<database>;<user>;<password>" )
Applying those to changes to the sample file will be a big leap forward for others, who try to connect to postgresl-servers.
Thank you very much and have a great weekend!
Raumi75