problem with mailmerge ! PLEASE HELP ME!!

[Thomas Reppel]

Hello,

I am using the doa components together with the OfficePartner components (from turbopower) to create an address mailing.
The fields "house-number" contains number and sometimes letters (like "10a") I am using the TOracleDataSet component to create the dataset. [Select * from address]
the fieldtype is varchar(20).

The problem is, that all in all addresses, where the "house-no" is not numeric, that field is blanc.

It cannot be a problem with the Officepartner components, because with Interbase and the BDE they work fine.

Any ideas ?

Thanks for your help.

Thomas

 

[jpickup]

I have difficulty believing that this could be a DOA problem.

As a quick test, create your OracleDataSet and attached a TDataSource and a TDBGrid.

This should immediately tell you if the problem is somewhere within DOA, Oracle or Net8. If this works then the problem is somewhere in your application logic...

 

[Thomas Reppel]

hmmm,

of course, this works. But why do I not have any problems with Interbase ?
In my opinion, there must be a problem in recognizing the datatype of the result set.
In the meantime, I found out, that if rowcount is 1, then there is no problem. Onle if more than 1 records are given back to the app, this error occurs.

Any ideas ?

Thanks,

Thomas