Linking a database to a MemoBox(C++)

clarabell

Hi all,
I have a memobox with a letter, including the field headings such as <Name1>, <Name2> etc
I want to link these field names with a database called "Maildata.mdb".
I have already created the database with the same field headings.
I want to replace <Name1>, <Name2> etc in the memobox with the data contained in the database.

File *in;

in = fopen("MailData.mdb","r");

if(Form1->Memo1->SelText == "<name1>"){
Memo1->SelText =

This is the point where I am stuck, how do I assign the database to the SelText i.e <Name1> in the MemoBox?

I would appreciate any help with this
Thanks
Clarabell

dazberry

Originally posted by clarabell
Hi all,
I want to link these field names with a database called "Maildata.mdb".
I have already created the database with the same field headings.
I want to replace <Name1>, <Name2> etc in the memobox with the data contained in the database.

File *in;

in = fopen("MailData.mdb","r");

if(Form1->Memo1->SelText == "<name1>"){
Memo1->SelText =

You appear to be opening the database as a binary file, and from the extension it looks like an access database ??? If you have actually created the database in say Access, you will need to open the database using something like the BDE (shudder) or better layer.

If you do, it will be available from a TDataSet decendant, so you can use something like
Memo1->SelText = myDataSet.FieldByName('name1') -> asString.

However, if you've created the database as a binary file (fixed length records), you'll need to load it into a record (struct in C) and access the specific member. My C is far to rusty to remember how to do that.

D.