I set the Updateable Icon to ON, but after running the query it still states "Data Set is Read-Only; 1 row(s) fetched". One of my table column name is similar or the same as a reserved word.
EXAMPLE:
1) I turn ON the "Updateable" Icon in the Editor window
2) I run the script below:
Select *
From units
Where unitkey = 2109710
And the Status Bar at the bottom of the Editor states:
"Data Set is Updateable; 1 row(s) fetched"
3) If I run the script below:
Select a.unitkey, a.setupkey, a.setuplevel, a.bolkey, a.ordernumber,
a.unitnumber, a.unitcount, a.stackswide, a.stacksdeep,
a. shiptrnxkey, a. trailerkey, a. corpshipmentnumber, a. lotkey,
a.orderkey, a.type, a.releasekey, a.unitname, a. currentstatuskey,
a.weight, a.machineid, a. isoffcorline, a. routingnumber,
a. vendorkey, a. unitcountadj, a. custunitid, a. unitlocationkey
From units a
Where a.unitkey = 2109710
The Status Bar at the bottom of the Editor states:
"Data Set is Read-Only; 1 row(s) fetched"
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center