Jump to content

uniXDBGrid Component


patmap
 Share

Recommended Posts

Hi,

 

uniXDBGrid is a simple DBGrid with Sortable and Colapsable future.

 

2.0 2012-12-16

* Add RemoteSort Property

* Support XE3 with ext-4.1.1a

 

Attention: If you want to sort server side, change RemoteSort := True and write own code into OnColumnSort

 

Added two property:


Property Sortable: Boolean ; // For Sortable columns.
Property Collapsible: // For colapsable DBGrid
Property RemoteSort : Boolean Read FRemoteSort Write FRemoteSort Default False;

 

For Delphi XE

 

 

Best Regards

XDBGrid.v.2.0.zip

Link to comment
Share on other sites

Hi patmap,

Good Job for your sharing.

 

Hi Farshade,

IMO, it's better if the important protected Ext_ classes were published to easy workaround like a ClientEvents,

so we can workaround at Delphi side (instead of create new component) and JS code. :lol:

Link to comment
Share on other sites

  • Administrators

Good job patmap!

 

Hi Farshade,

IMO, it's better if the important protected Ext_ classes were published to easy workaround like a ClientEvents,

so we can workaround at Delphi side (instead of create new component) and JS code. :lol:

 

You can use additional properties in onAfterCreate or in any other client event.

  • Upvote 1
Link to comment
Share on other sites

two problems

1. Sort only on the current page

2. Clicks after the changes after the SQL query, the sort failure

 

Hi,

 

1. Sort only on the current page 

 

I test is and sort work on all pages ! Probably you test sort on a numeric column filed ! In the dbgrid it seem Mr. Farshad add all field in the string type. in this mode sort on numeric columns not work correctly.

if you have 100, 20, 300, 50

must be sort 20, 50, 100, 300

but in string mode sort is : 100, 20, 300, 50 !!!!

 

2. Clicks after the changes after the SQL query, the sort failure

 

This sort is client side, not in Server side. for server side maybe server performance down if you have many many record in your table.

Certainty you not have index or key on all fields ! then sort on server side slower then client side.

 

 

Best Regards

Link to comment
Share on other sites

  • 2 months later...

Hi,

 

1. Sort only on the current page 

 

I test is and sort work on all pages ! Probably you test sort on a numeric column filed ! In the dbgrid it seem Mr. Farshad add all field in the string type. in this mode sort on numeric columns not work correctly.

if you have 100, 20, 300, 50

must be sort 20, 50, 100, 300

but in string mode sort is : 100, 20, 300, 50 !!!!

 

2. Clicks after the changes after the SQL query, the sort failure

 

This sort is client side, not in Server side. for server side maybe server performance down if you have many many record in your table.

Certainty you not have index or key on all fields ! then sort on server side slower then client side.

 

 

Best Regards

Hi

//Please replace

Self.ExtGridPanel.JSCode('for(i=1;i<' + Self.ExtGridPanel.GetId.JSName+'.colModel.columns.length;i++){' + Self.ExtGridPanel.GetId.JSName+'.colModel.columns.sortable=' + S + ';};');

// This Code

Self.ExtGridPanel.On('reconfigure',ExtGridPanel.JSFunction('sender, store, colModel',

'for(i=1;i<colModel.columns.length;i++) '#13#10+

'{ '#13#10+

' colModel.columns.sortable='+S+'; '#13#10+

'}'

))

//because after dataset reopen , sortable don't works

Link to comment
Share on other sites

  • 2 months later...

How do this component install to Delphi XE2?

 

When compiling UniXDBGridDXE.dpk in IDE it gives the following error:

 

uniGUI15.dpk(27,2): error F2226: E2225 Never-build package 'rtl' must be recompiled

UniXDBGridDXE.dpk(36): error F2203: E2202 Required package 'uniGUI15' not found

Done building target "_PasCoreCompile" in project "UniXDBGridDXE.dproj" -- FAILED.

Done building project "UniXDBGridDXE.dproj" -- FAILED.

Build FAILED.

 

Thanks a lot.

Link to comment
Share on other sites

  • 1 month later...
  • 6 months later...
  • 3 months later...
  • 1 month later...
  • 4 months later...

Hi,

 

uniXDBGrid is a simple DBGrid with Sortable and Colapsable future.

 

2.0 2012-12-16

* Add RemoteSort Property

* Support XE3 with ext-4.1.1a

 

Attention: If you want to sort server side, change RemoteSort := True and write own code into OnColumnSort

 

Added two property:


	Property Sortable: Boolean ; // For Sortable columns.
	Property Collapsible: // For colapsable DBGrid
	Property RemoteSort : Boolean Read FRemoteSort Write FRemoteSort Default False;
For Delphi XE

 

 

Best Regards

 

 

Hi, would you upload it again, in order to download it?

 

Thank you very much

Link to comment
Share on other sites

  • 1 month later...
  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...