Tableschema

[Ruslan Zasukhin]

On 5/11/07 4:19 PM, "Mr. Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

>>> Problem is that this code also seems to find sys tables (it found
>>> sysItems).
>>> 
>>> So what is the way to read the schema of a DB (prefer classway) from
>>> within RB ?
>> 
>> 1) API way
>> 
>>     count = db.TableCount
>>     loop
>>        tbl = db.Table(i)
>> 
>> 2) SQL
>> 
>>     SHOW TABLES
>> 
>> 
>> Yes we return sys tables also, you need add own filter to check
>> flag of
>> Vtable.IsSytem.
>> 
> Can't find anything about isSystem in Wiki and Realbasic. Could you
> point me to docs ?

Really V4RB API do not have such properties for VTable.

Okay, then SQL is the only way I think.

-- 
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]