Brian Evans replied to Mark Williams's topic in Databases
Null parameters and COALESCE () in the UDPATE statement would be one way.
SQL.Text :='UPDATE persons SET name=COALESCE(:NAME,name), email=COALESCE(:EMAIL,email) WHERE id=:ID';
The ICS components are event driven, so have various state variables for control, they will need careful manipulation if opening a connection is skipped. Basically, test, fix, repeat.
Angus
You beat me to it, Roger!
I agree. @Ian Branch Please make topic titles reasonably descriptive of the contents
F.x.
Is it just me?? -> D12 Formatting issues
Ummmm. What!! -> D12 Form event disappared!
I have issued a request to install the patch for All Users to fix these inconveniencies (it is a simple setting in the GetIt configuration). I hope someone will take care of that. Otherwise I have to wait for the new QP to get online.
Not being a MVP anymore, it is the first time in years that I do not have access to a recent version Delphi.
But I will have a solution for you. Please give me a couple of days.