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
mariowayAsked:
Who is Participating?
 
Mohammed NasmanConnect With a Mentor Software 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.