make a date field in interbase

How can i create an interbase table, inside my interbase
database named "rasDATABASE"?

assigning fields like

"name" with string
"bday" with date
"Money" as currency
"age" as Integer
"anyreal" as Float

and making the "name" and "age" as index
girlswants_meAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
kretzschmarConnect With a Mentor Commented:
you could use a tquery,
supply it into the sql-property,
and use the execsql-method
0
 
girlswants_meAuthor Commented:
help me please
0
 
kretzschmarCommented:
create table xyz
  (name CHAR(30), /*or varchar*/
   bday DATE,
   money CURRENCY, /*not sure about type*/
   age INTEGER,
   anyreal DOUBLE PRECISSION,
  PRIMARY KEY (name,bday))


something like this,
its just from head,
so i'm not sure on correct syntax

meikl ;-)
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
girlswants_meAuthor Commented:
where am i going to input that?
am i going to insert in the sql component?
where? and how can i execute that?
0
 
TOndrejCommented:
You can also use IBConsole Interactive SQL, Delphi SQL Explorer or isql (command line).
Also have a look at Marathon: www.gimbal.com.au
0
 
girlswants_meAuthor Commented:
Thank you very much
0
All Courses

From novice to tech pro — start learning today.