V4WS 1.11 - what is syntax for querying related tables?

[Ruslan Zasukhin]

On 15/8/07 1:58 PM, "Steven Ronald" <stevenrt39 at yahoo.com.au> wrote:

Hi Steve,

> I haven't had to query related tables until now, and I
> can't figure out the correct executable syntax for
> doing so from the documentation.
> 
> I have a table:
> 
> dbRef_usdb=valMakeNewDatabase("usdb");
> boRef_foo=valMakeNewBaseObject( dbRef_usdb, "foo" );
> fldRef=valMakeNewField( boRef_foo, "uscoo", "ULLong");
> valSetFlagOfField( fldRef, 1, true );
> valSetFlagOfField( fldRef, 2, true );
> valMakeNewField( boRef_foo, "S", "ULong");
> valMakeNewField( boRef_foo, "comm", "Double");
> valMakeNewField( boRef_foo, "timestamp", "datetime");
> valMakeNewField( boRef_foo, "triggerflag", "Boolean");
> 
> I then add a number of records to it, two of which
> have triggerflag=1 (the rest have triggerflag=0)
> 
> I make another table in the same database:
> 
> boRef_trigger=valMakeNewBaseObject( dbRef_usdb,
> "trigger" );
> fldRef=valMakeNewField( boRef_trigger, "us_Ptr",
> "ObjectPtr");

I do not see here that this ObjectPtr is assigned
to point to table "foo"

?

> valMakeNewField( boRef_trigger, "payment_owed",
> "Double");

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