I have a strange issue, I have a number of tables linked to an informix
database. The queries have been working just fine for quite a while, but
suddenly, all queries that use RTrim (or LTrim or Trim for that matter)
return #ERROR for whichever field is using RTrim.

Even stranger, is that if I create a new database and link the same
tables, it works just fine. This is a simple case that shows the error

SELECT xcal_patdemo.patid, RTrim([xcal_patdemo]![lname]) AS Expr1
FROM xcal_patdemo
WHERE (((xcal_patdemo.patid)="108264"));

Works just fine in my test database, but not in my real one.
If I leave out RTrim, it works (but is padded, of course).

It seems like RTrim is somehow "missing" or been overridden somehow.

Any suggestions?

Thanks,

Mark

Mark,

Generally, this means that one of your references has gone bad. did
you move the db from one PC to another? if the new PC does not have
exactly the same .dlls, it may not be able to find the new ones.
usually, it will find newer versions, but i don't think it will ever
find older versions. upgrading other software or applying MS patches
can also cause this. (Welcome to DLL Hell. anyone looking forward to
having VB.NET in Access?)

in the VBE (Alt + F11 from the db container) select Tools menu, then
References. chances are you will find MISSING next to one of the
first few items in the list. find one with a very similar name and
check it. exit the references pop-up and everthing should be fine.

Good luck. tom

Mark Roach <mrroach (AT) okmaybe (DOT) com> wrote