>Hi All
>
>I have this code, and I am in another procedure importing a text file which I do by reading the file and putting the data in these tables. But when I do a slect rac the program errors out because of no such alias. How can you open tables in your main startup procedure and be able to address the alias anywhere in the program??? Thanks for any help..
>
>John
>
>use races order tag raceid of races.cdx alias rac in 0
>use entries order tag raceidhrs of entries.cdx alias ent in 0
>use pplines order tag hrsname of pplines.cdx alias ppl in 0

John,
I think this is startup program. First one opens in workarea 1. Your call probably has something like:
use myTable
w/o a preceding select 0. Workarea still being 1 it would then close rac and open myTable there.
Cetin