Designing a database for a windows program

**MPSoutine** · 10-10-2003

Hi,

I have a guestion about designing a Access database that will be used by a windows program. In my case I'm designing a database that will have information about the loans of a bank has: name and address of customer, start date and maturity date of the loan, amount and interest rate.

My question is what type of field description should I use in the database. My first choice is to use the Text field description. I don't plan on doing any calculations with the numbers.

The users of the application will be moving from edit control to edit control typing in the information.

If I'm just entering text is there any advantage to having the type of information I'm entering match the database field in some way. Example. Should my interest rate be a float and the loan amount be a long?

Soutine

**novacain** · 10-12-2003

>>Should my interest rate be a float and the loan amount be a long?

Up to you but IMHO yes.

This will make it easier to distiguish between data and validate input.

for example I use ints for database generated ID numbers and longs for all user entered ones.

When I ask, thru ODBC, what the field type is I can quickly tell how to display it on screen and how validate input.

**MPSoutine** · 10-14-2003

Hi N,

That makes sense. That is what I originally did with the interest rate. I used an edit control to enter the value and then used atof() to store the number in the database.

The problem I'm now having is using _fcvt() to convert 0.00035 to a string for populating a list control with this value.

This is the code I have to populate my list control:

void CTransactionSet::PopulateListControl(CListCtrl *pList)

//other code left out

char* bufferBBC;
int decimal, sign;
CString strBuyerBrokerCommission;
CString strValue,strInt,strDecimal;

strValue = _fcvt(this- >m_BuyerBrokerCommission,6,&decimal, &sign);
strInt = strValue.Left(decimal);
strDecimal = strValue.Mid(decimal);

pList->SetItemText(NextItem,3,strBuyerBrokerCommission );

The value that shows up in the list control is .350.

How is it possible to have the value 0.00035 appear in the list control?

**novacain** · 10-14-2003

strBuyerBrokerCommission is used to set the text in the list but never used in the code. So I can't tell you why. Other than that the code looks OK. I do not use _fcvt() and wonder if the CString is correctly converting from the char* to a CString.

I would use the Format() of the CString

strValue.Format("%0.6f", this->m_BuyerBrokerCommission );

for a decimal with leading zeros and 6 digits after the decimal point.

But I don't know why you want to extract the Left and Right bits so don't know if this will fill your requirements.

this will though

BufferBBC = _fcvt(this- >m_BuyerBrokerCommission,6,&decimal, &sign);
strValue.Format("%s",BufferBBC);

Thread: Designing a database for a windows program

Thread Tools

Search Thread

Display

Designing a database for a windows program

Thanks

Similar Threads

program for a database

Do you have to use an IDE such as M$ Visual C++ to write a windows program using C++?

Virtual keys

FlashWindowEx not declared?

fopen();