General information
Category:
Coding, syntax & commands
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only