It is currently Sat Oct 31, 2020 8:00 pm

All times are UTC + 1 hour




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Data-aware Grid
PostPosted: Wed Aug 19, 2020 10:27 am 
Offline
New User
New User

Joined: Wed Aug 19, 2020 8:49 am
Posts: 3
This is an editable grid that I've been developing in pure PureBasic.

It is data-aware in that it sources its data from a database via a data provider. Currently there is only a SQLite data provider but other data providers can be developed for ODBC, MySQL etc.

It includes features such as:

- Master-Detail grids
- Fixed columns
- Popup editors such as for long text, date/time, and for populating foreign keys from other tables.
- A very basic hand written inline text editor, this was necessary as trying to overlap gadgets, yikes!
It can be used as a base for developing other inline editors.
- Column sorting (currently only one column at a time)
- Basic filtering
- Handles larger datasets by requesting records from the data provider as necessary, it does not request all records at once.

Some screenshots:

1. This shows two grids in master-detail.

Image


2. This shows the calendar popup editor for a date field.

Image


3. This shows the large text popup editor.

Image


4. This shows column sorting with an indicator in the top right of the column header.

Image


5. This shows the list of values popup editor for populating foreign keys. Two fields from the foreign key are used, firstly the primary key which is applied to the database and a more descriptive field such as name or description is shown to the user.

Image


6. This shows another example with filtering applied. It also shows fixed columns (enabled, first name, last name) and a checkbox field.

Image


7. This shows the insert record for creating new records.

Image


Top
 Profile  
Reply with quote  
 Post subject: Re: Data-aware Grid
PostPosted: Wed Aug 19, 2020 1:49 pm 
Offline
Enthusiast
Enthusiast
User avatar

Joined: Sun Jun 22, 2003 7:43 pm
Posts: 620
Location: Germany, Saarbrücken
You didn't add any link to the code or to test it out. Also does it work on Linux too?

_________________
The english grammar is freeware, you can use it freely - But it's not Open Source, i.e. you can not change it or publish it in altered way.


Top
 Profile  
Reply with quote  
 Post subject: Re: Data-aware Grid
PostPosted: Wed Aug 19, 2020 1:56 pm 
Offline
New User
New User

Joined: Wed Aug 19, 2020 8:49 am
Posts: 3
I haven't posted the code or a test sample as it is still work in progress. It should work on Linux with a bit testing and tweaking as I'm not using any platform specific code.


Top
 Profile  
Reply with quote  
 Post subject: Re: Data-aware Grid
PostPosted: Wed Aug 19, 2020 2:09 pm 
Offline
Enthusiast
Enthusiast
User avatar

Joined: Fri Oct 06, 2006 3:57 pm
Posts: 570
Location: England
Looks good.

A few q's if i may :

1. is it DPI aware ?
2. is it a module ?
3. does it have variable row heights ?

Cheers


Top
 Profile  
Reply with quote  
 Post subject: Re: Data-aware Grid
PostPosted: Wed Aug 19, 2020 2:21 pm 
Offline
New User
New User

Joined: Wed Aug 19, 2020 8:49 am
Posts: 3
Thanks for the good questions!

1. I haven't tested DPI aware yet.

2. Yes, it is modular, it is made up of a several modules. The grid can be extended using a "plugin" which is a module that listens to grid events.

3. Unfortunately no variable row heights at the moment. I did consider this but it was adding complexity to the grid functionality that I couldn't yet figure out. This should be a future improvement.

Cheers!


Top
 Profile  
Reply with quote  
 Post subject: Re: Data-aware Grid
PostPosted: Wed Aug 19, 2020 9:32 pm 
Offline
User
User

Joined: Sun Feb 09, 2020 4:56 pm
Posts: 56
It seems interesting and useful, :) I am waiting for its release :wink:


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  

 


Powered by phpBB © 2008 phpBB Group
subSilver+ theme by Canver Software, sponsor Sanal Modifiye