Sql

[Bert de Nooij]

Hi Mikael,

Does this help you out?



sql declare CURSOR_FILE cursor for               &
select * from FILE 

screen TEST         activities FIND

cursor CURSOR_FILE primary                       &
       OPEN READ OCCURS 10 CACHE 255

cluster occurs with CURSOR_FILE 
align (,,4)
field FIELD1 of CURSOR_FILE 
Cluster


Regards,

Bert


Bert de Nooij
Arma bv
Einsteinbaan 4
3439 NJ Nieuwegein
mailto:Bert.DN@Arma.com
http://www.arma.com



-----Oorspronkelijk bericht-----
Van: owner-powerh-l@sphere.swau.edu
[mailto:owner-powerh-l@sphere.swau.edu]Namens Mikael A Olesen
Verzonden: woensdag 16 augustus 2000 14:21
Aan: powerh-l@sphere.swau.edu
Onderwerp: Sql


Hi

I guess this is simple but...!
I need to declare a cursor for a primary file that shall occurs 10 times. I
have tried but have problems with the syntax!

Could someone give me a hand on this one.

Regards

Mikael



= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.