Re: Run a script to alter a column in a table?

From: minjie@xxxxxxxxxx
Date: 23 Feb 2006 15:02:49 -0800

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Yes. Use ADO. That's why I said "Run this as if it were a regular SQL
command." Use the adCmdText in the Connection's Execute method:

cnx.Execute "ALTER TABLE <table name> ALTER COLUMN <column name>
DOUBLE",, adCmdText

or, however it is set up in C++.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQ/qOOoechKqOuFEgEQI0ygCfc2hk7xKqPCwAy5GN1QsnjIg/ztMAoM/E
FRgBz7Rn0Po2rzCjtOmRmBSf
=VYuR
-----END PGP SIGNATURE-----

Thanks!

.

References:
- Run a script to alter a column in a table?
  - From: minjie
- Re: Run a script to alter a column in a table?
  - From: MGFoster
- Re: Run a script to alter a column in a table?
  - From: minjie
- Re: Run a script to alter a column in a table?
  - From: MGFoster

Prev by Date: Re: Couldn't update multitable form (3 tables)
Next by Date: Re: Record locking
Previous by thread: Re: Run a script to alter a column in a table?
Next by thread: Re: Run a script to alter a column in a table?
Index(es):
- Date
- Thread

Relevant Pages

Re: Run a script to alter a column in a table?
... That's why I said "Run this as if it were a regular SQL ... Use the adCmdText in the Connection's Execute method: ...
(comp.databases.ms-access)
Re: appendChunk method resulting in incorrect data
... of a Command that is adCmdText. ... Set NoCount Off, adFldLong, and adCmdStoredProc. ...
(microsoft.public.data.ado)