Solved

make a date field in interbase

Posted on 2002-04-26
6
126 Views
Last Modified: 2010-04-04
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
Comment
Question by:girlswants_me
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 

Author Comment

by:girlswants_me
ID: 6970680
help me please
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6970684
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
 

Author Comment

by:girlswants_me
ID: 6970708
where am i going to input that?
am i going to insert in the sql component?
where? and how can i execute that?
0
Industry Leaders: 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!

 
LVL 27

Accepted Solution

by:
kretzschmar earned 50 total points
ID: 6970712
you could use a tquery,
supply it into the sql-property,
and use the execsql-method
0
 
LVL 8

Expert Comment

by:TOndrej
ID: 6970723
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
 

Author Comment

by:girlswants_me
ID: 6974490
Thank you very much
0

Featured Post

Technology Partners: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question