UpdateSQL This control will know when I just learned Delphi, but I didn't go straight. I didn't find an example. I just need to use this today.
I have a control, one, it's really easy to use, huh, huh, let's talk about it.
UpdateSQL This control is originally used to update different tables. When Query has opened multiple tables, but you can't use query to update directly.
The table is operational, because it is a plurality of tables, here is using UpdateSQL control, pointing Query's Updatobject points to one
UpdateSQL, and this query's cacheupdates is True, I tried to try with false, and the data cannot be entered in dbgrid.
I only opened a table here, I started trying to set the RequestLive to True, but Open, prompt CAN not Find Object.
What is the meaning of the Internet search, but did not find the answer, foreign sites mentioned this question, is Nchar, or NVARCHAR in the SQL database.
Data type, but I am not used, I don't know why, I think of Updatesql, I haven't used it, I will try it first, set the property, Open
No prompt, good, change the data and applyupdates, error, because there is no modifysql, but how to write this modifysql
? Check the online help
Specifies The SQL Update Statement To Use When Applying An Update To A Record and Cached Updates IS
Enabled.
Property Modifysql: Tstrings;
Description
Set modifysql to the SQL Update Statement to Use when Applying An Updated Record to a DataSet.
Statements Can Be Parameterized queries. To create a Update Statement At Design Time, Use Time
UpdateSQL Editor To create Statements, Such as:
Update "country.db"
Set name =: Name, Capital =: Capital, Continent =: Continent
Where name =: Old_name
AT Run Time, An Application CAN Write a Statement Directly to this property to set or change
Update stat.
Note: as The Example Illustrates, Modifysql Supports An Extension To Normal Parameter Binding. T
Retrieve the value of a field as it exissrs prior to application of cached updates, the field name
WITH "OLD_?" this is especially useful when the where clause of the Where clause of the the WHEN CLAUSE OF THE
STATEMENT. Although I don't understand, I also understand that when I update the table, use the field =: field but condition is what WHERE should be written?
It said in the name of the OLD_ field name, according to it, Applyupdates, no mistake, then open the database to see, oh, the data is updated
Here, I know how to use Updatesql.
Note that
If you write the SQL statement, you can't use it when you're: name, sex =: sex, you must remove the space, do not appear Field '' IS OF
AN UNKNOWN TYPE prompt, I don't know why it doesn't have it to remove these spaces