Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor manipulation questions;
Message
From
23/08/1999 12:27:47
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00256590
Message ID:
00256643
Views:
27
>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?

Remove the 'junk' and see if that works.
Previous
Reply
Map
View

Click here to load this message in the networking platform