PB 2017 R3 is generating an SQL Syntax Error at run time when trying to retrieve a blob column in a data window. I'm using MySQL 5.7.24. The message is a sqlstate = 37000, 1064. The partial syntax is: "You have an error in your SQL...near ': blob FROM job_desc_blobs WHERE idjob_pos = 25' at line 1
I expect the actual SQL to read:
SELECT job_desc_blob FROM job_desc_blobs WHERE idjob_pos = 25.
I have no idea why its generating this syntax error. I've tried every possible configuration combination.
Jim
I believe you found the cause. I do see that in the SQL I can see from the error message, that it appears that there is the word ":Blob" inserted where it shouldn't be and that's what SQL is complaining about. I get the same result for Table Blob or Ole.
My SQL Select statement works OK without using "BLOB". Not sure if PB does something to it, but the SELECT statement works in Mysql as "Select job_desc_blob From job_desc_blobs Where idjob_pos = 25".
I've tried not populating the Blob/Text column in the definition window in PB when defining the blob (suggested workaround). Although I don't get the retrieve error, I am unable to double click the blob to activate it. So it looks like a no go.
This is rather odd because up until recently, this worked. I can't think of anything that has changed on my side.
Before modification：
column=(type=blob name=blob_1 dbname="some_blob_column: blob" )
After modification：
column=(type=blob name=blob_1 dbname="some_blob_column" )
The redundant ‘: blob’ is removed.