Hi,
I dont know if I can ask you a delphi question directly, but I am really despirate and need to get this program off the ground. I use Delphi6 and the database is on an AS400 server. I use the Tadoconnection and Tadoquery components.
All the queries work fine, except where the file name is of the following type: x.xxxx for example:
" select * from qs36f.lede03 " works fine.
" select * from qs36f.m.lede01 " does not work at all. qs36f is the library and m.lede01 is the table.
How can I get this to work? When I go to Delphi's database explorer I can see all the data. I just dont know how to query the table.
I can copy the data file (table) and rename it to omit the "." but copying and naming it mlede01 will waste space.
Regards,
Johan Nieuwoudt
DB2 & UDB email list listserv db2-l LazyDBA home page