asi
asked on
Tquery paradox sql
hi
1)where can i find a real good and comprehensive Doc about the exeact avaleble command in sql/paradox in delphi
2) does sombody know how can i add a record to Tquery (after i execute the Tquery )
i tried to do it using append but its rais me an error "dataset is read-only"
10x in advance
asi
10x
asi
1)where can i find a real good and comprehensive Doc about the exeact avaleble command in sql/paradox in delphi
2) does sombody know how can i add a record to Tquery (after i execute the Tquery )
i tried to do it using append but its rais me an error "dataset is read-only"
10x in advance
asi
10x
asi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ok, would you mind posting here your query statement?
This could make me able to tell what exactely is the problem.
BTW, here are the syntax requirements:
--//--
Restrictions on live queries
Single table queries or views are updateable provided that:
There are no JOINs, UNIONs, INTERSECTs, or MINUS operations.
There is no DISTINCT key word in the SELECT.
There are no aggregate operations.
The table referenced in the FROM clause is either an updateable base table or an updateable view.
There is no GROUP BY or HAVING clause.
There are no subqueries.
Any ORDER BY clause can be satisfied with an index.
--//--
-julio
This could make me able to tell what exactely is the problem.
BTW, here are the syntax requirements:
--//--
Restrictions on live queries
Single table queries or views are updateable provided that:
There are no JOINs, UNIONs, INTERSECTs, or MINUS operations.
There is no DISTINCT key word in the SELECT.
There are no aggregate operations.
The table referenced in the FROM clause is either an updateable base table or an updateable view.
There is no GROUP BY or HAVING clause.
There are no subqueries.
Any ORDER BY clause can be satisfied with an index.
--//--
-julio
ASKER
10x 4 the answer but stile i have problem ...
you wrote "query statement meets some syntax requirements; in the Delphi Help look for 'TQuery', and follow for 'Requesting a live result set'"
i dont understand how to do it ,
to be more specific - i execute and Tquery , now i have a dataset that i want to add a record using (for example) the Tquery append command (not the sql append command )
even if i set the RequestLive to True i recive a read only Error message;
if u can deliver me an answer & example its would be great !
10x any way
asi