数据库为: Paradox.
数据控件为 Query1;
Query1.CachedUpdates := True;
Query1.RequestLive := True;
SQL文中有 order by; where条件。下句可有可无都没有影响:
Query1.UpdateObject := UpdateSQL1;
当我新增,删除的时候
Query1.post;这一句出错,说我不能修改只读Query1.请问那里有相关属性设置的文章。谢谢!
数据控件为 Query1;
Query1.CachedUpdates := True;
Query1.RequestLive := True;
SQL文中有 order by; where条件。下句可有可无都没有影响:
Query1.UpdateObject := UpdateSQL1;
当我新增,删除的时候
Query1.post;这一句出错,说我不能修改只读Query1.请问那里有相关属性设置的文章。谢谢!
Joins (inner, outer, or UNION)
Aggregate functions with or without GROUP BY or HAVING clauses
Base tables or views that are not updatable
Subqueries
ORDER BY clauses not based on an index
Queries against a remote database server are parsed by the server. If the RequestLive property is set to True, the SQL statement must abide by Local SQL standards in addition to any server-imposed restrictions because the BDE needs to use it for conveying data changes to the table. A live result set for a query against a single table or view is returned if the query does not contain any of the following:A DISTINCT clause in the SELECT statement
Aggregate functions, with or without GROUP BY or HAVING clauses
References to more than one base table or updatable views (joins)
Subqueries that reference the table in the FROM clause or other tablesIf an application requests and receives a live result set, the CanModify property of the query component is set to True. Even if the query returns a live result set, you may not be able to update the result set directly if it contains linked fields or you switch indexes before attempting an update. If these conditions exist, you should treat the result set as a read-only result set, and update it accordingly .If an application requests a live result set, but the SELECT statement syntax does not allow it, the BDE returns eitherA read-only result set for queries made against Paradox or dBASE.
An error code for SQL queries made against a remote server.
有问题请发信息到我的E-mail:[email protected]