Subject Re: [firebird-support] Constants
Author Adomas Urbanavicius
Well, both things are good, though both requires dublication of
constants (app and db side), what leads into possible human mistake of
different contant value in app and in db.
Adomas
Martijn Tonies wrote:

>>>A configuration table is the only thing you can do.
>>>
>>>
>>You might also write a stored procedure that takes the constant name as
>>a string input parameter and gives a specified output for each known
>>constant name.
>>
>>
>
>Yep.
>
>
>
>>And what's wrong with the UDF?
>>
>>
>
>Replacing it when adding a new constant can be annoying - you have
>to restart the server for that.
>
>With regards,
>
>Martijn Tonies
>Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
>Server
>Upscene Productions
>http://www.upscene.com
>Database development questions? Check the forum!
>http://www.databasedevelopmentforum.com
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>