Related Record Count Syntax Please

[Chuck Pelto]

Sounds interesting. When is this due out? And when for Realbasic?

But back to the original question....

[1] It sounds like I have to delve into SQL, for the time being, to get 
the count of related records.

The follow-on question is....

How do I retrieve data from fields of a child data file? Specifically, 
I'm working on Valentina Tutorial #3; modifying it. I have added a 
ListBox to the RB Window 1 that shows the data from  the Task data file 
that relate to the parent record.

The first part was to determine the count of related records, which 
must, apparently, be done using SQL. The next part is to extract the 
related record data to be displayed in the rows of the listbox.

Could I have an example of the syntax to accomplish this?

Regards,

Chuck

On Dec 18, 2004, at 2:27 PM, Ruslan Zasukhin wrote:

> On 12/18/04 11:18 PM, "Peter De Berdt" <peter.de.berdt at pandora.be> 
> wrote:
>
>>> Hi Peter,
>>>
>>> Is there any way to do this WITHOUT going to an SQL search?
>>>
>>> There IS the call for RecordCount in the reference manual. Is there a
>>> way to use BaseObject pointers and achieve this?
>>>
>> A RecordCount is ALWAYS a property of a cursor. In fact, when you ask
>> for the RecordCount of a BaseObject, it's as if you would do a "SELECT
>> * FROM Table". Why do you want to avoid querying the database?
>
> To warm interest to 2.0 more.
>
> In Valentina 2.0 we open to V4RB and V4MD developers
> a new unique API to be able do all work with no SQL.
>
> In other words
>
>     now C++, V4RB and V4MD developers, using v2.0
>     can do ANY database task without SQL at all.
>
> Of course if you not use SQL then you do not get access to its feature 
> as
> Join, GROUP BY. But C++ developers will be able do even join without 
> SQL :-)
> May be future we will open this API to V4RB and V4MD also.
>
>
> We do this not because we do not like SQL.
> Of course no. Just Valentina now give you 2 complete ways to resolve 
> tasks.
> Choose any you like...or even mix them.
>
>
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>