SELECT non-fields...

[Ruslan Zasukhin]

on 5/22/03 7:58 AM, michael geary at listmail at gearyweb.com wrote:

Hi Michael,

> one of the great diagnostics that I use with MySQL is selecting
> expressions. For example:
> 
> SELECT table.field, 1=2, "literal", table.field = 3
> FROM table
> 
> ---------
> 
> This would return, for example
> 
> --------------------------------------------
> 1   |  false  |  'literal'  | false
> 2   |  false  |  'literal'  | false
> 3   |  false  |  'literal'  | true
> ...
> 
> However, it appears that I can't do this with Valentina. I can only
> select fields. I suppose this sort of thing may be possible with
> MethodObjects, but it would be really great to by able to use MySQL
> syntax. It's a pain to have to set up a new Method just to test
> something...

Yes in current version of Valentina this not works.
It will in 2.0.

You can now get the same functionality using BaseObject methods.

And note, this is NOT mySQL syntax.
This is Standard SQL syntax.

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