> Try using 1 and 0 instead of S - N

I doubt they want to change their database. That isn't necessary.

You need to set a ColumnAttribute setting to tell how the boolean column
should work:

MYCOL=BOOLEAN=S,N

Look in the query design-time editor and there is a tab for all of these,
boolean included.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com