Hi people,
I?m trying to alter a integer field to a decimal(12,4) field in MSACCESS 2K.
Example:
table : item_nota_fiscal_forn_setor_publico
field : qtd_mercadoria integer NOT NULL
ALTER TABLE item_nota_fiscal_forn_setor_publico
ALTER COLUMN qtd_mercadoria decimal(12,4) NOT NULL
But, It doesn't work. A sintax error rises.
I need to change that field in a Visual Basic aplication, dinamically.
How can I do it? How can I create a decimal(12,4) field via script in MSACCESS?
Thanks,
Euler Almeida
--
Message posted via http://www.sqlmonster.com