Article #22940: Can you drag and drop existing SQL structures directly onto a form?

Question:  What is the easiest way to implement SQL Tables, Sequences, Procedures, etc. that have already been created, into the Data Access components?

Answer:  By dragging and dropping pre-created SQL structures onto Builder/Delphi forms.

Once the structures have been created, they may be accessible from within the components themselves.  To do this, right-click on your Data Access Component and choose "Explore."  This will open the SQL Explorer.

Next, navigate and open the database alias you are working with.  You should be presented with a list of whatever structure groups are currently available.  Within these are the structures themselves.  Find the specific structure you would like to implement and drag it over to your Builder/Delphi form and drop it.  A component will be created and its properties filled in with the applicable data.  This is much easier than typing in the properties by hand, and is an efficient way to eliminate implementation errors that could occur.

Last Modified: 24-AUG-00