General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Primary Index Key on multiple fields.
Hi All,
We would like to have a Primary index key that is based on more than 1 field. i.e. Po_no N(11), po_ln_no N(11). I know po_no + po_ln_no will SUM() the 2 columns. We tried PADL(TRANS(po_no), 11, '0') + PADL(TRANS(po_ln_no), 11, '0') This does not work. But we have no idea why not. We keep getting an error saying the uniqueness of the index has been violated.
Can it be done? If so, what did we miss?
VFP6 SP5 - The database is a standard VFP '.dbc'
TIA
Mike
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only