[Button Color]

I tried to find an answer in the forum, but I wasn't lucky.

The question is simple: how can I change the color of a single button ? I don't see a "Color" or similar property like on standard delphi buttons.

Thanks in advance

[Grid summary on the paging bar]

Thanks! It seems to work.

 

[Grid summary on the paging bar]

From here, thanks

[Grid summary on the paging bar]

I would like to put the summaries values on the left of the paging arrows

 

 

[Grid summary on the paging bar]

Is it possible to show the summary values in the paging bar ?

[UniDBGrid numeric column editor disable arrow keys]

Is it possible ? The default beaviour is to increase/decrease the value.

[Import spreadsheet information from excel]

I also tried to use the smimport component, but I always get an exception when executing the execute method.

Did you used any special option ?

[DBGrid Clientside Sorting]

On 1/20/2016 at 6:19 PM, mhmda said:

Hi,

 

As default behavior of dbgrid is performing sorting in server side, but sometimes you fetch all data into grid (no paging) and the data is already in client, so why return to server to sort data !!

 

Do the sort in client side:

 

1. Disable remoteSort (store):

 

 

 

 

2. Set 'click' event on column header and do sorting:

 

 

 

Hope this will help you :-)

 

It works, but it doesn't handle toggling between ascending/descending. How can it be done ?

[Post on column exit]

Is it possible to post after exiting a unidbgridcolumn ?

[Post on exit]

Could it be done also with a dbgrid cell ? I tried but in the onexit event the dataset is "dsInactive"

[Checkbox column with null value]

I've mapped on a checkbox unidbgrid column an integer field with 0/1 values, that could also have a null value to be evaluted as a unchecked.

How can I configure it ? Actually I get a "can't convert (null) to Olestr" when the row is posted.

[DBGrid with DBLookupcombo with keyfield<>listfield]

But in this example keyfield is equal to listfield

[DBGrid with DBLookupcombo with keyfield<>listfield]

Is there any example of how to use a DBLookupcombo where the key field is differente from the list field ?

I tried but after editing I see the key field value in the grid instead of the list field value.

[DBGrid cell "copiable" but not editable]

It works! Thanks.

[DBGrid cell "copiable" but not editable]

Is it possible to make a cell "copiable", i.e. the cell content selectable and copiable in the clipboard, keeping it readonly ?

[Sorting DBGrid]

I've tried to find something in the forum and in the documentation, but I didn't found the answer: how can I make work the sorting of the columns ? If I click on one sortable column I get the grid refreshed but the sorting is not applied.

[Skip to the next line in a unidbgrid...]

Hi,

 

Then try:

function reconfigure(sender, store, columns, oldStore, the, eOpts) {
    var grid = sender;
    for (var i = 0; i < columns.length; i++) {
        if (columns[i].getEditor()) {
            columns[i].getEditor().on('specialkey', function(field, e) {
                if (e.getKey() == 13) {
                    var store = grid.getStore();
                    var selModel = grid.getSelectionModel();
                    var selectedRecord = selModel.getLastSelected();
                    var recordIndex = store.indexOf(selectedRecord);
                    var nextRecord = store.getAt(recordIndex + 1);
                    if (nextRecord) {
                        selModel.select(nextRecord);
                    }
                }
            })
        }
    }
}

Best regards.

 

 

Where this javascript have to be put ?

[Going down one row using the down arrow key]

Is it possible in an editable dbgrid to change the current edited field with the one in the same column one row under? Now the user have to press the tab button cycling through all the fields until it reaches the same field in the next row.

[Post on exit]

It works. Thanks.

[Post on exit]

I would like to obtain the same effect of pressing the "post" button on a dbtoolbar when the user exists from a dbmemo.

[Post on exit]

Is it possible to force to posting of the updates to the db on exiting of a TUniDBMemo field using professional editon ?

[DBLookupCombox editor in dbgrid]

I was not able to found an example for a very common case like this:

- DataSet1 is an invoice list with a CUSTOMER_ID field

- DataSet2 is the curstomer list with an ID field and a DESCRIPTION field

 

I would like to have a dbgrid to edit DataSet1, where the CUSTOMER_ID column is displayed with the DESCRIPTION field looked up from dataset2, and the editor is a dblookupcombobox  showing the descriptions from DataSet2 but saving the ID in the CUSTOMER_ID field.

 

Could anyone point me to the right direction ?

[Adding buttons to dbgrid pager footer]

Is it possible ? I've seen other web applications doing it like in the attachment

 

 

[Changing theme doesn't work]

found the problem: the RecallLastTheme flag was set to false. setting it to true made it works.

[Changing theme doesn't work]

yes