Thread: Maximum field in a table
I want to Create and handle table , this table has provision to get new fields added and removed existing field My doubt is what is the maximum field (column ) a table can have, i need the answere because my table dynamically increases with coloumn Also tell me what is the maximum record a table can have Thanku
Greetings,
What's an easy way to convert a paradox database to pgsql? I have an
ascii dump of the database which I modified for the copy command. I've tried
"copy Employee from '/mydir/somewhere/db.asc' using delimiters ';';"
Everything seems to work fine except my dates are messed up. Instead of
05-19-1877 I get 05-19-31284. Actually I get 31284 or 32766 for every year.
Help?
Tempest
http://www.wi.leidenuniv.nl/~cwong/games
http://www.planetquake.com/infinity
On Tue, 25 Aug 1998, Cho Yan Wong wrote: > Everything seems to work fine except my dates are messed up. Instead of > 05-19-1877 I get 05-19-31284. Actually I get 31284 or 32766 for every year. > Help? Well, I don't know too much about Paradox. About dates, there is only one thing I can say. If you use a format like "yyyy-mm-dd" I'm sure your date fields won't fail. I would recommend you to modify your ASCII files in order to have the date's in such format. Buena Suerte Amigo !! _______________________________________ David Martinez Cuevas Direccion General de Estadistica, UNAM - Mexico Tel. 622-60-80 E-mail david@estadistica.unam.mx ----------------------------------------
At 10:22 8/25/98 -0500, Jose David Martinez Cuevas wrote: > > >On Tue, 25 Aug 1998, Cho Yan Wong wrote: > >> Everything seems to work fine except my dates are messed up. Instead of >> 05-19-1877 I get 05-19-31284. Actually I get 31284 or 32766 for every year. >> Help? > >Well, I don't know too much about Paradox. > >About dates, there is only one thing I can say. If you use a format like >"yyyy-mm-dd" I'm sure your date fields won't fail. I would >recommend you to modify your ASCII files in order to have the date's in >such format. > The current format is "dd-mm-yyyy". At least, it complains when I try to insert the values in any other way. Can anybody still help out? I'm miffed by it completely. Tempest http://www.planetquake.com/infinity http://www.wi.leidenuniv.nl/~cwong/games