|Subject||normalization and placeholder|
currently I save a path to a picture like this in my database: “s:\20150201101005_1\r0001.tif“ – firebird 2.5
But this path I can compose from the other informations. First I have a timestamp 2015-02…,, _1 is the line where it is created, 1 is the picture Number.
Now I would create a config Table with which I can set the Path dynamically. If there a change, I can create a new configuration an set it to the picture.
But how could I save this configuration? “S:\” || :TimestampVar || “_” || :linevar ,,, Is there only possible with an sql statement (set the String in a procedure and execute statement..) How can I realize this? There are more options?
Thanks in advance