NetTalk Central

Author Topic: How do I display and update a text blob field in a table  (Read 3432 times)

MikeR

  • Sr. Member
  • ****
  • Posts: 265
    • View Profile
    • Email
How do I display and update a text blob field in a table
« on: February 22, 2013, 04:37:04 AM »
How do I display and update a blob field in a table using netwebbrowse and netwebform.
The blob field contains text, not an image.
I want to show the text and allow it to be updated, it may be small or very large .. ... ?

MikeR

  • Sr. Member
  • ****
  • Posts: 265
    • View Profile
    • Email
Re: How do I display and update a text blob field in a table
« Reply #1 on: February 25, 2013, 02:48:34 AM »
HELP

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: How do I display and update a text blob field in a table
« Reply #2 on: February 25, 2013, 07:01:59 AM »
Hi Mike,

Blobs aren't supposed to contain "text" - the correct field for that is a Memo. So I'd need to look to see if using a Blob in this way is possible. You want to edit the text as well, so that's another issue.

So, if you can, use a Memo field for this rather than a blob.

cheers
Bruce

MikeR

  • Sr. Member
  • ****
  • Posts: 265
    • View Profile
    • Email
Re: How do I display and update a text blob field in a table
« Reply #3 on: February 26, 2013, 02:32:43 AM »
Thanks Bruce, Its actually a MicroSoft SQL Table, the field is Type text.
When you import it into dictionary it comes over as blob.
Will memo work ?
I finally used a local variable on the form and initialized it in 'restore' embed and updated it 'in just before writing to disk' embed.