Using method in SQL statement

[Ruslan Zasukhin]

on 11/19/03 7:32 AM, Tim James at tjames1 at bigpond.net.au wrote:

> Then I think there may be a bug in 1.9.8 as
> 
> the method is defined as  baseobject method (sorry I should have said
> can I refer to a baseobject method in an sql statement)
> 
> and when I
> 
> "select margin from stock" (in visql and my app)
> 
> 
> it lists the correct values
> 
> but when I
> 
> "select margin from stock where margin > 25"
> 
> I get empty cursor and no error in my app and nil records in visql
> (and 90% of values are above 25)

No bug here, this is exactly, Tim.

Try trash and rebuild indexes.


---------
You can also use VAPP to check values of your BaseObject method.
If they really show > 25 ?

Open db in VAPP, go to record browser, choose in menu show methods.

Although you say viSQL show correct values..
Strange.

Try rebuild indexes first of all


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