Welcome! Log In Create A New Profile

Advanced

Composite Key with Oracle

Posted by Juan Villasenor 
Juan Villasenor
Composite Key with Oracle
April 30, 2013 03:31PM
Hi All

I think this is not a new issue but i wnat to resolve it, the problem is when i try to use HreadSeekFirst(FileName,IndexKey,["FIELD1",NUMBER,NUMBER]) always i get the first record in the DataBase, the IndexKey is composed by:

This file had
PK_GROUP = GROUP_ID number

IDX1_FIMRAMDL_GCODE with UNIQUE check, with the following information

FIRMA_CODE varchar2(20) value="TEST"
MDLDATA_ID number value=14
GROUP_CODE varchar(12) value="010011012013"

I'm using the Oracle (Oracle Provider for OLE Dcool smiley to connect the DataBase, working fine if i don't need to access or retreive composite key ;-(

All the time when i import a file don't show up the PK_GROUP as a key only the filed name this is normal?, also the Index file create 3 files why?

Thxs

JM Villasenor
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: