[eyal282]

Format(sQuery, sizeof(sQuery), "UPDATE %s SET value = value + %s WHERE AuthId = \"%s\"", Name, Value, AuthId);

Given that the variable Value is a string and the column ( or row whatever it's called ) value is also a string, and given that the strings are nothing but numbers and floats, would sqlite allow such computing to occur or an error will be thrown?

The reason I don't want to create an integer is because I wanna make something easier to perform ( Trying to do something like clientprefs but for values that aren't preferences ) which will be convinient and the value is always a string.

[Ilusion9]

Originally Posted by eyal282 Format(sQuery, sizeof(sQuery), "UPDATE %s SET value = value + %s WHERE AuthId = \"%s\"", Name, Value, AuthId); Given that the variable Value is a string and the column ( or row whatever it's called ) value is also a string, and given that the strings are nothing but numbers and floats, would sqlite allow such computing to occur or an error will be thrown? The reason I don't want to create an integer is because I wanna make something easier to perform ( Trying to do something like clientprefs but for values that aren't preferences ) which will be convinient and the value is always a string.

value must be an int column to do column = column + value (or view as int that column in your plugin) and use '%s' with database escape for strings.

[mug1wara]

It works, but.

value = value + new value, \

Adds the existing value to the new value.

I belive this is what you want:

value = value + SPACE(1) + %s


@Ilusion9

You're incorrect, it's called string concatenation.

[eyal282]

Originally Posted by mug1wara It works, but. value = value + new value, \ Adds the existing value to the new value. I belive this is what you want: value = value + SPACE(1) + %s @Ilusion9 You're incorrect, it's called string concatenation.

Curiousity will this work with floats and integers combined? Like if combining two ints result is int and combining two floats result is float and combining one of each result is float?

Edit: it works perfectly without SPACE(1), but what does SPACE(1) do?

[mug1wara]

Adds a space

Let's say you have a column that has the existing value of "Hello", and you want to add "Goodbye".
If you then add them together, it'll be "HelloGoodbye".

It's just my ocd that makes me put SPACE(1)

[Ilusion9]

Originally Posted by mug1wara @Ilusion9 You're incorrect, it's called string concatenation.

I know what string concatenation is.

value = value + %s (string column) is not equal with value = value + %d (int column)

[eyal282]

Originally Posted by Ilusion9 I know what string concatenation is. value = value + %s (string column) is not equal with value = value + %d (int column)

But why does it work perfectly in my DB Browser? Will it break apart when tried in a sourcemod query?

[klippy]

According to SQLite spec, you can use the || operator to concatenate strings.