Erwin,
Please refer to: http://www.sqlite.org/faq.html#q13
Regards,
-- Tito
On 21 jul 2004, at 9:53, Erwin Jabor wrote:
Hi.
I have to change the Column Type of two coumn in the database. In the old Day's with MySQL it was doing with the following
statement:
ALTER TABLE Invoice CHANGE SQLKnr SQLKnr VARCHAR(8);
This change the column-type from integer to varchar(8)
I was trying this with several variations but no luck. It's luck like that ALTER is not supportet.
My question is how can I change the type without retyping al the information, that is not an easy job becouse of the amount
of the enree's.
I hope there is a better way.
Regards Erwin Jabor
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.714 / Virus Database: 470 - Release Date: 7/2/2004
smime.p7s
Description: S/MIME cryptographic signature
