IN working?

[Ruslan Zasukhin]

on 10/6/03 4:49 PM, Ken Ray at kray at sonsothunder.com wrote:

Hi Ken,

> I'm testing out the IN and NOT IN predicates for VXCMD and it doesn't
> appear as it's working (or my understanding is faulty). I've got a table
> called "CalendarSetMembers" that has a field called "EntityLink" which
> is an objectPtr to my Entities table. From my interface, the user can
> select a bunch of individual records from the CalendarSetMembers table,
> and I want to put them all into a cursor. My code ends up creating the
> SELECT statement below:
> 
> SELECT * FROM CalendarSetMembers WHERE EntityLink IN
> ('1696','2259','2345','7641')
> 
> and this returns a WrongExpression SQL error. I tried it without the
> quotes and I get the same result.
> 
> Is it me, or is it a bug?

Just in case try this query from viSQL.

EntityLink is ObjectPtr ?
So it of course must not be in quotes!

May be glitch with ObjectPtr.
Try the same query on some long field.

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