MiniGUI DBU

HMG Samples and Enhancements

Moderator: Rathinagiri

Georg_BA
Posts: 28
Joined: Fri Apr 07, 2017 5:31 pm
DBs Used: DBF

Re: MiniGUI DBU

Post by Georg_BA » Thu Nov 08, 2018 11:10 am

Hello everyone
I would also wonder why the feature's browse support function has disappeared
tbrowse lost completely

Regards, Georg

User avatar
gfilatov
Posts: 573
Joined: Fri Aug 01, 2008 5:42 am
Location: Ukraine
Has thanked: 14 times
Been thanked: 138 times
Contact:

Post by gfilatov » Thu Nov 08, 2018 6:58 pm

edk wrote:
Thu Nov 08, 2018 8:13 am
Hi again.
gfilatov wrote:
Wed Nov 07, 2018 7:36 pm
Please be so kind to review the updated attached application with the last improvements.

BTW I can not reproduce above wrong behavior in this version 0.64 ;)
Small Errat.
It works fine on my home computer, at work: on some computers it's OK, and others are not. I was looking for differences, I compared the OS version, environment settings. In the end I came to the fact that the reason is the resolution of the screen.

I made the test on one computer (Win10 v.1803, 64-bit) and here are the results:

It's correct for resolutions:
1152 x 864
1280 x 600
1280 x 720
1280 x 800
1280 x 960
1280 x 1024
1440 x 1050
1440 x 900
1600 x 900
1680 x 1050
1920 x 1080

Incorrectly at resolutions:
1024 x 768
1280 x 768
1360 x 768
1366 x 768

As you can see, it is incorrect when the screen height is set to 768 pixels.

Regards, Edward.
Hi Edward,

Thanks for your investigations and feedback.

I can not reproduce this problem in my home PC (please look at attached screenshot with resolution 1280x768).

BTW I've attached also an updated version of this application for your review.
Attachments
MGDBU065.zip
(951.58 KiB) Downloaded 18 times
1260x768.png
1260x768.png (158.4 KiB) Viewed 195 times
Kind Regards,
Grigory Filatov

"Everything should be made as simple as possible, but no simpler." Albert Einstein

edk
Posts: 361
Joined: Thu Oct 16, 2014 11:35 am
Location: Poland
Has thanked: 102 times
Been thanked: 262 times

Post by edk » Thu Nov 08, 2018 10:20 pm

Hi Grigory.
Thanks for the new version. In the attachment, I present a video showing how TsBrowse behaves on my computer at resolutions of 1280x800 and 1024x768.
Nagrywaj_2018_11_08_23_10_16_326.7z
(4.86 MiB) Downloaded 19 times
Can anyone confirm it on their own computer?

Regards, Edward

User avatar
gfilatov
Posts: 573
Joined: Fri Aug 01, 2008 5:42 am
Location: Ukraine
Has thanked: 14 times
Been thanked: 138 times
Contact:

Post by gfilatov » Fri Nov 09, 2018 8:21 pm

edk wrote:
Thu Nov 08, 2018 10:20 pm
Hi Grigory.
Thanks for the new version. In the attachment, I present a video showing how TsBrowse behaves on my computer at resolutions of 1280x800 and 1024x768.
Nagrywaj_2018_11_08_23_10_16_326.7z

Can anyone confirm it on their own computer?

Regards, Edward
Hi Edward,

Ok, thanks for your video confirmation.
Please be so kind to revise the latest attached version.

Your feedback is welcome :!:
Attachments
MGDBU066.zip
Latest version for testing
(955.09 KiB) Downloaded 32 times
Kind Regards,
Grigory Filatov

"Everything should be made as simple as possible, but no simpler." Albert Einstein

edk
Posts: 361
Joined: Thu Oct 16, 2014 11:35 am
Location: Poland
Has thanked: 102 times
Been thanked: 262 times

Post by edk » Fri Nov 09, 2018 10:07 pm

Hey,
thanks for your patience.
After changing the height of the grid header is now OK for the window height 768 px.
I did some more tests. They show that the problem occurs when the window size is set to such a height that the horizontal slider obscures the line separating the rows. I do not know if you understand me well, because my English is not the best, so I will try to present it with screenshots.
At this window height the scrolling is correct.
test1.png
609 x 276 px
test1.png (20.96 KiB) Viewed 142 times
And at this height, the records are duplicated during scrolling.
test2.png
609 x 275 px
test2.png (20.93 KiB) Viewed 142 times
The difference between windows is 1 px in height.

If we still reduce the window height by another 1 px, then they are not duplicated, but the last line (the incomplete height) is not refreshed.
test3.png
609 x 274 px
test3.png (20.9 KiB) Viewed 142 times
Can you confirm it and report it to the TsBrowse authors?

By the way, I noticed one more curiosity: the size of the window that I define in HMG does not correspond to the size of the window on the screen (the size read from the capture of the screenshot)
The size of 600 x 275 px is defined in the sources:

Code: Select all

#include "hmg.ch"

FUNCTION Main()

DEFINE WINDOW Form1 AT 0 , 0 WIDTH 600 HEIGHT 275 TITLE 'Main' 	MAIN 
END WINDOW

CENTER WINDOW Form1
ACTIVATE WINDOW Form1

Return Nil
and the screenshot is made in the size of 586 x 268 px. (difference in dpi?)
test4.png
586 x 268 px
test4.png (2 KiB) Viewed 142 times

User avatar
gfilatov
Posts: 573
Joined: Fri Aug 01, 2008 5:42 am
Location: Ukraine
Has thanked: 14 times
Been thanked: 138 times
Contact:

Post by gfilatov » Sat Nov 10, 2018 5:37 pm

edk wrote:
Fri Nov 09, 2018 10:07 pm
Hey,
thanks for your patience.
After changing the height of the grid header is now OK for the window height 768 px.
I did some more tests. They show that the problem occurs when the window size is set to such a height that the horizontal slider obscures the line separating the rows. I do not know if you understand me well, because my English is not the best, so I will try to present it with screenshots.

Can you confirm it and report it to the TsBrowse authors?
Hi Edward,

Thanks for your tests and explanation.

It is a known problem in the TsBrowse library but it is not critical.
The simple workaround is a placing of the TBrowse object into a window with the NOSIZE style.

BTW Your English is a perfect in the comparison with me :lol:
Kind Regards,
Grigory Filatov

"Everything should be made as simple as possible, but no simpler." Albert Einstein

edk
Posts: 361
Joined: Thu Oct 16, 2014 11:35 am
Location: Poland
Has thanked: 102 times
Been thanked: 262 times

Post by edk » Sat Nov 10, 2018 6:43 pm

Hello Grigory.
Thanks for the info, I keep my fingers crossed for the development of TsBrowse, it seems to me that it has great potential.
It's a pity that it isn't in the official HMG.
I regret that I can't help in its development and implementation in HMG due to poor knowledge of C.

P.S. You' re very kind.

Regards, Edward.

User avatar
gfilatov
Posts: 573
Joined: Fri Aug 01, 2008 5:42 am
Location: Ukraine
Has thanked: 14 times
Been thanked: 138 times
Contact:

Post by gfilatov » Sat Nov 10, 2018 8:12 pm

edk wrote:
Sat Nov 10, 2018 6:43 pm
...
It's a pity that it isn't in the official HMG.
Hello Edward,

Did you take a look for the following very old post at

http://www.hmgforum.com/viewtopic.php?f=8&t=1492

:?:
Kind Regards,
Grigory Filatov

"Everything should be made as simple as possible, but no simpler." Albert Einstein

User avatar
gfilatov
Posts: 573
Joined: Fri Aug 01, 2008 5:42 am
Location: Ukraine
Has thanked: 14 times
Been thanked: 138 times
Contact:

Post by gfilatov » Tue Nov 13, 2018 6:29 pm

Hi All,

I've uploaded a latest version of MiniGUI DataBase Utility for your review.

Your feedback is welcome :)
Attachments
MGDBU068.zip
mgDBU application
(962.28 KiB) Downloaded 22 times
Kind Regards,
Grigory Filatov

"Everything should be made as simple as possible, but no simpler." Albert Einstein

User avatar
koke
Posts: 78
Joined: Wed Aug 21, 2013 3:54 pm
DBs Used: DBF, mySql, mariaDB
Has thanked: 19 times
Been thanked: 24 times

Post by koke » Tue Nov 13, 2018 6:56 pm

hi grigory
great job but it gives me the next error.
regards.

Application: G:\Downloads\MGDBU068\MGDBU.exe
Date: 13/11/2018 Time: 12:54:26
Time from start: 0 days 0 hours 1 mins 51 secs
Error BASE/1003 Variable does not exist: NUMERO

Called from (b)FIELDWBLOCK(0)
Called from TSBROWSE:BDATAEVAL(1554) in module: h_tbrowse.prg
Called from TSBROWSE:DRAWLINE(3453) in module: h_tbrowse.prg
Called from TSBROWSE:PAINT(9739) in module: h_tbrowse.prg
Called from TCONTROL:HANDLEEVENT(878) in module: TControl.prg
Called from TSBROWSE:HANDLEEVENT(8291) in module: h_tbrowse.prg
Called from EVENTS(94) in module: h_events.prg
Called from DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(1498) in module: h_windows.prg
Called from MAIN(143) in module: MGDBU.prg
,___,
[O.o]
/)__)
-”–”-
KoKe

Post Reply