[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


make a date field in interbase

Posted on 2002-04-26
Medium Priority
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
Question by:girlswants_me
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

Author Comment

ID: 6970680
help me please
LVL 27

Expert Comment

ID: 6970684
create table xyz
  (name CHAR(30), /*or varchar*/
   bday DATE,
   money CURRENCY, /*not sure about type*/
   age INTEGER,
  PRIMARY KEY (name,bday))

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

meikl ;-)

Author Comment

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?
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

LVL 27

Accepted Solution

kretzschmar earned 200 total points
ID: 6970712
you could use a tquery,
supply it into the sql-property,
and use the execsql-method

Expert Comment

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

Author Comment

ID: 6974490
Thank you very much

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
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…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Suggested Courses

649 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