We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
0

How do I create field for multi-line text? (Firebird) [closed]

asked 2021-01-17 12:57:21 +0200

MSPhobe gravatar image

updated 2021-06-19 16:16:48 +0200

Alex Kemp gravatar image

((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 7.0.3.1, 64 bit.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-06-02 06:56:49.346562

Comments

Thank you, Ratslinger for more help. You said...

The field type in Firebird embedded is:

CLOB[BLOB SUB_TYPE TEXT]

(Apologies for my poor markup... I can't find the forum's guide!)

a) For at least ten years (going back into my OO / HSQL days), I've not understood the data type format of "one-moniker"["qualifier"]

b) In my work to understand this "doing what HSQL calls a Memo" stuff, I have often seen references to "sub_type"... but when I struggle away with the application, I have yet to see the word anywhere...

Perhaps because all of my efforts so far have only involved the app's GUI? Is it necessary to turn to using command-line level SQL (e.g. things like "SELECT CustomerName, City FROM Customers;") to attain the power of specifying "sub_types"?

MSPhobe gravatar imageMSPhobe ( 2021-01-19 09:11:06 +0200 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2021-01-17 18:11:47 +0200

Ratslinger gravatar image

Hello,

It appears you already have found the answer for this in this post -> Paste data in new base: How to define "MEMO" fields?

To be clear, the field type in Firebird embedded is:

CLOB[BLOB SUB_TYPE TEXT]

Now you also asked in a comment there:

Please expand upon how to... "change the image field to a text box" ?

With any control on a form, while editing the form, select the control. Then right mouse click it. Select Replace with and choose the control it is to be replaced with. In your question it would be a text box. Also, once changed to a text box, there is a property on the General tab called Text type. Insure this is set to Multi-line.

edit flag offensive delete link more

Comments

Ratslinger's answers moved me forward! I got it working! I'll try to write up... there are a few little "gotchas" to avoid. Thank you Ratslinger!!

MSPhobe gravatar imageMSPhobe ( 2021-01-17 19:21:22 +0200 )edit

@MSPhobe,

As with all questions, if this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

Ratslinger gravatar imageRatslinger ( 2021-01-17 19:41:47 +0200 )edit
0

answered 2021-05-14 08:34:00 +0200

MSPhobe gravatar image
edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2021-01-17 12:57:21 +0200

Seen: 75 times

Last updated: May 14