At 10:54 PM 2/04/2007, you wrote: >I to was getting the unable to undate meta data error. I guess that >explains it. >So I initially tried to create the table with one large sql >statement and got a message that it was to large. >Then I split the table up and was using a seperate update command to >add each column, this caused me to run into the meta data error.
That's a bit extreme. If the CREATE TABLE statement is too long, you only needed to go back and do a single ALTER TABLE statement to follow up, and add the additional columns and constraints. >So if I break the command into say three statements will that only >count as 3 changes to meta data? Unfortunately, no. Each change is counted. >Also if there is a 64K limit on sql statements what can you do if >you are loading lseveral arge strings???? A string can't be longer than 32,765 bytes. If you are storing multiple strings of this magnitude on a single record then you're stuck up a gum-tree anyway, since you will be able to store at most ONE such column in your table. Have you ever heard of CLOBs? (In Firebird, BLOB sub_type TEXT or sub_type 1, your preference). Another useful concept in relational database design is Normalization. ;-) Helen ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
