USING SQLEDITOR UPDATE

USING SQLEDITOR UPDATE

Select the Quote Field Names check box if your server requires quotation marks around field names.Īfter you specify a table, select key columns, and select update columns, click Generate SQL to generate the preliminary SQL statements to associate with the update component's ModifySQL, InsertSQL, and DeleteSQL properties. Click Dataset Defaults to return the selection lists to the original state: all fields selected as keys and all selected for update. Instead of setting Key Fields you can click the Primary Keys button to choose key fields for the update based on the table's primary index. For Paradox, dBASE, and FoxPro the columns you specify here must correspond to an existing index, but this is not a requirement for remote SQL databases. The Key Fields list box is used to specify the columns to use as keys during the update. When you first specify a table, all columns in the Update Fields list box are selected for inclusion. The Update Fields list box indicates which columns should be updated. When you specify a table name, the Key Fields and Update Fields list boxes are populated with available columns. Use the Table Name combo box to select the table to update. The Options page is visible when you first invoke the editor. The editor creates SQL statements for the update object's ModifySQL, InsertSQL, and DeleteSQL properties based on the underlying data set and on the values you supply to it. Right-click the update object and select UpdateSQL Editor from the context menu.This step ensures that the Update SQL editor you invoke in the next step can determine suitable default values to use for SQL generation options. Using the Object Inspector, select the name of the update object from the drop-down list for the dataset's UpdateObject property.To create the SQL statements for an update component Consider migrating your existing database applications from BDE to dbExpress. You should not undertake new development with BDE. For instance, BDE will never have Unicode support. Note: The Borland Database Engine (BDE) has been deprecated, so it will not be enhanced.

Using sqleditor