3 ms·
I managed to corrupt my database and make all of the code irretrievable just by pasting a line that was too long, if I remember correctly. Luckily I was making
by perl4ever 7y ago
I managed to corrupt my database and make all of the code irretrievable just by pasting a line that was too long, if I remember correctly. Luckily I was making daily backups.
I also ran into a bug where if you read a long calculated text field from a view/query through VBA, it corrupts everything after 255 characters, even though you can get the data otherwise through the interface or save it to a table. Googling suggested this problem had existed for 10-15 years.
Also, a lot of times your query will return neither a value or null, but "#error".
And I really hate the way it destroys all your formatting whenever you save a query. Every time I need to change something, I end up copying to a text editor and formatting by hand in order to find whatever error I just introduced.