Click here to Skip to main content
15,391,967 members
Home / Discussions / 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.

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.