Hi!
On Tue, Oct 24, 2017 at 08:00:13PM +0100, Hugo Mills <h...@nightglass.co.uk>
wrote:
> Is there any way that I can modify an existing database column,
> with data in it, without losing the data in it? All I need to be able
> to do is increase the size of a StringCol.
>
> I can see addColumn and delColumn methods of the sqlmeta object,
> but not an alterColumn or anything similar.
Probably yes (depends on the backend) but not with SQLObject.
SQLObject can CREATE/DROP tables, columns and indices but cannot ALTER
them.
You need to execute ALTER TABLE connecting directly or call
connection.execute("ALTER TABLE ...")
What us your backend? MySQL?
> Thanks,
> Hugo.
>
> --
> Dr Hugo Mills | h...@nightglass.co.uk
> Chief Technologist |
> Nightglass Medical Rostering Ltd | +44 207 040 4054
Oleg.
--
Oleg Broytman http://phdru.name/ p...@phdru.name
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
