using SDAC 4.3 Version MSQuery bug ?

[sidodang1]

Right now we are using SDAC 4.3 Version
We have few questions about this program
CLIENT
OS : WINDOWS XP PRO

DB SERVER
OS : WINDOWS 2003
DB : MSSQL 2000

In SDAC Demo program, we were testing QUERY FIELD and as we were uploading it changed to READ ONLY.
We later found out that QUERY DB FIELD it changes to READ ONLY by default.

ex) SELECT CASE WHEN DEPTCODE = '001' THEN 'A' ELSE 'B' END AS
TESTFILD
FROM DEPTINFO

As describe as above, all the test field changes to Read Only (CASE, MAX, isnull, ect…)

We would like to find out what is real problem, MSQUERY or MSCONNECTION, or because it’s demo we have no option to change the default status.

Please kindly reply on this matter, so that we can take further action in your program.

[Antaeus]

SDAC detects fields, which changes cannot be handled automatically, and sets their ReadOnly property to True. If you want to update these fields, you should manually set ReadOnly to False and provide the correct statement to the SQLUpdate/SQLInsert properties.