Hi

Thanks! Good questions.

1) I plan to be engaged in it if you consider it necessary.
With TIBODataSet all is simply enough.
Now it is possible to make such trick:

procedure TForm1.FormCreate(Sender: TObject);
var
da: TDataAlias;
begin
da := XLSQLRep1.DataAliases.Add;
da.Alias := 'IBO_ALIAS1';
da.DataSet := TIB_Query(IBOQuery1.InternalDataset);

da := XLSQLRep1.DataAliases.Add;
da.Alias := 'IBO_ALIAS2';
da.DataSet := TIB_Query(IBOQuery2.InternalDataset);

...
end;

But at global TDataSet support it is much more difficult.
I did not think yet over support of foreign data-sources.
Good Idea, undoubtedly.

2) I have tried:
select first 60000
ID, MYBLOB as blob1, MYBLOB as blob2, MYBLOB as blob3,
MYBLOB as blob4, MYBLOB as blob5, MYBLOB as blob6,
MYBLOB as blob7, MYBLOB as blob8, MYBLOB as blob9,
MYBLOB as blob10
from MYTABLE

Very huge sample! It was carried out long, but without failures.

I have found out the reason of your problem - error on transfer of a
long string (more than 900 symbols, approximately). Now I work at it.
Within the next few days I will make update of XLSQL Reports and XLSQL
Reports Scheduler.

3) I'll fix issue with LineFeeds-characters with BLOB. Thank you for
the bug-report. And I will make support of big plain text-BLOBs.

However Excel is not intended for work with the big texts in a cell.
The cell height is limited to 409.5.
And unfortunately, Excel cannot interpret RTF code.
(http://support.microsoft.com/default.aspx?kbid=213693)
I will think, how it can be resolved.

--
Best regards,
Ramil khabibr@...


Tuesday, April 8, 2008, 4:24:33 PM, you wrote:

> hi ramil,

> I did some tests with your XLSQLRep and I saw that there is a great
> potential in this 2tiny components. Great work - thank you
> Just a few questions

> 1.) In the TXLSQLRep DataAlias Property, are there plans to add any
> TDataSet Objects (like the TIBOQuery)

> 2.) Is there a limit with Memos? (BLOB SUB_TYPE 1 SEGMENT SIZE 80)
> - in selects which returns lot of data containing a blob Field the
> Error "OLE Error 800A03EC" occures
> .....hmmm, With some tests I found out that in my sample-database the
> Limit is around 1522
> select first 1523 textm
> from mytable
> where textm is not null

-->> an error occures "OLE Error 800A03EC" (but when the records are

> limited smaller 1523 it works) ...strange

> 3.) BTW blobs: I found nothing documented in your docu about blobs
> (especially with text containing)
> ....so may I ask if you have any plans to make some native support for
> as eg
> - convert some LineFeeds-characters in Plain-text-blobs "on the fly"
> by reporting?
> - bring RTF formated Text in Blobs, into excel sheet in a readably form?
> or are there still other existing ways to do this ?

> best regards and keep your great work