As noted by stevend17, AGILEOBJECTIDSEQUENCE was used to generate the ID for all tables in the database. For everything up...
Hoo boy, you aren't asking for much, are you?? I would venture that it cannot be done as "one query result"....
Based on a script I created years ago to correct sequence values after cloning from a production environment to a...
We may not share the same version of Agile, because I cannot find "Complaints" as a class. If indeed Complaints...
Svevis, I'm not certain I can help or not, but to even start I have some questions. What is the...
Dear sir,
I have some item and mfg part need to delete with pl sql.
Example :
delete from ….. where item in (AAAA’,’BBBB’,’CCCC)
delete from …. where mfgpart in (‘XXXXXX’,’YYYYY’,’ZZZZZ’)
Provide plsql statement to me,Please.
Thanks you.
Deleting only from item and manu_parts will corrupt the DB, all functionality calling remaining orphan rows will fail Unknown Object. Must delete from all related tables ( bom, rev, p2,p3,manu_by, etc…too many too list)
