Zeoslib Portal

Hi there, I'm using TZQuery for a while, but I just noticed a wired thing. When using aggregate functions within sql query, TZQuery limmit the field size to 256. More exactly: Let's say that I have a field [Message] VARCHAR(1024) Now, if I use: SELECT RecordNr, Occured, Message FROM Events The recor...

Hi there, I was wondering if is possible to retrieve XML data from SQL Server 2005 by using FOR XML in the SELECT statement. I have successfully prepared the TZConnection using ado protocol and following connection string: [font=Courier New] provider=SQLXMLOLEDB.3.0;data provider=SQLOLEDB;Integrated...