Valentina SQL Question

[Ruslan Zasukhin]

On 9/19/06 4:04 AM, "Dave Miller" <dwmiller at umich.edu> wrote:

Hi Dave,

> Hello Ruslan,
> 
> Can you give me the SQL syntax for Valentina 1.x (we've purchased 2.0
> but don't have it fully integrated yet) for the following?
> 
> I want to select values from two columns from a single table whose
> contents are not equal. They're both strings.
> 
> These both give me errors:
> 
> SELECT style, masterstyle FROM PseudoStylesTable WHERE style != masterstyle
> SELECT style, masterstyle FROM PseudoStylesTable WHERE style <> masterstyle

1.x cannot make this directly.

You need create Table Method then use it in query.

    m3 of boolean type with formula  "style != masterstyle"

Later in query

    WHERE m3 = true

 
> This works fine:
> 
> SELECT style, masterstyle FROM PseudoStylesTable
> 
> -- [[#style: "11085", #masterstyle: "11085"], [#style: "11086",
> #masterstyle: "11086"], [#style: "11087", #masterstyle: "11087"],
> [#style: "11088", #masterstyle: "11088"], [#style: "401051",
> #masterstyle: "401051"], [#style: "401057", #masterstyle: "401057"],
> [#style: "401059", #masterstyle: "401059"], [#style: "421049",
> #masterstyle: "421049"], [#style: "421088", #masterstyle: "421088"],
> [#style: "421093", #masterstyle: "421093"], [#style: "421094",
> #masterstyle: "421094"], [#style: "441072", #masterstyle: "441072"],
> [#style: "451102", #masterstyle: "451102"], [#style: "451102FT",
> #masterstyle: "451102"], [#style: "451102OEU", #masterstyle: "451102"]]

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]