Page 1 of 1

Posted: Mon Feb 25, 2002 1:37 pm
by BackupUser
Restored from previous forum. Originally posted by Earlington.

Why can I only create tables with fields of type CHAR?

Using the database (SQL) functions, I can only creat tables with fields
of type CHAR.

This works: "CREATE TABLE mytable (NAME char(20))"
But this does not work: "CREATE TABLE mytable (NAME numeric(6,2))"

Thanks
Earlington

Posted: Mon Feb 25, 2002 3:06 pm
by BackupUser
Restored from previous forum. Originally posted by Paul.

Maybe do a little reading up on SQL commands.

I have no problem creating other types...
Create Table test (ID AutoIncrement, Numbers Long, Names Text(50) )