Solved

Tquery paradox sql

Posted on 1997-11-02
3
404 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

696 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