Tableschema

[Mr. Bart Pietercil]

Hi Ruslan,

On 5-nov-07, at 14:59, Ruslan Zasukhin wrote:

> On 5/11/07 3:02 PM, "Mr. Bart Pietercil" <bart.pietercil at gmail.com>  
> wrote:
>
> Hi Bart,
>
>> I'm having trouble finding the correct way to read a database schema.
>>
>> I thought there was a call aDB.tableschema that would return an array
>> of tablenames,
>> but I only found tablecount which I use to traverse the schema.
>
> Well, this is RBDB API.
> Can glitch.
>
>> 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 ?

TIA

Bart