Creating a table from SQL prompt?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a table on the fly but I don't know the field types. I
know how to do "create table test (name Text(10),length_1 number,paid
datetime)" I got errors when I tried to use "AutoNumber" and when I put a
size on "number(1,2)"
 
I am trying to set up a table on the fly but I don't know the field types. I
know how to do "create table test (name Text(10),length_1 number,paid
datetime)" I got errors when I tried to use "AutoNumber" and when I put a
size on "number(1,2)"
Click to expand...

try COUNTER
 
Sorry, number is a wage with 2 decimals number(5,2)
Click to expand...

I am a little confused:
do you have Access installed? if yes go to the help system and look
for: Microsoft Jet SQL reference, in Overview you have the comparision
of different Data Types and the Data Types from Access.

if you don't have it , tell me, I will post the two pages

I gues you are looking for currency: (Money) has 4 decimals

PS: I am working right now on a German system and I don't think this
help file will be much help for you
 
Back
Top