Form with paging

Topic Specific Tutorials and Tips.

Moderator: Rathinagiri

Post Reply
User avatar
dragancesu
Posts: 929
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Form with paging

Post by dragancesu »

The big problem is when the table has many rows, how to show it and make it fast

I found data for countries and cities of the world, 250 countries and 94000 cities, I think it is good for example

Download, unzip, then build demo.prg

I know the example is simple, if you have time take a look and write a comment so it could be better
Attachments
paging.zip
(739.59 KiB) Downloaded 807 times
User avatar
danielmaximiliano
Posts: 2618
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Contact:

Re: Form with paging

Post by danielmaximiliano »

Hola Dragan :
yo use en mi POS (point of sale) la identificacion GS1 de cada pais para ubicar de que pais pertenece ese producto con el prefijo y asi poder mostrar su origen con un icono de la bandera del pais... nose como concatenar las cuidades a esos paises .
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
User avatar
Rathinagiri
Posts: 5477
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: Form with paging

Post by Rathinagiri »

When the number or rows/records are huge, use VirtualGrid.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
mol
Posts: 3748
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: Form with paging

Post by mol »

Virtual grid is a great solution!
ASESORMIX
Posts: 196
Joined: Thu Oct 25, 2012 8:08 pm
Location: Bqto, Venezuela

Re: Form with paging

Post by ASESORMIX »

Os recomiendo este ejemplo, puede ayudar a muchos
Attachments
PRUEBA.zip
(1.71 MiB) Downloaded 714 times
User avatar
serge_girard
Posts: 3204
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: Form with paging

Post by serge_girard »

Virtual GRID works with arrays or only with DBF?
I seldom work with DBF: always MySQL.

Serge
There's nothing you can do that can't be done...
Post Reply