CODEWITHSUNDEEP
firebirdfirebird-4.0
ralfiii
ralfiii

Reputation: 676

Insert content of (text) file with isql into table field

With Firebird, the databases can be edited quite comfortably via isql.

Now I have a database where in one field

VALCONTENT BLOB SUB_TYPE TEXT SEGMENT SIZE 80

contains a continuous text.

I would now like to write the content of a text file into it.

Pseudocode:

update foo set ValContent = <ContentFromFile "C:\MyFile.txt"> where KeyField=123

MySQL offers similar functionality with LOAD_FILE. How does this work with isql?

Upvotes: 0

Views: 219

Answers (1)

Mark Rotteveel
Mark Rotteveel

Reputation: 109090

Firebird ISQL does not have an option to load blob-content from a file.

Upvotes: 1

Related Questions