SQL Help

[Ruslan Zasukhin]

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