Solved

make a date field in interbase

Posted on 2002-04-26
6
124 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
  • 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
ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
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…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

803 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