Subject normalization and placeholder
Author checkmail

Hello,

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

 

Olaf