Click here to Skip to main content
15,440,714 members
Home / Discussions / Database
   

Database

 
GeneralRe: DAO Error 3028 Pin
mikanu27-Oct-05 8:38
Membermikanu27-Oct-05 8:38 
GeneralRe: DAO Error 3028 Pin
S Douglas27-Oct-05 14:30
professionalS Douglas27-Oct-05 14:30 
QuestionImport XML file in SQL Server 2000 database Pin
george ivanov17-Oct-05 9:05
Membergeorge ivanov17-Oct-05 9:05 
AnswerRe: Import XML file in SQL Server 2000 database Pin
enjoycrack17-Oct-05 16:35
Memberenjoycrack17-Oct-05 16:35 
QuestionDataTable, DataView, and DataGridView databinding and display Pin
Drew McGhie17-Oct-05 5:44
MemberDrew McGhie17-Oct-05 5:44 
AnswerRe: DataTable, DataView, and DataGridView databinding and display Pin
miah alom17-Oct-05 5:48
Membermiah alom17-Oct-05 5:48 
QuestionEarly Binding Problem Pin
itkid17-Oct-05 5:31
Memberitkid17-Oct-05 5:31 
QuestionConverting 1000 into 10.00 Pin
hasanali0017-Oct-05 4:57
Memberhasanali0017-Oct-05 4:57 
I have been given a Product table whoes all column types are varchar(8000)

One of the column is Price and other is DecimalPosition. Price column includes price without any decimal place and the data in DecimlaPosition column determins where the decimal should be placed.

So for instance, if the Price column includes '1000' and DecimalPosision includes '2' >> then it means that the actual price for this product is '10.00' and NOT '1000'. Similarly, if the DecimalPosision includes '3' >> then it means that the actual price for this product is '1.000' and NOT '1000'

My question is that when I am getting the price for a product from this table, how can I get the price in the correct format, e..g like '10.00' and not '1000'

Should I use SQL statements to convert 1000 into 10.00 or should I use some sort of programming logic to convert 1000 into 10.00.

kind regards


AnswerRe: Converting 1000 into 10.00 Pin
miah alom17-Oct-05 5:44
Membermiah alom17-Oct-05 5:44 
QuestionAccess Hyperlink Field Pin
T-Smooth17-Oct-05 2:19
MemberT-Smooth17-Oct-05 2:19 
Questionsteps of configure the MySQL database in Windows XP Pin
khuchaiz16-Oct-05 13:18
Memberkhuchaiz16-Oct-05 13:18 
QuestionDataGrid Pin
kkchh16-Oct-05 4:55
Memberkkchh16-Oct-05 4:55 
AnswerRe: DataGrid Pin
miah alom17-Oct-05 5:31
Membermiah alom17-Oct-05 5:31 
GeneralRe: DataGrid Pin
Anonymous18-Oct-05 14:56
MemberAnonymous18-Oct-05 14:56 
GeneralRe: DataGrid Pin
miah alom19-Oct-05 3:56
Membermiah alom19-Oct-05 3:56 
GeneralRe: DataGrid Pin
Anonymous19-Oct-05 14:34
MemberAnonymous19-Oct-05 14:34 
AnswerRe: DataGrid Pin
dwatkins@dirq.net18-Oct-05 6:01
Memberdwatkins@dirq.net18-Oct-05 6:01 
QuestionChinese antique furniture Pin
Member 236383815-Oct-05 17:03
MemberMember 236383815-Oct-05 17:03 
AnswerRe: Chinese antique furniture Pin
Colin Angus Mackay16-Oct-05 0:10
MemberColin Angus Mackay16-Oct-05 0:10 
AnswerRe: Chinese antique furniture Pin
Christian Graus16-Oct-05 12:57
mveChristian Graus16-Oct-05 12:57 
QuestionApply UNIQUE using Visual Studio.Net Pin
Aayush Puri15-Oct-05 5:05
MemberAayush Puri15-Oct-05 5:05 
Questionchecking database Pin
abhinish15-Oct-05 1:11
Memberabhinish15-Oct-05 1:11 
AnswerRe: checking database Pin
Colin Angus Mackay15-Oct-05 2:07
MemberColin Angus Mackay15-Oct-05 2:07 
GeneralRe: checking database Pin
abhinish16-Oct-05 0:01
Memberabhinish16-Oct-05 0:01 
Questionado vc++ - datetime string or numbers to variant Pin
compoundeye14-Oct-05 20:55
Membercompoundeye14-Oct-05 20:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.