Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Cannot use negative values in row source of DataSet Manager
Sun, Dec 14 2014 8:04 PMPermanent Link

Douglas Lyman

This statement generates an error when previewed in the DataSet manager

select * from "BILLING" where "BALANCE" < {"BALANCE"=-10000}

This statement is file:

select * from "BILLING" where "BALANCE" < {"BALANCE"=10000}

The error is "ElevateDB Error #700 (Missing expression)".
Mon, Dec 15 2014 4:33 AMPermanent Link

Matthew Jones

Douglas Lyman wrote:

> This statement generates an error when previewed in the DataSet
> manager
>
> select * from "BILLING" where "BALANCE" < {"BALANCE"=-10000}
>
> This statement is file:
>
> select * from "BILLING" where "BALANCE" < {"BALANCE"=10000}
>
> The error is "ElevateDB Error #700 (Missing expression)".

I think you should send a proper bug report for that, it will be fixed
faster that way.


--

Matthew Jones
Tue, Dec 16 2014 7:51 AMPermanent Link

Uli Becker

Douglas,

> This statement generates an error when previewed in the DataSet manager

Did you try, if there is an error when loading the dataset using a
parameter with a negative value?

Uli
Tue, Dec 16 2014 3:08 PMPermanent Link

Douglas Lyman

Uli Becker wrote:

Douglas,

> This statement generates an error when previewed in the DataSet manager

Did you try, if there is an error when loading the dataset using a
parameter with a negative value?

Uli


Yes.  There is definitely an issue.  I will send in a bug report.  Just checking that I was not doing something obviously wrong.
Image