BDE: Master/Detail with expression; DbiLinkDetailToExp. Please help!

Article View: borland.public.cppbuilder.database.multi-tier

Article #1512

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#1512

From: pa3k
Date: Thu, 28 Oct 1999 00:00

30 lines
1549 bytes

hi,
I've got a problem. I have two tables dBase III, let's say MasterTable and
DetailTable. I have created .cdx index based on expresion:

Field1+str(Field2 , 3, 0)

in DetailTable.
Now I want to meke relation between these tables on Field1 AND Field2.

I'm quite new to CPP and BDE so everything i did is based on help. I wrote
something like this but it doesn't work.

---------------------------------------------------------------
  PChar pszMasterExp;
  IDXDesc DetIdxDesc;
  hDBICur hMastCursor, hDetCursor;

  DbiCloneCursor(MasterTable->Handle,false, false, hMastCursor);
  DbiCloneCursor(DetailTable->Handle,false, false, hDetCursor);

  DbiBeginLinkMode(hMastCursor);
  DbiBeginLinkMode(hDetCursor);

  DbiGetIndexDesc(hDetCursor,0,DetIdxDesc);
  pszMasterExp = DetIdxDesc.szKeyExp;
  DbiLinkDetailToExp(hMastCursor,hDetCursor,0, pszMasterExp);
--------------------------------------------------------------------

Could anyone help me, please?
Thanx a lot in advance.

Technical Details

Message-ID: <7v9fsd$67m12@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,dd21b25ecc7b0066,start
X-Google-Attributes: gidfcd2b,public
From: "pa3k" <pa3k@poczta.onet.pl>
Subject: BDE: Master/Detail with expression; DbiLinkDetailToExp. Please help!
Date: 1999/10/28
Message-ID: <7v9fsd$67m12@forums.borland.com>
X-Deja-AN: 541609157
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Organization: Another Netscape Collabra Server User
X-MSMail-Priority: Normal
Newsgroups: borland.public.cppbuilder.database.multi-tier