File is not open ???

[DaveL]

Why am I getting a "File is not open" error? The following code inserts 1 record into the dave_test table but when it hits the endscan command, it gives me the error. I am trying to get it to loop through cursor4???

Thanks!

use next_nbr in 2
use dave_test1 in 3
select * from cursor4
scan
SELECT ctr_id from next_nbr 
			m.ctr_id = next_nbr.ctr_id
			REPLACE next_nbr.ctr_id WITH next_nbr.ctr_id + 1

insert into dave_test1(name, dctr_id) ;
values (cursor4.name, m.ctr_id)  
endscan

 

[ramani]

use next_nbr in 2
use dave_test1 in 3
SELECT 2
LOCATE && explicitly locating the record
select * from cursor4

SCAN
m.ctr_id = next_nbr.ctr_id
REPLACE next_nbr.ctr_id WITH next_nbr.ctr_id + 1
INSERT INTO dave_test1(name, dctr_id) ;
VALUES (name, m.ctr_id)
ENDSCAN
================================================
The above shall work for you.

When you write cursor4.name... your assumption cursor4 created by SQL is named cursor4 is wrong. You cannot assume anything with SQL. If you need it specificaly, then you shall create the SQL .. SELECT * from CURSOR4 into DBF myDbf etc etc...
Then use myDBF and select it.

ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com

 

[jimstarr]

Hi Dave,

You don't need to say "select * from cursor4" in order to be able to loop thru cursor4. Rather:

SELECT cursor4
SCAN
...

Also "SELECT ctr_id from next_nbr" is unnecessary. The field "ctr_id" is already available since next_nbr is open.

Jim

 

[DaveL]

Got it! Thank you for the help!