MS Access front-end & Y/N datatype

[ayjaycee]

In an Access database, you can define a column as Y/N (i.e. binary 0 or 1).

If you are using Access as a front-end to an Oracle database, what datatype would you use to get the same functionality?

Or is this not possible?

Thanks,
TandA

http://www.tanda.f2s.com

One by one, the penguins steal my sanity.

 

[THoey]

Actually, I believe Access uses -1 for true/yes and 0 for false/no. Either way, I would use a Number and go from there. Terry M. Hoey

 

[ayjaycee]

Thanks - will try that (when the developer gets in tomorrow morning). TandA

http://www.tanda.f2s.com

One by one, the penguins steal my sanity.

 

[ayjaycee]

Update:

Tried NUM(1) - no good.

Tried CHAR(3) - worked!

Looked at the data - the field has a "0" in it, so I'm confused as to why the NUM(1) didn't work.

Oh well, as long as it's working ... TandA

http://www.tanda.f2s.com

One by one, the penguins steal my sanity.