>>One example is that we have bar generation queries (N minute intervals). The
>>bar generation logic is complex and depends on numerous domain rules and
>>filter conditions. These rules are defined in xml format and carries a name.
>>While making >>queries, user can specify to generate bar data on a table and
>>also specify which rule files to be used (one or more).
>>>As you see I cannot achieve this through standard SQL statement unless I
>>>port all the logic to SQL which is also not possible when multiple rule
>>>files are involved. There are so many things that my application does but I
>>>cannot represent them in >>standard SQL. I want to pass these rules as
>>>"HINT"s to my application without breaking the SQL syntax.
>>Hope this helps.
You can store config info in db not in xml – what problem?
You can do import xml into db
Read xml by udf, client software and more ...
I have one implementation where i read file by udf(especially xml, ini files
from some external storage) and read xml as blob and on client side decide what
to do
i have also simple import feature xml into db as tree structure with attributes
– very simple..
implementations should be simplest as possible
regards,
Karol Bieniaszeski
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
