Ok, here's the problem with this.
I'm working on a legacy app. I'm writing a process that automatically inserts records into
a DBF.
There is a default value for the PK field:
new_pk("custpoc","poc_pk")
which calls a stored proc that returns the row's PK value.
My process forms an INSERT statement, which is throwing an error "Uniqueness of index POC_PK is violated."
Not all tables are calling this stored proc, so this presents a problem.
I'm trying to make my process generic so that I can use it in any app. I need a way to
exclude the PK column from the insert statement when this rule is in place.
Anyone?
>>How do I return the name of a table's AutoInc field?
>
>Spin through the results of AFIELDS() or COPY STRUCTURE EXTENDED and look for rows with Step > 0.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people