FiveTech Software tech support forums

Dear Antonio,

Thank you for your help.

AHF wrote:What do you mean open record ?

I mean open table with all records.

Lucas and Dutch,

Please remember that only the number of records its not enough.

The recsize x nrecords (although in SQL its indicative) its what matters mainly on WAN as this represents the bytes number bring across the cable.

Can you check that?

I try to create view from 2 table as below

Code: Select all  Expand view

cCreateViewSql := "CREATE VIEW TBLGST AS SELECT CCRTBL.TBL_RMNO, CCRTBL.TBL_LAST, CCRTBL.TBL_FIRST, CCRTBL.TBL_ARR, CCRTBL.TBL_DEP,  CCRGST.GST_LAST FROM CCRTBL INNER JOIN CCRGST ON CCRTBL.TBL_GSTNO=CCRGST.GST_INTNO"
hb_GetAdoConnection():Execute(cCreateViewSql)

But got an error as

Code: Select all  Expand view

Description : Error ADODB.Connection/0  S_OK: EXECUTE
   Args:
     [   1] = C   CREATE VIEW TBLGST AS SELECT CCRTBL.TBL_RMNO, CCRTBL.TBL_LAST, CCRTBL.TBL_FIRST, CCRTBL.TBL_ARR, CCRTBL.TBL_DEP,  CCRGST.GST_LAST FROM CCRTBL INNER JOIN CCRGST ON CCRTBL.TBL_GSTNO=CCRGST.GST_INTNO

 

Dutch,

Please remember that without any autoinc field it will not navigate correctly so you must include that field always.
I dont think you can join with different field names.

CCRTBL.TBL_GSTNO=CCRGST.GST_INTNO"

Dear Antonio,

The problem is my misunderstood. The VIEW has created but I will recreate it then it got error. I have to DROP VIEW before CREATE VIEW, if exist.
But it still take long time to CREATE VIEW. After reuse view, it is quite fast.

Regards,
Dutch

Dutch,

I think you should only need to create view once.
Then simply use it as any other table.
I think View is kept updated by the server.

Is It Working with MariaDB ?

Vilian,

Never tried it.

Can you try to use MYSQL engine at ADORDD and at the Mysql ODBC set it up to connect to MariaDb?

I think the connection string its the same but if not it should be very easy to add support for it in ADORDD.

New version adordd posted at https://github.com/AHFERREIRA/adordd.git

Code improvements
Corrected bug in Append from
Working without true locks maintain locklist array nevertheless
Get date value from a field was returning date + time comparison of dDate = dDate even equal dates was returning false. Forgotten to un comment during trials
Trusted connection in MSSQL con string

Antonio, two errors in the new Version:
In ADO_TRANS() the variable n are not defined.
In ADO_FILE() the variable cTmpTable not defined.

Gunther,

Done!

Thanks.

Ill post new version today.

New version adordd at https://github.com/AHFERREIRA/adordd.git

Minor corrections.
Added connection strings to (not tested) :

SQLITE
POSTGRE
INFORMIX
ANYWHERE

Antonio,

You are doing an excellent work, congratulations!

I am trying to compile the ADORDD.PRG but I am getting the following "unresolved externals" (see below).

I was using the standard buildx.bat program but then I found the functions in xHarbour\libs\rdds.lib and added this lib to the buildx.bat but the same unresolved externals are still showing up.

buildx.bat
...
echo %hdirl%\rdds.lib + >> b32.bc

Maybe I am also missing a CH file?

How can I confirm that the RDDS.LIB is getting linked in?

Regards,
James



ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿
³ FiveWin for xHarbour 15.05 - Jun. 2015 xHarbour development power ³Ü
³ (c) FiveTech, 1993-2015 for Microsoft Windows 9X/NT/200X/ME/XP/Vista/7/8 ³Û
ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙÛ
ÿ ßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßß
Compiling...
xHarbour 1.2.3 Intl. (SimpLex) (Build 20130326)
Copyright 1999-2013, http://www.xharbour.org http://www.harbour-project.org/
Compiling 'adordd.prg' and generating preprocessed output to 'adordd.ppo'...

100
...
5400
Generating C source output to 'adordd.c'...
Done.

Lines 5387, Functions/Procedures 131, pCodes 17944
Borland C++ 5.82 for Win32 Copyright (c) 1993, 2005 Borland
adordd.c:
Turbo Incremental Link 5.69 Copyright (c) 1997-2005 Borland
Error: Unresolved external '_HB_FUN_USRRDD_RDDDATA' referenced from C:\USERS\JAMES\DOCUMENTS\PROJECTS\ADORDD\ADORDD.OBJ
Error: Unresolved external '_HB_FUN_USRRDD_AREADATA' referenced from C:\USERS\JAMES\DOCUMENTS\PROJECTS\ADORDD\ADORDD.OBJ
Error: Unresolved external '_HB_FUN_UR_SUPER_ERROR' referenced from C:\USERS\JAMES\DOCUMENTS\PROJECTS\ADORDD\ADORDD.OBJ
Error: Unresolved external '_HB_FUN_UR_SUPER_SETFIELDEXTENT' referenced from C:\USERS\JAMES\DOCUMENTS\PROJECTS\ADORDD\ADORDD.OBJ
Error: Unresolved external '_HB_FUN_UR_SUPER_ADDFIELD' referenced from C:\USERS\JAMES\DOCUMENTS\PROJECTS\ADORDD\ADORDD.OBJ
Error: Unresolved external '_HB_FUN_UR_SUPER_OPEN' referenced from C:\USERS\JAMES\DOCUMENTS\PROJECTS\ADORDD\ADORDD.OBJ
Error: Unresolved external '_HB_FUN_UR_SUPER_CLOSE' referenced from C:\USERS\JAMES\DOCUMENTS\PROJECTS\ADORDD\ADORDD.OBJ
Error: Unresolved external '_HB_FUN_UR_SUPER_EVALBLOCK' referenced from C:\USERS\JAMES\DOCUMENTS\PROJECTS\ADORDD\ADORDD.OBJ
Error: Unresolved external '_HB_FUN_USRRDD_GETFUNCTABLE' referenced from C:\USERS\JAMES\DOCUMENTS\PROJECTS\ADORDD\ADORDD.OBJ
* Linking errors *

Process completed, Exit Code 0.
Execution time: 00:10.375

--------------------------------------

Hello,

You have to link USRRDD.LIB OR HBUSRRDD.LIB in Harbour.

In your main, put REQUEST ADORDD, ADOVERSION