SQL Help

[Deane Venske]

That sounds great :) I can't wait for version 2. If you need Beta testers,
I'm all game. One of our products needs to be done within the next 3 weeks
but after that we have till the end of the year to complete another, so I
could implement version 2 into that one.

Regards,
Deane

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net]On Behalf Of Ruslan
Zasukhin
Sent: Thursday, July 24, 2003 3:02 PM
To: valentina at lists.macserve.net
Subject: Re: SQL Help


on 7/24/03 7:50, Deane Venske at dean at eduss.com wrote:

Hi Deane,

> I'd like to do a little more in my SQL statements than I am currently
able.
> Using other RDBMS I've been able to do a query like this :
> UPDATE class SET name = "Class " & classID
>
> This would do the following
> BEFORE QUERY
>
> `class` Table
> +----------+----------+
> | classID  | Name     |
> +----------+----------+
> | 1        |          |
> | 2        |          |
> | 3        |          |
> | 4        |          |
> +----------+----------+
>
> AFTER QUERY
>
> `class` Table
> +----------+----------+
> | classID  | Name     |
> +----------+----------+
> | 1        | Class 1  |
> | 2        | Class 2  |
> | 3        | Class 3  |
> | 4        | Class 4  |
> +----------+----------+
>
> Can this be done in Valentina? I've tried doing
> `UPDATE class SET name = concat("Class " & classID)`
> As well as other variations. Can't get concat to work in updates even if
> joinging two strings.

In the 1.x this not works.
Will work in 2.0.

I am not sure, you can try to use BaseObject method here.
Make 3d field -- BaseObject method with
    formula = "concat('Class ', classID)"

May be it will work.

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

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina