Information

Z SQL Methods must be associated with a database connection object present in the context of the current folder. To find the list of accessible database connection objects, Z SQL Methods use the function SQLConnectionIDs().

The Transparent Folders concept is acquisition in reverse. So, when you add a database connection object into a Transparent Folder, it should be accessible from the container and from all the containers added into this container.

Actually, the function SQLConnectionIDs() doesn't find database connection objects contained into transparent folders. To make it works, you must apply this patch for the file in which this function is defined.

Installation

Linux

• Copy the SQL.py.patch file into the folder lib/python/Products/ZSQLMethods/ of your Zope.
• patch -p0 < SQL.py.patch
• Restart your Zope

Windows

• Edit the SQL.py file locate into the folder lib/python/Products/ZSQLMethods/ of your Zope.
• Edit the SQL.py.patch file.
• Add the lines begining with a + in the patch, at the right place in the SQL.py file...
• Restart your Zope.