((I would suggest you jump to a more recent discussion of these matters, as it covers the same ground AND DURING THAT DISCUSSION THE ANSWER EMERGED! (^_^))
I am trying to switch to using LO with the standard (embedded) Firebird. I used OO with HSQL for a long time… and often used fields with the Memo data type.
“All I want”, for now, is a guide to setting up a new database with one table, three fields…
- PrimaryKey / integer/ auto increment
- Name / Text [VarChar]
- Notes / THIS IS WHERE My PROBLEM LIES
If all I wanted was a database and table, but with just the first two fields, I’d be fine. No help needed with that.
It is the third field that I can’t achieve. If I were using Open Office/ embedded HSQL, I’d use a Memo field.
I want to be able to put snippets of text in the “Notes” field. Snippets consisting of several lines. (In what I am seeking, I could, for instance, put the following in the “Notes” field of a record
In 1887, Derby had 57 pubs 1893, Travel to London took a day (This ends example of the sort of data I want to store in a field)
I’ve read many posts about “fixing” memos, importing, etc. I can’t seem to get STARTED… thought that if you could show me the above, it would give me the start I seek.
I’d be more than happy to go to an existing resource on the web… would prefer that, actually!.. if you can recommend one… but one I can READ, please. Not a video.
Win 10/ LO 22.214.171.124, 64 bit.