Code:
SELECT [PR_PRODUCT]
,[PR_COST]
,CASE [PR_COST] WHEN 0
THEN 'TRUE'
ELSE 'FALSE' END AS [CostMissing]
FROM [DBManagement].[dbo].[vwCustStock]
WHERE ([PR_RANGE] In(70,91))
romiverma
Last Activity: Jul 5 '10, 12:58 PM
Joined: Jun 20 '10
Location:
-
hi try this
-
hi neopa!
Try this
use single quotes for true as its not an integer valueCode:SELECT [PR_PRODUCT] ,'TRUE' AS [CostMissing] FROM [DBManagement].[dbo].[vwCustStock] WHERE ([PR_RANGE] In(70,91))Leave a comment:
-
romiverma replied to How to solve error "the specified value type is different to the current value type"in Visual Basicyup i checked help files also but i didn't get information abt date parameters...Leave a comment:
-
romiverma replied to How to solve error "the specified value type is different to the current value type"in Visual Basichi thks for reply but i tried single quotes also, hash sign also, but still not working. searched on net yet no result. still waiting to get it resolved.Leave a comment:
-
romiverma started a topic How to solve error "the specified value type is different to the current value type"in Visual BasicHow to solve error "the specified value type is different to the current value type"
hi,
i have used sql2000 stored procedure with 2 date parameters to create crystal report 8.5. when i am sending date parameters from vb6 and calling the report, its giving error "the specified value type is different to the current value type"
here is the code:
With CrystalReport1
.Connect = gconConnection
.ReportFileName = App.Path & "\Receipt Reversal.rpt"
... -
How to pass Parameters with single quotes in it from vb6 to sqlserver
Hi All,
how to send parameters with single quotes from vb6 to sql server2000 e.g
strFilter='wher e student_id like '21%' and '
sqlstr = "Cmsp_StudentAn alysis('" & Format(dtpFrom. Value, "mm/dd/yyyy 00:00:00") & "','" & Format(dtpTo.Va lue, "mm/dd/yyyy 23:59:59") & "','" & strFilter & "')"
connection.Exec ute sqlstr
while executing its... -
hi,
thx for reply. i know i can do this but my problem is that tb_StudentAnaly sis has many columns like Male, Female, Category etc. so am storing count for all these fields from tb_studentmaste r in variables and then i'll use these variables to insert in tb_studentAnaly sis once at a time as single record. i have to get counts using exec(@Query) bcoz i have to use same query with different filter strings. so i'll be grateful if u can tell me...Leave a comment:
-
How to return a value from execute command
hi, How to return a value from a string query when it is executed through exec command -
hi,
try
if rs_Recordset.st ate=1 then rs_Recordset.cl ose
before ur queryLeave a comment:
-
How to pass var value outside from exec command string environment
hi,
am tring to store the result of query in a variable using exec query string syntax. but i am not able to save this var value in a table because it is out of scope of exec environment. here is the code
SET @Query='DECLARE @TotRegistered as Int,@DateFrom as Datetime,@DateT o as Datetime;
set @DateFrom='+''' 01/01/2010 00:00:00'''+' ;
set @DateTo='+'''01/07/2010 23:59:59'''+';
SELECT @TotRegistered= ISNULL(COUNT(*) ,0)...
No activity results to display
Leave a comment: