|
-
Jun 8th, 2006, 07:30 AM
#1
Thread Starter
Hyperactive Member
 [RESOLVED] Query won't run
Does anyone know why this query won't run? The fields fValue_xxx are all of the type 'nvarchar(50)'. It says that:
VB Code:
Server: Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to float.
on this query:
VB Code:
UPDATE tBSC
SET fvalue_jan = '728,4',
fvalue_feb = '769',
fvalue_mrt = '912',
fvalue_apr = null,
fvalue_mei = null,
fvalue_jun = null,
fvalue_jul = null,
fvalue_aug = null,
fvalue_sep = null,
fvalue_okt = null,
fvalue_nov = null,
fvalue_dec = null
FROM tSBF_PI WHERE lDepartmentID = 115 AND tSBF_PI.lPIID = 166 AND tSBF_PI.lSBF_PIID = tBSC.lSBF_PIID
When I remove the ',4' by fValue_jan, it works, otherwise it won't...
Anyone?
-
Jun 8th, 2006, 07:40 AM
#2
Thread Starter
Hyperactive Member
Re: Query won't run
Got it, query should replace the ',' by a '.' if the value is a float. Looks like a bug in SQL2K
-
Jun 8th, 2006, 11:24 AM
#3
Re: [RESOLVED] Query won't run
It would depend on whether SQL Server recognizes localizations, and whether the computer this is running on is localized to use ',' as the decimal separator.
The most difficult part of developing a program is understanding the problem.
The second most difficult part is deciding how you're going to solve the problem.
Actually writing the program (translating your solution into some computer language) is the easiest part.
Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.
Please Help Us To Save Ana
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote