Subject | Re: [IBO] Work with large texts, format text, blob field and image |
---|---|
Author | Michel LE CLEZIO |
Post date | 2019-07-23T19:45:32Z |
Hello Gustavo,
With blob it should be possible. But if it's possible for you, it could be better to place those file on a server, and put in a varchar field the full filename of the file… And why not build a table for file with an ID field and a Filename field ? With the ID as a key link for other table … Like this you won't have to extract files and rebuild them… Direct acces from full filename… Most fast, and backup of your database : faster too...
Like this, the database file will be smaller, and I presume that the impact on speed will be positive….
With best regards,
MLCVISTA
Le mardi 23 juillet 2019 à 19:40:16 UTC+2, Gustavo Novaes gutonovaes19@... [IBObjects] <IBObjects@yahoogroups.com> a écrit :
Hi
I want samples or similar to learn how working with this "objects".
I want
- send to Database and Get from Database - large formated documents (like ms-word, rtf...)
Today, while i pump database from Paradox to Firebird (3.0 - with tIboTable), i didn´t get field value paradox.fmtMemo to firebird.blob - subtype 0 (zero).
Gustavo Novaes