[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 132
  • Last Modified:

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
0
girlswants_me
Asked:
girlswants_me
  • 3
  • 2
1 Solution
 
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
 
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
kretzschmarCommented:
you could use a tquery,
supply it into the sql-property,
and use the execsql-method
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now