Related Record Count Syntax Please

[Ruslan Zasukhin]

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