Hi, All
I am trying to create a foreign key reference into a table through SPT from VFP. This is the code that I setup, but SQL Server sends back an error.
lcInsertStr = "ALTER TABLE " + lcTableName + " ADD CONSTRAINT STUDNT_ID_ FOREIGN KEY REFERENCES STUDNT (STUDNT_ID_)"
the error is:
1526 Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Number of referencing columns in foreign key differs from number of referenced columns, table 'STUTRN'.
TIA
Beth