Information générale
Catégorie:
Codage, syntaxe et commandes
Hi,
In VFP 5.0, I am running SELECT statement from 2 tables. I have join condition, filter condition and 3 'IN' subquery. I am running it inside the form. Those 2 tables are **opened** before SELCT, but **not selected**. The first time I execute SELECT it brings NO ROWS ??? If I execute the same SELECT again just after the first one, it brings expected 2 records. It also brings 2 records, if I select one of the source tables before executing SELECT.
Does anybody have a clue?
Here is my SELECT:
SELECT field_name, field_type, field_len, field_dec, field_null, ;
field_nocp, field_defa, field_rule, field_err, ;
table_rule, table_err, table_name, ;
ins_trig, upd_trig, del_trig, table_cmt ;
FROM de_definition d, de_master ms ;
WHERE d.de_id = ms.de_id and ms.de_id = tnDe_id and ;
(field_name in ;
(SELECT table_id1 from de_master WHERE de_id = tnDe_id) or ;
field_name in ;
(SELECT table_id2 from de_master WHERE de_id = tnDe_id) or ;
field_name in ;
(SELECT table_id3 from de_master WHERE de_id = tnDe_id)) ;
ORDER BY order
I am appreciate any explanation. Thanks. Galina
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement