Information générale
Catégorie:
Codage, syntaxe et commandes
>
> 1 USE students IN 0 ORDER student_id
> 2 USE orders IN 0 ORDER student_id
>
> 3 DO NoHomeAddress
> 4 DO cursorprep
> 5 DO merge
>
>..... code continues....
>
> 6 PROCEDURE NoHomeAddress
> * locate empty address fields in students table where data exists in orders table.
>
> 7 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;
> 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 Temp nofilter
> 8 USE temp AGAIN IN 0 ALIAS c_Addresses
> 8A *USE (dbf()) AGAIN IN 0 ALIAS c_Addresses
> Lines 8 or 8A - I'm trying to convert the read-only cursor from the SELECT statement to an updatable cursor so I can eliminate records with bad address info. When using line 8, sometimes I will get 'File not found' errors. If I use lin 8A, it returns 'Invalid path or filename'. In addition, the cursor c_Addresses does not contain all the fields from the cursor Temp. What is really strange is that at one time or another, both of these forms have worked in the past on this routine.
>
I'll try problem 8A. Add a ,.T. at the end of your field list. Even with a NOFILTER, I believe you can still get a filtered 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