Subject normalization and placeholder
Author checkmail


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


Best regards