|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
| View Poll Results: Microsoft .NET is going to change the scenario of Software World | |||
| Yes, Sure |    | 2 | 100.00% |
| No |    | 0 | 0% |
| Somewhat |    | 0 | 0% |
| Can\'t say now |    | 0 | 0% |
| Voters: 2. You may not vote on this poll | |||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
December 31st, 2002, 11:37 PM
|
|||
|
|||
Errors in passing parameters to SQL Server Stored Proc
I'm getting Error 'Invalid precision' when trying to pass a adDouble parameter to SQL Server Stored proc. If i want to send floting point value to SQL database (eg 28.76547), what datatype should i use from VB to get the exact value saved with decimals. i used Float datatype in SQL Server, and using adDouble from VB. but it is not working. some times it is saving but, rounded value(i.e not decimals).... ?
|
|
#2
January 2nd, 2003, 02:44 AM
|
|||
|
|||
|
Hmmm try adFloat and typecase using CFloat(x) to make sure its cast to its proper type. MSDN.microsoft.com has a list of constants for this, just search for "CreateParameter SQL Server adInteger" and it should bring up a list...
|
|
| Viewing: Dev Articles Community Forums > Programming > ASP Development > Errors in passing parameters to SQL Server Stored Proc |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
