Solved

Tquery paradox sql

Posted on 1997-11-02
3
402 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
0
Comment
Question by:asi
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
julio011597 earned 50 total points
ID: 1349314
 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
 

Author Comment

by:asi
ID: 1349315
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
 
LVL 5

Expert Comment

by:julio011597
ID: 1349316
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question