Information générale
Catégorie:
Codage, syntaxe et commandes
Here's what I tried.... Is it what you mean?
SELECT students.student_id, students.fname, students.lname,;
students.YEAR, students.hm_address, students.hm_city, students.hm_state,;
students.hm_zip, students.hm_zip5_4, students.hm_phone,;
orders.hm_address, orders.hm_city, orders.hm_state, orders.hm_zip,;
-> orders.hm_zip5_4, orders.hm_phone ,.T.;
FROM students INNER JOIN orders ;
ON students.student_id = orders.student_id;
WHERE orders.hm_address > ' ';
AND students.hm_address = ' ';
ORDER BY students.student_id;
INTO CURSOR junk nofilter
USE (dbf('junk')) AGAIN IN 0 ALIAS c_addr
USE
When I ran it, it added a field 'Expr_17' to the cursor, containing 'T'. Still got the 'Invalid path or filename' message on the USE(dbf... instruction.
>Did you add the .T. to the end of your file list?
Précédent
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