User Security isn’t new; everyone is use to logging into the applications they use. To help developers build cross platform applications faster, InterBase has a flexible API for user security that simplifies the access to data held in InterBase regardless if your application is deployed to Windows, Mac, Linux, iOS and Android.
User Security in InterBase helps control WHO gets to see WHAT and is enhanced with a strong encryption model (which I covered in the Rising to the Data Security Challenge webinar) so lets focus on the foundations of user security in this article.
One very cool tip in the video is to use constraints to add in a unique key, this way you can drop it easily at runtime. Remember, the field needs to be marketed NOT NULL to enable a primary or unique key.
ALTER TABLE CUSTOMER ADD CONSTRAINT U_TEST UNIQUE (CUSTOMER_NAME);
The above example names the constraint U_TEST. (you can put whatever value you want in to name it, making it easy to drop with the following statement.
There are a number of classes that help along the way but there are two specific categories of classes and that is what I want to cover in this post.
LiveBindings and List v Link
Sometimes you want to fill a list with values; sometimes you want to keep a list of values updated; this is in essence the difference between using List (e.g. TBindList, TBindGridList) and Link (e.g. TBindListLink, TBindGridLink)
TBindList will fill a list with values, if the data/objects linked to changes then the data will not update unless you manually tell the list to re-populate using the bindings FillLists property.
TBindListLink however will keep the list in sync.
Before you continue… look at the samples
I recommend playing with the “OneOfEach” sample in the samples directory.
{samples}\LiveBindings\oneofeach\vcl
Try changing the fish name in the TBindGridLink and seeing how it updates over the other tabs where the FishFacts data is used.
What is a Binding Source and how is it different to the Control?
Pawel Glowacki and I will be hosting a webinar on 10th and repeated on the 16th December titled ” Become a Developer Super Hero with the RAD Solution Pack!”
Hundreds of senior executives gathered at the iconic Wembley Stadium to see the winners named. An incredible C-Level audience represented the communications industry from across the globe, with representatives from every continent attended.
The awards, (one for which InterBase was a finalist), were sponsored by leading players from the Telco industry, including ADVA, AsiaInfo, CITIC Telecom CPC, IDT Telecom, PCCW Global, Tata Communications, TeliaSonera International Carrier and Vodafone.
Left to right: Adam Oliver, (CEO, Institute of Telecom Professionals); Marc Brunel-Walker, (Director of International Marketing, Embarcadero), Stephen Ball (InterBase Product Manager – Embarcadero), Scott Mills (Radio 1 DJ and host)
As you can see from the photo above, InterBase beat off the competition to win “most innovative use of data” in part thanks to the patent pending technology “Change Views” that we developed and brought to market back in December 2014 with InterBase XE7.
InterBase, the home of Change Views.
Change Views is dramatically changing the way data is moved to and from mobile and the edge of IoT by allowing developers to easily identify delta’s; By retrieving only the deltas, it enables network traffic and cost to be slashed, ensuring a much richer end user experience. Additionally the enhanced granular encryption and role based security model offered by InterBase enables true enterprise data best practice to exist everywhere through the development life cycle.
There was no chance on the night to do a speech and offer our thanks so I’ve decided to decant it here. Firstly I want to thank all the InterBase users out there for your loyal support and amazing stories you share with us. This go a long way to helping InterBase win such amazing awards.
I want to thank Jason Vokes, John Thomas, Marco Cantú, James Pitts and Michael Swindell for their support and guidance when we initially dreamt up Change Views and needed a plan to bring it from development through to market. Marc Brunel-Walker for helping with the award submission. Dmitry Arefiev for his amazing FireDAC integration helping developers get to the technology faster, and similarly Jeff Overcash for IBX; My wife Charlotte for all her amazing support; But most importantly today to my InterBase team, especially Charlie Caro and Sriram Balasubramanian, with whom I spent 3 long, but fun days in 2014 planning and discussing use cases and scenarios as we set off to give birth to this amazing technology.
Finally a big thank you to Rob Chambers and his team at Total Telecom for a wonderful memorable evening; It is by far the best awards event I have been to in my 4 years at Embarcadero, and I hope we get the chance to attend (and hopefully win another award) next year.
Having explored how to link to a Master Detail relationship and created a funky anonymous method to return the data, I thought there is no reason why I should have to be returning linked data. The data could be from anywhere.
One example people have asked about when I’ve been at developer events is how to link an object to be the master for filtering a TDataSet… well, this actually provides a simple example for doing exactly this (as you can see in this video)
In the last blog we looked at how to use master detail and how the BeforeScroll and AfterScoll events worked. I also created using Generics a Sync Object that allowed a single detail object to be linked to.
As promised, this blog post takes it a step further, using the previous foundation I have updated the code (so make sure you download the latest version from code central from the link below) to allow multiple objects of different types to be linked. Additionally, detail lists are also now available.
InterBase XE7 update 5 is now available for general release. The patch/update kits are for server-based Editions of InterBase XE7 only on Windows and Linux for both 32bit and 64bit
For notes on previous InterBase XE7 updates please select the links below
Embarcadero CodeCentral “Registered Users” can download the patch binaries (Server/Desktop/Developer/Trial) for Windows and Linux, and, ToGo Edition. You can find the downloads at http://cc.embarcadero.com/reg/interbase
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.AcceptRead More
Privacy & Cookies Policy
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
