• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

Add a logical field in a Paradox Table

How can I add a logical field to a Paradox table using a SQL sentence
0
rao_tito
Asked:
rao_tito
  • 2
1 Solution
 
LukA_YJKCommented:
ALTER TABLE "OldData.db" ADD "NewField" CHAR(10)

See ALTER TABLE in Local SQL Guide. Good luck...
0
 
LukA_YJKCommented:
It shoud be
ALTER TABLE "OldData.db" ADD "NewField" BOOLEAN
for logical field, of course ;)
0
 
CleanupPingCommented:
rao_tito:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
kacorretiredCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:
       to accept LukA_YJK's answer
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Merry Christmas and happy new year!

kacor
EE Cleanup Volunteer
0

Featured Post

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!

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