Using locate method to search for a composite PK

[Gugge]

Hello

I'm using RAD Studio v10.2 and PgDac 5.3.9

I'm attempting to check wether a primary composite key exists or not, if it exists i want to move the cursor to its position.

The code works if i look up one of the two, but not both.

Code: Select all

AnsiString colNames;
		Boolean PKExist;
                colNames="component_id; detail_type";
		locvalues[0]=Variant(1);
		locvalues[1]=Variant("Test");
		PKExist=PgTable2->Locate(colNames,locvalues,TLocateOptions());

Would greatly appriciate any help using Locate or other solutions.

[MaximG]

We could not reproduce the issue according to your description. For further investigation, please compose and send us a project, execution of which causes the issue. It is convenient to do it using the e-support form (https://www.devart.com/company/contactform.html) In addition, we will need DDL script to create DB objects used in this sample.