<div>
<div class="content wysiwyg-content">
Playing off of:<br />
<a href="https://www.experts-exchange.com/questions/21484253/Help-with-ado.html" rel="ugc">https://www.experts-exchange.com/questions/21484253/Help-with-ado.html</a><br />
<br />
If I'm using ADO, how would I add/modify/delete records from a recordset creating using a Join?<br />
<br />
Not looking too much for specifics at the moment...just general ideas/commands. &nbsp;I've always use Select statements and then assigned the fields with the text control's data...presumably I would use INSERT and DELETE commands?<br />
<br />
If so, in addition, I want to cover all the bases so that if an add is initiated, the user has the option to cancel the add - an undo for an edit, etc...are these ado commands that I can apply? &nbsp;Any links with tips for these procedcures?
</div>
</div>


Playing off of:
http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_21484253.html

If I'm using ADO, how would I add/modify/delete records from a recordset creating using a Join?

Not looking too much for specifics at the moment...just general ideas/commands.  I've always use Select statements and then assigned the fields with the text control's data...presumably I would use INSERT and DELETE commands?

If so, in addition, I want to cover all the bases so that if an add is initiated, the user has the option to cancel the add - an undo for an edit, etc...are these ado commands that I can apply?  Any links with tips for these procedcures?

ADO Continuation

Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.

Delphi

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.