I hope  I post at the right place.

Hi : I am using SAPDB 7.3.0.29 with win2k pro as a server. Frontend running
delphi 6.xx on XP.
I am using ADOdataset with dbgrid.
Table: create table test( cno smallint key default serial,
cdetail varchar(24))
connection is fine, data can be inserted or added.
However , if I want to edit key field( cno) with different number without
violating the property, ie,  not a duplicate value  , it gives me the
following error message :
[SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access violation;-5001 pos(21)
Missing privilege:CNO.
In my connection to SAPDB , I used DBA ( who is the owner of the db and also
a user).
Any suggestion ?
Thanks for the help.



_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to