On Tue, 17 May 2005 16:33:33 +0900, "Wen Guangcheng" <wen@xxxxxxxxxxxxxxxx> wrote: > Hi Klint, > > Thanks for your help. > But the error message still exists even though the 2 was droped from the varchar. try taking the double quotes out of the primary key (as richard said) and change number to numeric klint. +---------------------------------------+-----------------+ : Klint Gore : "Non rhyming : : EMail : kg@xxxxxxxxxxxxxx : slang - the : : Snail : A.B.R.I. : possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---------------------------------------+-----------------+ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
