RequestLive gives "Table does not exist"

Steinar Overbeck Cook

Delphi Developer

Wed, 29 Apr 1998 03:00:00 GMT

RequestLive gives "Table does not exist"

I have tiny program created by the Delphi Database Form Expert. It works
fine as long as the TQuery.RequestLive is set to False.

As soon as i change the RequestLive to TRUE, it fals over and gives me
the message "Table does not exist"

Does anyone have any ideas, please ?

--
Steinar Overbeck Cook

Donald R. Odd

Delphi Developer

Fri, 01 May 1998 03:00:00 GMT

Re:RequestLive gives "Table does not exist"

In article <482dvs$...@oslo-nntp.eunet.no>
stei...@balder.no "Steinar Overbeck Cook" writes:

Quote

>I have tiny program created by the Delphi Database Form Expert. It works
>fine as long as the TQuery.RequestLive is set to False.

>As soon as i change the RequestLive to TRUE, it fals over and gives me
>the message "Table does not exist"

>Does anyone have any ideas, please ?

The TQuery.RequestLive allows you to edit records which can only
be done with some queries see page 120 of the Database Application
Developers Guide for details of which ones. This message indicates
that no table exists for editing.

--
Donald Oddy
Grove Systems Ltd. 0161-224 4465

Shawn K. Clar

Delphi Developer

Sun, 03 May 1998 03:00:00 GMT

Re:RequestLive gives "Table does not exist"

REMEMBER:

You can only do REQUESTLIVE when the query only accesses 1 table!!
And, that table must be indexed.

"Donald R. Oddy" <don...@grove.demon.co.uk> wrote:

Quote

>In article <482dvs$...@oslo-nntp.eunet.no>
> stei...@balder.no "Steinar Overbeck Cook" writes:

>>I have tiny program created by the Delphi Database Form Expert. It works
>>fine as long as the TQuery.RequestLive is set to False.

>>As soon as i change the RequestLive to TRUE, it fals over and gives me
>>the message "Table does not exist"

>>Does anyone have any ideas, please ?

>The TQuery.RequestLive allows you to edit records which can only
>be done with some queries see page 120 of the Database Application
>Developers Guide for details of which ones. This message indicates
>that no table exists for editing.

>--
>Donald Oddy
>Grove Systems Ltd. 0161-224 4465

Shawn K. Clar

Delphi Developer

Sun, 03 May 1998 03:00:00 GMT

Re:RequestLive gives "Table does not exist"

You can only do a requestlive on a query that uses 1 table!
And that table must be indexed!

Delphi tries to open the table that you used in your SQL statement
to do updates and such. But it can't do it if you use more than one
table!

Other Threads

1. Accelerator Key gives "Dataset not in edit or insert mode", click does not

2. HELP : "Invalid Paramater", when doing Tquery.Open, seems to not release resources

3. Error: "Property MaxLineAction does not exist"

4. Error "Index Does Not Exist"

5. Property "XXX" Does not exist

6. The keys "-"/"+"/"*"

7. Requestlive and the "in" sql command

8. "Lookup table not found or corrupt"??!??

9. Problem doing "diagnose connection"

10. "Index not currently active" or "Table is not indexed"...