Information générale
Catégorie:
Codage, syntaxe et commandes
>Thanks Nick! Thats what the problem was. How it got that way???? It's kinda depressing when you're cruising right along and something like this happens, and you suddenly realize how little you know. Thanks again
Tony --
Looks like Nick solved your immediate problem, but I would like to pass on one other thing about using CREATE SQL VIEW in an application (I learned it "the hard way" awhile back).
This may be a little off-topic, but have you noticed that each time you run a CSV, your .DBC increases in size? If the view already exists when your CSV fires, the view's existing rows in the .DBC are flagged as being deleted, and then entirely new view definition rows are added to the .DBC.
My solution to this was to code the application in such a way as to only fire the CSV when absolutely necessary. Then, in my "database reorganization" method (packing, index regeneration, etc.), there is a piece of code that actually packs the .DBC.
Hope this helps -- Bill
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement