Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved date type files text in ms2016 sql

  1. Advice
0
Votes
Undo
  1. william yau
    william yau
  2. PowerBuilder
  3. Monday, 20 September 2021 03:57 AM UTC

guru

 

I graded sql 2000 to 2016. then I save memo (text) file in database, it shows follow message. my table column datatype is text. 

I would like to ask "text" files is allow for sql server or not 

William

Allow to capture and edit image for Windows Applic...
Crystal Reports (64 bit) Integration with PB 2019 ...
Responses (2)
mike S
mike S Accepted Answer Pending Moderation
  1. Monday, 20 September 2021 20:53 PM UTC
  2. PowerBuilder
  3. # 1

the error says you can't use = operator with text datatype in a where clause.    you have to use LIKE instead of = for the operator.

It is possible that you have that text column specified in your where clause in your datawindow, or in the UPDATE properties where you have key and updateable selected and you also have the text column set as updateable.  

 

 

 

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Monday, 20 September 2021 14:11 PM UTC
  2. PowerBuilder
  3. # 2

Do a SELECTBLOB to read the values and UPDATEBLOB to set the values. Don't use the dw Update() command to treat the text fields.

https://groups.google.com/g/sybase.public.powerbuilder.database/c/hW8M1MI8Tc8

You might also want to set bigger values for PBMaxTextSize and PBMaxBlobSize
in the PB.INI file. See for example this ticket, but some Google will tell you a lot more (or the PB help): https://www.appeon.com/it/standardsupport/search/view?id=4398

regards.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.