New topic: Edit the Column Name in Real SQL database ?
<http://forums.realsoftware.com/viewtopic.php?t=43293> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message prakashp Post subject: Edit the Column Name in Real SQL database ?Posted: Fri Mar 23, 2012 5:55 am Joined: Tue Dec 27, 2011 8:54 am Posts: 38 Hi All, I found some error while make some changes in the column of Real SQL database. Suppose i have a table. I want to modify the Column name but i could not get any way to do that. Its showing some exception message and project is shut down. Can you please tell me how to Edit the Column Name in Real SQL database ? Thanks, Prakash Top DaveS Post subject: Re: Edit the Column Name in Real SQL database ?Posted: Fri Mar 23, 2012 8:19 am Joined: Sun Aug 05, 2007 10:46 am Posts: 3526 Location: San Diego, CA Real Studio uses SQLite Database .... http://www.sqlite.org/lang_altertable.html but to quote the above webpage Quote:It is not possible to rename a column, remove a column, or add or remove constraints from a table. meaning you have to rebuild the table with a new naming structure. There are programs out there like "SQLiteMan" that do all the hard work behind the scenes for you. _________________ Dave Sisemore MacPro, OSX 10.6.8 RB2011r3 Note : I am not interested in any solutions that involve custom Plug-ins of any kind Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
