Related Record Count Syntax Please

[Ruslan Zasukhin]

On 12/22/04 6:45 PM, "Chuck Pelto" <cbpelto at pcisys.net> wrote:

Hi Chuck,

> It's bad penny time, again....
> 
> For some reason, this code is not returning a valid cursor.
> 
>    tQuery = "SELECT * FROM Person, Task WHERE mPersonPtr = " +
> Str(currRecID)
>    tCursor = mDataBase.SQLSelect(tQuery)

    err = db.ErrorNumber

> I'm getting "nil" for tCursor, as the second line is executed. The
> currRecID is valid. The tCursor is dim'd as a VCursor at the top of the
> method and is a property in Window 1 as well.

Check error code after this

> The syntax of the SQL query looks valid to me. The tutorial app
> developed up to this point works fine.
> 
> What could be causing this malfunction?

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