ODBC / SQL

BackupUser · Post by **BackupUser** » Mon Feb 25, 2002 1:37 pm

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

BackupUser · Post by **BackupUser** » Mon Feb 25, 2002 3:06 pm

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) )