We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Tquery paradox sql

asi
asi asked
on
Medium Priority
429 Views
Last Modified: 2008-02-26
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
Comment
Watch Question

 Hello,

1. look for the 'Local SQL Help' file in the Delphi/Help directory;

2. you can add records to a TQuery data set only if the TQuery.RequestLive property is True and your query statement meets some syntax requirements; in the Delphi Help look for 'TQuery', and follow for 'Requesting a live result set'.

HTH, julio

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
asi

Author

Commented:
hi
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

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
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.