SQLquery - must it be in the same frame as the database?
lazarus / 16-Databases

----------------------------------------------------------------------
Nicole · 2022-08-23 11:11

IBX

In my frames I generate queries by topic.
Unfortunately I cannot set them to the database which is defined in my
db-modul.

Is it allowed to have a SQLquery to set the database within the
properties to a different unit?

----------------------------------------------------------------------
tonyw · 2022-08-23 11:54

Try adding the unitname of your data module to the uses clause of your
form. Then save the form and try again.

----------------------------------------------------------------------
MarkMLl · 2022-08-23 12:05

I don't see why. However, I think the basic rules of frames apply:

i) Set the properties of components when editing the frame.

ii) Do not set the properties of components in a frame from the form
editor.

iii) If you need properties with values other than (i) above, do it at
runtime after the form (hence the frame or frames it contains) has
been fully initialised.

MarkMLl

----------------------------------------------------------------------
Nicole · 2022-08-23 17:00

Thank you for the answers.

I have a working solution in my frame now, so it works as such.
A new Query did it.

The specific query refused to "see" the DB.
Nobody knows why, and we never will learn it, because I deleted it.