Hi Karthik, The way to solve this problem is to use logging. Turn on SQL logging on the server to identify *exactly* the SQL statement causing the error. You probably should also turn on Filter logging (and direct them into the same file) so that you can see if the SQL is being caused by some filter (perhaps, say, a Push Fields from the form you've been looking at, and that you've seen does NOT have any unique index, to some other form which DOES have a unique index).
Be sure to enable the logging just before performing the offending transaction, and turn it off just after. When you review the resulting log, chances are you'll see that the error is being caused by a SQL statement that begins with: UPDATE T<some form number> SET C<some field number> = <some value>... If it's not already obvious from the filter logging which is the problem form, use this in a SQL Query window to identify the form: SELECT name FROM arschema WHERE schemaId = <some form number> where, probably obviously, <some form number> here is the number next to the "T" in the UPDATE statement as shown above. Hopefully this is all clear and easy to follow. Let me know, though, if you have any questions. -charlie On Thu, Jun 12, 2014 at 7:19 AM, karthik manoharan <[email protected]> wrote: > ** > > Hello Listers, > > We have our ARSystem server installed on SQL server, there is a strange > thing noticed for one of the forms which throws “Unique Index”error on > creating duplicate records. I have checked the Indexes defined for the form > but it doesn’t have “Unique Index” enabled. > > So, I would like to view the Table Definition such that I could identify > any primary key or constraints on the attribute. Is there a way to view the > DDL for the tables in AR system schema. > > PS: I use SQL Server Management Studio to connect. > > Regards, > Karthik > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
