[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 415
  • Last Modified:

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
0
asi
Asked:
asi
  • 2
1 Solution
 
julio011597Commented:
 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
0
 
asiAuthor 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

0
 
julio011597Commented:
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
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now