Solved

Tquery paradox sql

Posted on 1997-11-02
3
401 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

785 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