Re: TZF - Topaz8 and C++Builder6

Hi Glen,

I don't have C++ but the Delphi solution may be similiar....

1- if you are setting the dbf active in code, then you must make sure 
that the dbf is NOT active in the Object Inspector prior to compiling, 
otherwise you will get a 'file sharing error'.

2 - Are you trying to display the Customer Name & Phone # in the grid or 
some label on the form?

I think you may be doing some 'circular' references.  You don't need to 
create a separate field in the databases if you are only displaying the 
info on the form.  If you are trying to display the info in the grid, 
then you need to create a 'calculated field' in the grid and populate it 
  programmatically.  You also need to have the 'look-up' database 
indexed on the NAMENO.

Your answer to #2 will help me further to offer a solution.

Marie



Glen Taylor wrote:
> Hi Kenneth: I am just getting started with c++Builder so bear with me. Here
> is my example.
> 
> #1 i have a cust name dbf file(topaz) which holds customer information.The
> unique key in this file is NAMENO which is set as a Number 8,0 long
> 
> #2 i have a cust equipment dbf file which holds a information about machines
> that customer own. There is one record per piece of equipment.There is also
> a field name in each reco called NAMENO.
> 
> #3 what i am tring to do is create a topaz grid displaying the custequipment
> dbf records and create a lookup field which would use the NAMENO from the
> cust equipment record and get the name and phone number from the cust name
> file and display it for each record displayed in the grid.
> 
> What i have been doing is starting with a new project and clear form i add a
> topaz datafile[tzdbf1]and set dbf file as custequip.dbf(my file name).I then
> add another topazdatafile[tzdbf2] and set dbf file as custname.dbf(my file
> name).I now create a datasouce for each tzdbf and link them to each file eg
> [dbf1 linked to ds1] [dbf2 linked to ds2]. i now go to tzdbf1 and using the
> edit fields and creat a new field called lkcustname and set it to
> string,30char,lookuptype,nameno as field to use for lookup,tzdbf2 and file
> to lookup,nameno as field to use,name as the field to return.
> If i had both files set as active i get errors about cannot file to active
> file. If i leave the non active and try to set to active after i get a error
> NAMENO field not found.
> 
> "Kenneth Camargo Jr." <[email protected]> wrote in message
> news:<[email protected]>...
> 
>>On 1 Feb 2003 at 14:30, Glen Taylor wrote:
>>
>>
>>>Thanks i tried it and it seemed to compile. Have you tried setting up
>>>persistent fields and topaz. I always seem to get errors when trying to
>>
> set
> 
>>>them up. I have even tried a simple example with 2 datacontrol a
>>
> custname
> 
>>>file and a custequip file. I wanted to use the customer number field in
>>
> the
> 
>>>custequip file and lookup the name in the customer name file. I get
>>
> errors
> 
>>>about cannot use files that are open etc.
>>>Any ideas.
>>>
>>
>>Hi Glen,
>>Can you give more details of what you are doing? I've just upgraded to BCB
> 
> 6/Tz 8 and all my apps are working OK (or at leas as badly as they were
> before <g>).
> 
>>Ken
>>
>>Kenneth R. de Camargo Jr.
>>website:http://planeta.terra.com.br/educacao/kencamargo/

==^================================================================
This email was sent to: [email protected]

EASY UNSUBSCRIBE click here: http://topica.com/u/?clvXPN.a5kvff.Z2NsZHQt
Or send an email to: [email protected]

TOPICA - Start your own email discussion group. FREE!
http://www.topica.com/partner/tag02/create/index2.html
==^================================================================