>alter table dockets add OwnInvFlag short
the problem seems to be the choice of datatype "short"
for example
alter table dockets add OwnInvFlag integer
works just fine.
I have no idea why this should be so. I've tried just about
every synonym for short too and none seem to work.
(int16, shortint, shortinteger, integer16, uint16 ??)
>If I DO get this working - can I put this statement into the lines of a
TQuery and execute it? or does TQuery >only support DML statements?
yes - there may be glitches depending on which version of
BDE you have but in general you can create tables, delete tables
add and drop indexes, create fields etc. Not sure about
relational integrity and constraints or whatever they're called
in paradox but the basics works fine.
rgds
ns
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
