Member since: Thursday, 18 June 2015
Last login: 3 months ago
Profile viewed: 750 views

Your Rank: 92
Points: 2

Vanners created a new topic ' FireDAC CachedUpdates enforce primary key' in the forum. 1 year ago

How can I set up a TFDQuery with cached updates so that it will enforce primary key constraints when posting.
It complains well enough when ApplyUpdates is attempted (which may be after many records are changed), but it would be sooo much better if it complained when a duplicate key was attempted to be inserted it could stop problems like this from arising.

It seems like FireDAC works for synthetic keys, but natural keys seem to have problem after problem. (try cached master detail tables with central caching where you can change the primary key of the master - it gets rid of changes to the detail table for all records that belong to the changed master)


I need the YouTube link too!

The link to does not show any recent activity, the latest being 2014. There is a "Mind your language" replay, but that is for Delphi XE6, not this most recent version.

Vanners posted a comment on Delphi Boot Camp with 100% off Delphi 2 years ago

I want that too!

Vanners posted a comment on Delphi Boot Camp with 100% off Delphi 2 years ago

When my children downloaded and installed Delphi they only had the Win32 platform. I understand there will be Firemonkey in this boot camp. How are they supposed to follow along without the other platforms?

Is there a video recording of these webinars? I missed the first few, and even missed the last 20 minutes of this one.

Vanners created a new topic ' Unblocking Tethering' in the forum. 3 years ago

I installed an application with WiFi tethering to a laptop. Multiple mobile devices have a companion app. All PCs are on the same network and on the same subnet (10.0.0.#).

My development laptop can connect to the mobile devices without problems, however the other laptop doesn't detect any other device when trying to connect. It is running the same app that is being run on my development laptop.

What could be causing it not to see any devices? (obviously it isn't a coding issue, otherwise my development machine would have the same problem) so it must be something to do with the environment of the other laptop.

1. A DLL or other supporting code is needed that has not been transferred
2. Some virus protection/firewall is causing it to be blocked (note: the first time I ran the app it asked me if I wanted to let it through the regular Windows 7 firewall. I said yes.) This laptop also has another virus protection programme on it (I think it is Norton's).

I have also tested this code on another windows 7 PC and it worked fine.

App was compiled in XE8, but started development in XE7.