Click here to Skip to main content
15,867,835 members
Home / Discussions / Database
   

Database

 
GeneralRe: DAO Error 3028 Pin
mikanu27-Oct-05 8:38
mikanu27-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
george ivanov17-Oct-05 9:05 
AnswerRe: Import XML file in SQL Server 2000 database Pin
enjoycrack17-Oct-05 16:35
enjoycrack17-Oct-05 16:35 
QuestionDataTable, DataView, and DataGridView databinding and display Pin
Drew McGhie17-Oct-05 5:44
Drew McGhie17-Oct-05 5:44 
AnswerRe: DataTable, DataView, and DataGridView databinding and display Pin
miah alom17-Oct-05 5:48
miah alom17-Oct-05 5:48 
QuestionEarly Binding Problem Pin
itkid17-Oct-05 5:31
itkid17-Oct-05 5:31 
QuestionConverting 1000 into 10.00 Pin
hasanali0017-Oct-05 4:57
hasanali0017-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
miah alom17-Oct-05 5:44 
QuestionAccess Hyperlink Field Pin
T-Smooth17-Oct-05 2:19
T-Smooth17-Oct-05 2:19 
Questionsteps of configure the MySQL database in Windows XP Pin
khuchaiz16-Oct-05 13:18
khuchaiz16-Oct-05 13:18 
QuestionDataGrid Pin
kkchh16-Oct-05 4:55
kkchh16-Oct-05 4:55 
AnswerRe: DataGrid Pin
miah alom17-Oct-05 5:31
miah alom17-Oct-05 5:31 
GeneralRe: DataGrid Pin
Anonymous18-Oct-05 14:56
Anonymous18-Oct-05 14:56 
GeneralRe: DataGrid Pin
miah alom19-Oct-05 3:56
miah alom19-Oct-05 3:56 
GeneralRe: DataGrid Pin
Anonymous19-Oct-05 14:34
Anonymous19-Oct-05 14:34 
AnswerRe: DataGrid Pin
dwatkins@dirq.net18-Oct-05 6:01
dwatkins@dirq.net18-Oct-05 6:01 
QuestionChinese antique furniture Pin
Member 236383815-Oct-05 17:03
Member 236383815-Oct-05 17:03 
AnswerRe: Chinese antique furniture Pin
Colin Angus Mackay16-Oct-05 0:10
Colin Angus Mackay16-Oct-05 0:10 
AnswerRe: Chinese antique furniture Pin
Christian Graus16-Oct-05 12:57
protectorChristian Graus16-Oct-05 12:57 
QuestionApply UNIQUE using Visual Studio.Net Pin
Aayush Puri15-Oct-05 5:05
Aayush Puri15-Oct-05 5:05 
Questionchecking database Pin
abhinish15-Oct-05 1:11
abhinish15-Oct-05 1:11 
AnswerRe: checking database Pin
Colin Angus Mackay15-Oct-05 2:07
Colin Angus Mackay15-Oct-05 2:07 
GeneralRe: checking database Pin
abhinish16-Oct-05 0:01
abhinish16-Oct-05 0:01 
Questionado vc++ - datetime string or numbers to variant Pin
compoundeye14-Oct-05 20:55
compoundeye14-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.