problems with dbaccess

I have a little question related with dbaccess. When I try to do some things with dbaccess, like alter table (for example), I put add a new row, it asks for a name for the row, and then asks for the row type. The problem is that I get something like this: Char Numeric Serial Date Money date-Time ... I would like to add a BOOLEAN type column, and I don't now how to select it, because I don't see it. I had this problem befor with dbaccess, and resolved it guessing, but didn't have that luck this time. And besides, The terminal in which I'm working has plenty of space to the right, so why does it cut with the three points (...)? Thanks!! -- "And I'm happy, because you make me feel good, about me." - Melvin Udall ----------------------------------------------------------------- Mart'n Marqu's email: martin@math.unl.edu.ar Santa Fe - Argentina http://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -----------------------------------------------------------------

On Sat, 1 Jul 2000 17:17:59 -0300, "Martin A. Marques" <martin@math.unl.edu.ar> wrote: > >I have a little question related with dbaccess. >When I try to do some things with dbaccess, like alter table (for example), I >put add a new row, it asks for a name for the row, and then asks for the row >type. The problem is that I get something like this: > > Char Numeric Serial Date Money date-Time ... > >I would like to add a BOOLEAN type column, and I don't now how to select it, >because I don't see it. I had this problem befor with dbaccess, and resolved >it guessing, but didn't have that luck this time. Besides Obnoxio's perfectly valid answer, if you couldn't figure it out w/the dbaccess menus, then you could have just used SQL (look in the SQL syntax manual for 'alter table') in the Query window. Cheers, Douglas Wilson

The BOOLEAN type is like a NUMERIC --> SMALLINT, you can us like a boolean 0-> false <>0 -> true (normaly 1). You can't see all the menu, the three points are normal. "Martin A. Marques" wrote: > I have a little question related with dbaccess. > When I try to do some things with dbaccess, like alter table (for example), I > put add a new row, it asks for a name for the row, and then asks for the row > type. The problem is that I get something like this: > > Char Numeric Serial Date Money date-Time ... > > I would like to add a BOOLEAN type column, and I don't now how to select it, > because I don't see it. I had this problem befor with dbaccess, and resolved > it guessing, but didn't have that luck this time. And besides, The terminal > in which I'm working has plenty of space to the right, so why does it cut > with the three points (...)? > > Thanks!! > > -- > "And I'm happy, because you make me feel good, about me." - Melvin Udall > ----------------------------------------------------------------- > Martín Marqués email: martin@math.unl.edu.ar > Santa Fe - Argentina http://math.unl.edu.ar/~martin/ > Administrador de sistemas en math.unl.edu.ar > ----------------------------------------------------------------- -- ------------------------------------------------------------------------ Gabinet Informàtic i Consultors Departament de Programació Josep M. Martí

Hi try WinSQL at http://www.indus-soft.com/winsql. It is 10 times better than DBAccess "Martin A. Marques" wrote: > I have a little question related with dbaccess. > When I try to do some things with dbaccess, like alter table (for example), I > put add a new row, it asks for a name for the row, and then asks for the row > type. The problem is that I get something like this: > > Char Numeric Serial Date Money date-Time ... > > I would like to add a BOOLEAN type column, and I don't now how to select it, > because I don't see it. I had this problem befor with dbaccess, and resolved > it guessing, but didn't have that luck this time. And besides, The terminal > in which I'm working has plenty of space to the right, so why does it cut > with the three points (...)? > > Thanks!! > > -- > "And I'm happy, because you make me feel good, about me." - Melvin Udall > ----------------------------------------------------------------- > Martín Marqués email: martin@math.unl.edu.ar > Santa Fe - Argentina http://math.unl.edu.ar/~martin/ > Administrador de sistemas en math.unl.edu.ar > ----------------------------------------------------------------- -- ===================================================================== Imran Hussain imranh@imranweb.com For FREE Software visit http://www.imranweb.com/freesoft =====================================================================