[V4RB] SQL dramas again

[Ruslan Zasukhin]

on 4/22/03 6:48 PM, Pedro fp at lists at pedro.net.au wrote:

> G'day Folks
> 
> I'm trying to select records in the table qualityControl which has a
> Valentina link to the table GenXbase with all the fields I need being
> in qualityControl. So I tried the query ...
> SELECT RecID, * FROM qualityControl WHERE sequence_ptr = 145 ORDER BY
> line
> & got error ...
> 604 - Can't be updated
> then this query ...
> SELECT qualityControl.* FROM GenXbase, qualityControl WHERE
> GenXbase.RecID = 145 ORDER BY line
> got me error ...
> 640 - [no errString returned but the docs say it's a semantic error]
> finally this query ...
> SELECT GenXbase.RecID, qualityControl.* FROM GenXbase, qualityControl
> WHERE GenXbase.RecID = 145 ORDER BY line
> wnich didn't return an error :)
> 
> Would someone please explain why the first 2 don't work?

The first one do not works because ObjectPtr always must be used with RecID
field

    WHERE ptr = recid

At least this is how it works in current version.

You can wrap ObjectPtr field by BaseObject Method of Ulong type to do what
you need.

The second query, don't know right now.

-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------