Email us at firstname.lastname@example.org or call +1 (818) 844-3383 between 7:30AM and 4:30PM Pacific Time.
Developer Express Inc is proud to announce the immediate availability of its newest release, DevExpress v18.1. Built and optimized for desktop, web, and mobile developers alike...
With 31 categories and over 500 products to choose from, DevExpress is honored to have been voted best in class 19 times in this year's Visual Studio Magazine Reader's Choice Awards...
I am not sure if i am meant to comment here or make a new support ticket.
According to the 'whats new' on the recent beta build 12.2.1 editing on server mode should now be possible.
I realise this is a beta but wanted to let you know that i tried it and it doesn't work here yet(again, i'm not sure if this is already fully functional since it is a beta version)
I did spot the new properties on the servermodeView level, set them all to true but i can't edit any of the data, also the connected cxNavigator shows the delete and insert buttons as disabled.
Should this be fully functional in the 12.2.1 beta?
Make certain that the following requirements are met:
- You are using a table-based server mode data source - either TdxServerModeADODataSource or TdxServerModeDBXDataSource;
- The data source is connected to a table rather than a view.
Hi Alex, thanks for your response.
You are right, if i use a TdxServerModeDBXDataSource it works, i was using the new TdxServerModeDBXQueryDataSource assuming editing would be possible on both.
Will this be possible with the TdxServerModeDBXQueryDataSource in the final version of 12.2.1?
To my regret, no. As with the standard TSQLQuery component, TdxServerModeDBXQueryDataSource does not provide built-in editing capabilities.
Okay thanks for your response, good to know.
I think many people will be dissapointed not having built in editing with the new query component; not a big problem for me because i don't actually want to use the editing but just wanted to insert and delete buttons in the navigator enabled and perform the actions myself from code when they are clicked but i already made a workaround for that with custombuttons in the navigator.
It's good to hear you have found a workaround. We'll discuss with our developers what can be done to address the limitation. Clearly, there has to be a way (like events) to execute custom SQL statements in response to grid record operations.
With VCL 12.2, you can allow your end-users to add or remove records in server mode as well as edit records in-place when binding to data in server mode. These capabilities are available only in table-based server mode data sources (TdxServerModeADODataSource and TdxServerModeDBXDataSource) connected to database tables. You can set the data source's ReadOnly property to False to disable these capabilities in a linked server mode View.