Related Record Count Syntax Please

[Chuck Pelto]

Resolved: The problem is that the field is known as person_ptr in 
Valentina. It is known as PersonPtr in REALbasic.

On Dec 22, 2004, at 3:25 PM, Ruslan Zasukhin wrote:

> On 12/22/04 9:10 PM, "Chuck Pelto" <cbpelto at pcisys.net> wrote:
>
> Hi Chuck,
>
>> There was a field named mPersonPtr. I've changed it to PersonPtr and
>> dropped the preceeding "m" from all the other fields in the boTask 
>> data
>> file. Modified the rest of the code in the TestApp to reflect the
>> change.
>>
>> Re-ran the application and TestAddRecords. Still getting the 616 
>> error.
>> Looking at the database with Valentina Carbon, I see the to BaseObject
>> files; Person and Task. Data seems fine. Relationship is properly
>> established, according to V-Carbon.
>
> I recommend you download Valentina Studio. Using it you can do the 
> same as
> in VAPP, plus you can simply execute SQL query.
>
> So please enter your query and see what Vstuio says.
> If also error, send me db files and query text.
>
>> I thought it could be the SQL query is poorly crafted? I've tried a
>> number of variations on that idea, but no joy.
>>
>> Therefore, it seems to be something to do with the call setting the
>> tCursor. I've tried a number of variations on the theme, to no avail.
>> Would it make a difference if the call, tCusor =
>> mDataBase.SQLSelect(Whatever), is looking for data in the child
>> database? mDataBase works for the parent file. Does looking the child
>> make any difference? I had tried removing the word "Person," from the
>> SQL search language, but again no luck.
>
> -- 
> 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
>