Welcome! Log In Create A New Profile

Advanced

Queries not showing when creating table

Posted by Petr 
Queries not showing when creating table
November 04, 2022 07:29PM
Hello,

I created new small testing project and for the first time I use HFSQL classic.

I created some simple queries as I always do. They show in "Stored queries" in Analysis (see picture) and they can be run. Problem si that NO query is showing in "Describing a table control" - Source, in combo Browsed file:. In this combo I can see only files.

Also in code when I start to type QRY_... it shows my queries and autofill, I also can continue and when I type dot at the end of QRY_People., it shows all the query fields. But when I run code, it gives me an error that QRY is not accessible and when I look at code it is in red color.

Any idea what is going on please? Some parameter I need to set up somewhere?

Thanks

Petr
Attachments:
open | download - No queries showing when creating table.jpg (45.4 KB)
open | download - QRY_Dochazka gets red.jpg (27.6 KB)
pao
Re: Queries not showing when creating table
November 04, 2022 10:07PM
As far as i know Stored queries can only be used if the DB is HF/CS.
For HFSQL classic you have to create the queries in the project, you can't create them in the analisys.

Regards

Paulo Oliveira
Re: Queries not showing when creating table
November 04, 2022 10:42PM
Thank you Paulo!

I was sure it must be something simple stupid.

Have a nice day

Petr
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: