[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 457
  • Last Modified:

How to add a FORMATTED MEMO FIELD to a Paradox table using SQL

Hi, can anyone help me on this

I want to add a FORMATTED MEMO field to a paradox table at runtime using SQL. I know how to do this for a plain memo field
(Blob). It is urgent.

thx alot
marioway
0
marioway
Asked:
marioway
  • 2
1 Solution
 
Mohammed NasmanSoftware DeveloperCommented:
Hello

  You could use blog and define the type of the blob field

Try this query

create table MyTable
(ID integer,
  myMemo blob(1,3))

the first parameter of Blob to define the size that will be stored in the table, second one the type of blog
Use
1 = Memo
2 = Binary
3 = Formmated Memo

HTH

Regards,
Mohammed
0
 
mariowayAuthor Commented:
Hi Mohammed. It works fine. Thank you very much.

Regards
Marioway
0
 
Mohammed NasmanSoftware DeveloperCommented:
You are very welcome Marioway ;-)
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now