primary key
-
How to determine which field in a database table is the primary key (in OLEDB or ODBC) using MFC (VC++ 2005)? Thanks in advance..
Hi, I don't think this can be done using MFC. You can find it from sys tables of the database. thanks Nitheesh
-
How to determine which field in a database table is the primary key (in OLEDB or ODBC) using MFC (VC++ 2005)? Thanks in advance..
I do not think anything has changed since you last asked this question. Just out of curiosity, why do you need to know such information (i.e, what part of your code is relying upon it)?
"Love people and use things, not love things and use people." - Unknown
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
-
How to determine which field in a database table is the primary key (in OLEDB or ODBC) using MFC (VC++ 2005)? Thanks in advance..
With ODBC, there's SQLPrimaryKeys()[^] Mark
Mark Salsbery Microsoft MVP - Visual C++ :java:
-
I do not think anything has changed since you last asked this question. Just out of curiosity, why do you need to know such information (i.e, what part of your code is relying upon it)?
"Love people and use things, not love things and use people." - Unknown
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
I will update a field (Say fieldName)in the application. A trigger is executed outside the application in oracle, which changes the value of another field (Say fieldNumber=1, Now changed to fieldNumber=2 after trigger). The method i follow after field update is : 1. Update (fieldName) to database 2. Refresh the updated value and trigger changed value (fieldNumber=2) to text box. I am doing refresh using select statement .. where ... (select * from tbl where fieldNumber=1) Since the trigger changes value outside application, my select statement's where clause have old value (fieldNumber=1). It fails. Hence i want to know the primary key of the table and use refresh using select statement (only primary key)..