Hi All
I have an issue of SKIP/DBSKIP(1) not respected in a DO WHILE LOOP of a MySQL Table as follows :-
#include "adordd.ch"
#include 'Minigui.ch'
SELECT 0
USE (cDataBase) VIA "ADORDD" alias "FARDAT" TABLE "FARDAT" MYSQL ;
FROM cServer USER cUser PASSWORD cPass
// Properly connected to MySQL Table and value of lastrec() obtained
CalcdepamCounter() // problem function
function CalcdepamCounter()
LOCAL nRecNo
local nCounter:=0
dbgotop()
//
WHILE ! fardat->(eof())
DO EVENTS
nCounter++
msginfo(fardat->fa_no)
nComplete := INT((nCounter/LASTREC()) * 100)
cComplete := LTRIM(STR(nComplete))
MainForm.Progress_1.Value := nComplete
MainForm.Label_001.Value := "Calculating "+ str(nCounter)+'/'+ltrim(str(lastrec()))+CHR(13)+ "Percentage completed "+cComplete + "%"
SKIP // not respected , fardat->(dbskip(1)) and dbskip(1) also not resoected
ENDDO
RETURN nil
Any assistance will be appreciated .
CCH
http://cch4clipper.blogspot.com
HMG - SKIP not respected in MySQL Table
Moderator: Rathinagiri
-
- Posts: 140
- Joined: Tue Mar 03, 2009 8:59 am
Re: HMG - SKIP not respected in MySQL Table
Hi Kathinagiri, Sudip, Marek, Esgici
Are you able to repeat the issue reported via a simple do while loop ?
CCH
http://cch4clipper.blogspot.com
Are you able to repeat the issue reported via a simple do while loop ?
CCH
http://cch4clipper.blogspot.com
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: HMG - SKIP not respected in MySQL Table
Sorry CCH,
I don't use adordd.
I always retrieve the table as an array.
May be, others would help you.
I don't use adordd.
I always retrieve the table as an array.
May be, others would help you.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
-
- Posts: 140
- Joined: Tue Mar 03, 2009 8:59 am
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: HMG - SKIP not respected in MySQL Table
It is a Harbour library. You can find out the list of Harbour libraries which are linked through HMG in 'C:\hmg\HARBOUR\lib'
MingW libraries can be found in 'c:\hmg\MINGW\lib'.
MingW libraries can be found in 'c:\hmg\MINGW\lib'.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: HMG - SKIP not respected in MySQL Table
HI, sorry that I can't help you. I didn't work with mysql anytime.
Maybe I will try, but about wednesday I will find some free time....
Marek
Maybe I will try, but about wednesday I will find some free time....
Marek
-
- Posts: 140
- Joined: Tue Mar 03, 2009 8:59 am