Related Record Count Syntax Please

[Chuck Pelto]

Hi Ruslan,

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

Regards,

Chuck

On Dec 22, 2004, at 10:45 AM, Ruslan Zasukhin wrote:

> On 12/22/04 7:35 PM, "Chuck Pelto" <cbpelto at pcisys.net> wrote:
>
>> Hi Ruslan,
>>
>> Err = 616
>
> 616 -- wrong expression.
>
> Asume you get query as:
>
>   tQuery = "SELECT * FROM Person, Task WHERE mPersonPtr = 5"
>
> Do you really have field with name mPersonPtr ?
> May be it is PersonPtr ?
>
>
>> Where can I find the meaning of these error numbers? They are not in
>> the V4RB Reference material.
>
> ValentinaKernel.pdf
>
> -- 
> 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
>