Query

Hello to all.

I use Embedded Query or Query and link it on table or entry fields.
If I need to link this query to data file to modify database when query is modified, I need option "hModifyFile" and I need to execute query 2 times to enable modification of file when query is modified.

1st execution is when table is initialized
2nd is when I execute query hExecuteQuery(Query1, hModifyFile)

The is no option, or I don't know Query1..ModifyFIle = True (or similar way)

Tahnk you.

Hi Ismir,

Just get rid of the embedded query and use a normal one. (use "save as" on the embedded query)
Then you have full control over the execution mode of the query and you won't have to execute it twice.
I always execute the query in the initialization code of the table.

Kind regards,
Piet

Pozz

Ja koristim HExecuteSQLQuery i sve završavam u jednom kodu