patmap Posted August 1, 2011 Posted August 1, 2011 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 Quote
thecrgrt Posted August 1, 2011 Posted August 1, 2011 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. Quote
Administrators Farshad Mohajeri Posted August 2, 2011 Administrators Posted August 2, 2011 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. You can use additional properties in onAfterCreate or in any other client event. 1 Quote
gywlx Posted August 4, 2011 Posted August 4, 2011 two problems 1. Sort only on the current page 2. Clicks after the changes after the SQL query, the sort failure Quote
patmap Posted August 4, 2011 Author Posted August 4, 2011 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 Quote
stas Posted October 27, 2011 Posted October 27, 2011 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 Quote
dynamo Posted January 11, 2012 Posted January 11, 2012 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. Quote
Administrators Farshad Mohajeri Posted January 12, 2012 Administrators Posted January 12, 2012 You must change all PACKxyz15 to PACKxyz16. Quote
dynamo Posted January 18, 2012 Posted January 18, 2012 Thanks Farshad, You are exactly right.I effected already necessary arrangements and enclosed you will find the Delphi XE2 compatible uniXDBGrid. uniXDBGrid-v.1.0.1.rar Quote
karazeh2006 Posted February 24, 2012 Posted February 24, 2012 Thanks for a great job of a great programmer Quote
IRWANTO82 Posted August 25, 2012 Posted August 25, 2012 any body could implement group band title in grid like TSMDBGrid component ??? Quote
AlbertoVesx Posted December 16, 2012 Posted December 16, 2012 Post #1 updated to v2.0 Oh, great. Thank you. Quote
wangxuebin Posted January 25, 2013 Posted January 25, 2013 I cant't download it! is it still there? Quote
Skepsis IT Posted May 26, 2013 Posted May 26, 2013 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 Quote
Jose Abanto Posted July 19, 2013 Posted July 19, 2013 The unixdbgrid sorted data only in actual page, so I used the "onColumnSort" event to ordered all records. But I found a problem when I deleted a record (when this data is sorted). Test this case please. Quote
Skepsis IT Posted July 19, 2013 Posted July 19, 2013 Please would someone send me a link or something for downloading unixdbgrid? Quote
Skepsis IT Posted July 23, 2013 Posted July 23, 2013 The link was on post 1 is not working! I download has v1.0.1. if someone has v2 please send it to me. Thanks anyway Quote
Skepsis IT Posted July 27, 2013 Posted July 27, 2013 The link was on post 1 is not working! I download has v1.0.1. if someone has v2 please send it to me. Thanks anyway Quote
fikret Posted July 29, 2013 Posted July 29, 2013 The link was on post 1 is not working! I download has v1.0.1. if someone has v2 please send it to me. Thanks anyway +1 Quote
Skepsis IT Posted August 9, 2013 Posted August 9, 2013 Hi everybody, link for v2 at post 1 still not working. Nobody from the unigui community has it for share with us? Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.