Click here to Skip to main content
15,391,967 members
Home / Discussions / Database
   

Database

 
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 
AnswerRe: Converting 1000 into 10.00 Pin
miah alom17-Oct-05 5:44
Membermiah alom17-Oct-05 5:44 
You can do it at both places. But its better to do this is a VIEW in the database. This way you avoid bugs. Hope this helps.

CREATE TABLE dbo.ctm
(
Precision varchar(32) NULL,
Val varchar(20) NULL
)

Insert ctm Values('1234567', '1')
Insert ctm Values('1234', '2')
Insert ctm Values('123456', '3')
Insert ctm Values('123456789', '4')

select convert (float,Val)/ POWER(10,convert (float,Precision)) from ctm

Use POW instead of POWER if you are not using sybase.
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 
Questioncomplex query Pin
Joshua Lunsford14-Oct-05 12:02
MemberJoshua Lunsford14-Oct-05 12:02 

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.