Best practise with opening Tables in a thread

[Graham Wickens]

At the moment I use <TABLE>.OPEN(tableName,FILE_RW_SHARED)

before I open the WHILE .. END for the Thread and put the <TABLE>.CLOSE() after the WHILE .. END was exited.

I also tried <TABLE>.OPEN(tablename,FILE_RW_SHARED)
each time I want to search for a key value, then <TABLE>.CLOSE() after completion of search. This time I put that inside the WHILE .. END.

Both seemed to work, although of course the <TABLE>.OPEN before the loop worked faster as one would expect.
What is the best method to use considering that I would in all probability want to access the lookup table to input updates and additions etc, while the thread is running?

[Marcel Kollenaar]

Re: Best practise with opening Tables in a thread

I would open the tables outside the thread and pass the name_space on parameter 3 of the thread create function. Inside the thread you use the name_space pointer and do the stuff you want to do.

I answered likewise in your other thread.

[Graham Wickens]

Re: Best practise with opening Tables in a thread

Thanks Marcel,

if I DIM all variables before

Thread_create("name",<<%code%
   do something
%code%,NS)

does that mean I refer to all variables with prefix NS?

i.e. tbl = table.open("Logging",FILE_RW_SHARED)
dim Incr as n = 1
I would refer to them as
ns.tbl.fetch_first()
and
ns.incr
??

Later @ 13:00

Tried the thread out using the variable NS as a pointer to my local.variables() all seemed to work, but it came to the same result:(

Sun Jan 21 13:07:03 2007

Thread: TestMonitorArrayThread
Script: TEMPLATE
Line: 14
ns.rec = ns.tblalias.fetch_find(ns.VarArray[5])
Conflicting expression data types
Execution Stack:
0#14 ns.rec = ns.tblalias.fetch_find(ns.VarArray[5])

[Graham Wickens]

Re: Best practise with opening Tables in a thread

all replies to the

"Invalid Table Handle" in background Thread

[Marcel Kollenaar]

Re: Best practise with opening Tables in a thread

Try

rec = ns.tblalias.fetch_find(val(ns.VarArray[5]))
.............................^.................^

[Graham Wickens]

Re: Best practise with opening Tables in a thread

VarArray[5] is always a character field as I have checked this through.
so the message must be misleading me somehow!

[Marcel Kollenaar]

Re: Best practise with opening Tables in a thread

VarArray[5] is always a character field as I have checked this through.
so the message must be misleading me somehow!

No I was wrong! I saw later that this statement was correct.