Is it possible to add more than one column to a table
with a single command a la:
ALTER TABLE Ord_det ADD COLUMN `S_city` TEXT 20, +
COLUMN `B01Date` DATE, +
COLUMN `Binttest` INTEGER
OR
ALTER TABLE Ord_det ADD `S_city` TEXT 20, +
`B01Date` DATE, +
`Binttest` INTEGER
or whatever the correct syntax is. I get an "Invalid
column constraint" error no matter what syntax I use in
an attempt to add multiple columns with just one command.
Single ALTER commands for adding one column at a time
function perfectly well.
Suggestions?
TIA, Bernie
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [EMAIL PROTECTED]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
