UpdateSQL control

xiaoxiao2021-04-05  253

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

转载请注明原文地址:https://www.9cbs.com/read-132170.html

New Post(0)