id want the MS-SQL dialect to add the "dbo" in its own visit_function () code when it generates the SQL. this would require the dialect knows an MS-SQL builtin from a user-defined.
the reason we dont do it in the "func" itself is because the SQL constructs themselves remain database-agnostic at all times (so that SQL constructs and mappers can work for a DynamicMetaData that touches different kinds of DBs, for example). On Feb 16, 2007, at 1:21 PM, Rick Morrison wrote: > > I want to write a function for each of the databases our product > supports and call them in the same way for all databases. This > works with most databases, but MS-SQL Server does something > different and forces the function to be called with an "owner" > specifier, so what would be simply > > myfunc() > > in most DB engines must be instead > > dbo.myfunc() > > In MSSQL. > > Is there any way to tell the the SA "func" function to use such a > prefix for MSSQL and not for other database engines? Note that > this is for user-defined functions only, MSSQL "built-in" functions > can be called without the prefix. > > Thanks, > Rick > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---