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

Resolved Incorrect syntax in table blob

  1. Issue
0
Votes
Undo
  1. Winthor Caingles
    Winthor Caingles
  2. PowerBuilder
  3. Monday, 15 November 2021 03:06 AM UTC

Good day,

 

Need help...

I using table blob for the e-signature.

Why is the keyclause in datawindow table blob control does not allow variable? for example ID = :ID, column id <ID> and retrieval argument <:ID>.

 

A pop error message appears" SQLSTATE 42000 microsoft ole db driver for sql server incorrect syntax error near "=". "

 

Thank you for your help....

Attachments (1)
error.png error.png
PBNI Extensions to call Java classes
PB 2021 Deploy application
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 15 November 2021 15:00 PM UTC
  2. PowerBuilder
  3. # 1

Hi Winthor;

  Looks like it's complaining about the column "office" which, should be either a Primary Key or a column with a Unique Index on it.

Regards ... Chris

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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.