V4RB - TableCount counts temp tables as well

[Ruslan Zasukhin]

On 12/3/07 11:33 AM, "Erne" <ernestogiannotta at tiscalinet.it> wrote:

Hi Erne,
 
> I found that the DB.TableCount() counts also the internal temp tables
> like "_jointable1" etc...
> 
> is this correct behaviour?

Hmm. Not good.
 
> I mean, developer should know nothing about the internals of
> implementation and thus shouldn't care to deal with these (from his
> point of view alien) tables

Right.

Please report it to mantis
 
> Maybe for those who care could be added a new function like
> DB.TrueTableCount() and let TableCount return only the count of those
> created by the developer...
> 
> ...mmm but I see a gotcha here
> 
> What if developer creates some temp tables himself?

Developers's TMP table must be counted of course.
    this is normal table.
    Just it is not stored into sys tables.

> These of course should be counted by TableCount() function but then
> trying to access them via DB.Table(idx) could interfere with some
> internally created temp table and thus return the wrong object

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]