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.