SELECT "SPFL". "SPFL,"
"SPFL". "NAME"
FROM "SPFL
"The WHERE (" SPFL ". "NAME" & lt;> 'no classification of goods') AND
(LENGTH (" SPFL ". "SPFL") & lt;=: jc) AND
(SUBSTR (" SPFL ". "SPFL," 1, 2) & lt; )
='03'Edit the data window can be detected data interface, but as long as the one on the application retrieve, so identifier is invalid, I also know that the name is the key word, also add double quotation marks, and the data editor window is not an error when
CodePudding user response:
Find the problem reason, two users, a user has permissions table SPFL, another user has view SPFL permissions, and view SPFL field names are different from table SPFL, when dw editor to use is the users table, and programs in connection to use is the view of the user