ADORDD WITH ACCESS DATABASES...

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

ADORDD WITH ACCESS DATABASES...

Post by Roberto Lopez »

Hi All!,

I've been very busy, but I'm here again.

I'm preparing a new HMG release and reviewing bugs reported to SF bug tracker.

I've found one about Browse control in ADORDD-1 sample (.mdb file).

After a painful test I've discovered that the problem is not on Browse control, but in ADORDD (at least with .mdb files).

Try the following:

Code: Select all


        USE bd1.mdb VIA "ADORDD" TABLE "table1" ALIAS bd1

	go top
	msginfo(str(recno()) , 'recno' )

	go 1
	msginfo(str(recno()) , 'recno' )

	go 2
	msginfo(str(recno()) , 'recno' )

The result will be always zero.

Since HMG's Browse rely on recno() function to work, it does not work :)

I've decided to remove the sample until new Harbour version be released (hopefully the problem will be solved).

If someone has additional info about this, please, let me know.

TIA.

Regards,

Roberto.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: ADORDD WITH ACCESS DATABASES...

Post by Rathinagiri »

Welcome Guru!

Gr8 news about the new version.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: ADORDD WITH ACCESS DATABASES...

Post by Roberto Lopez »

rathinagiri wrote:Welcome Guru!

Gr8 news about the new version.
Ok :)

The new release has (at least) one very cool thing :)

I must review all new code a couple of times prior to publish yet.

Regards,

Roberto.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: ADORDD WITH ACCESS DATABASES...

Post by sudip »

Hello Roberto,

Thanks for the good news! I am a learner of HMG! I am in a very basic stage!

I found some error regarding pie. When one or more data values become small with respect to other, Pie chart shows abnormal results. Esgici corrected this problem temporarily. But, IMHO DRAW GRAPH command has some bugs.

Again it will be very helpful if there is an option to show data values within the graph.

With best regards.

Sudip
With best regards,
Sudip
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: ADORDD WITH ACCESS DATABASES...

Post by Roberto Lopez »

sudip wrote:Hello Roberto,

Thanks for the good news! I am a learner of HMG! I am in a very basic stage!
Welcome aboard!
sudip wrote:
I found some error regarding pie. When one or more data values become small with respect to other, Pie chart shows abnormal results. Esgici corrected this problem temporarily. But, IMHO DRAW GRAPH command has some bugs.

Again it will be very helpful if there is an option to show data values within the graph.
Graph lib was contributed by Grigory. Perhaps he has already solved the problems.

Grigory?


Regards,

Roberto.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: ADORDD WITH ACCESS DATABASES...

Post by Roberto Lopez »

Roberto Lopez wrote:
Graph lib was contributed by Grigory. Perhaps he has already solved the problems.

Grigory?
Already solved.

The solution was to check 'cumulative' array in the main for...next.
If the previous value is equal to previous then perform no action (loop).

Regards,

Roberto.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
gfilatov
Posts: 1066
Joined: Fri Aug 01, 2008 5:42 am
Location: Ukraine
Contact:

Re: ADORDD WITH ACCESS DATABASES...

Post by gfilatov »

Roberto Lopez wrote:
Roberto Lopez wrote:
Graph lib was contributed by Grigory. Perhaps he has already solved the problems.

Grigory?
Already solved.

The solution was to check 'cumulative' array in the main for...next.
If the previous value is equal to previous then perform no action (loop).
Hi Roberto,

Thanks a lot for this fix. :idea:

BTW The author of Pie control is Mr. Rathinagiri AFAIK.
Kind Regards,
Grigory Filatov

"Everything should be made as simple as possible, but no simpler." Albert Einstein
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: ADORDD WITH ACCESS DATABASES...

Post by Rathinagiri »

Yes. It was once upon a time. :)
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: ADORDD WITH ACCESS DATABASES...

Post by Roberto Lopez »

gfilatov wrote:
Roberto Lopez wrote:
Roberto Lopez wrote:
Graph lib was contributed by Grigory. Perhaps he has already solved the problems.

Grigory?
Already solved.

The solution was to check 'cumulative' array in the main for...next.
If the previous value is equal to previous then perform no action (loop).
Hi Roberto,

Thanks a lot for this fix. :idea:

BTW The author of Pie control is Mr. Rathinagiri AFAIK.
Thanks for the quick response.

And... I'm sorry... you are right, pie was a separated contribution by Rathinagiri.

Regards,

Roberto.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: ADORDD WITH ACCESS DATABASES...

Post by sudip »

Hello Roberto,

Thank you very much. Problem has been solved. I checked it. :)

Hi Rathi,

Thanks for the excellent utility. My clients like the pie chart (even seeing the previous small error) :)

With best regards to you all.

Sudip
With best regards,
Sudip
Post Reply