PureBasic Forums - English

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.




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




3. This shows the large text popup editor.




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




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.




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




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

You didn't add any link to the code or to test it out. Also does it work on Linux too?

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.

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

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!

It seems interesting and useful, I am waiting for its release

No release?

dagcrack wrote: Sun Sep 05, 2021 12:00 amNo release?

Doesn't look like he's around here anymore: