Change field form Long to Double Precision

[Henrootje]

is there a way, using code, to change all of the numeric fields in a
database (preferrably in selected tables but not necessarily so) form
Long to DOuble Precision?


Greetings,

Henro Veijer

 

[Allen Browne]

Execute a DDL query statement to change the field type, e.g.:
ALTER TABLE MyTable ALTER COLUMN MyField DOUBLE;

Introduction to DDL, and example:
http://allenbrowne.com/func-DDL.html#ModifyFieldDDL

List of the names to use in DDL, compared to the names in the Access
interface:
http://allenbrowne.com/ser-49.html

 

[Henrootje]

Thanks Allen

Execute a DDL query statement to change the field type, e.g.:
ALTER TABLE MyTable ALTER COLUMN MyField DOUBLE;

Introduction to DDL, and example:
http://allenbrowne.com/func-DDL.html#ModifyFieldDDL

List of the names to use in DDL, compared to the names in the Access
interface:
http://allenbrowne.com/ser-49.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.






- Tekst uit oorspronkelijk bericht weergeven -

1