shreeks 0 Posted May 9, 2011 Friends, PFA code snip for reference. #include <_sql.au3> #include <array.au3> Opt ("trayIconDebug",1) _SQL_RegisterErrorHandler() ; register the error handler to prevent hard crash on COM error $oADODB = _SQL_Startup() If $oADODB = $SQL_ERROR then Exit Msgbox(0 + 16 +262144,"Error",_SQL_GetErrMsg()) If _sql_Connect(-1,"ctsintcosinb","LPS_March_EAM_2011_02","ams","ams") = $SQL_ERROR then ; ==> change server, database, user and password to your needs Msgbox(0 + 16 +262144,"Error",_SQL_GetErrMsg()) _SQL_Close() Exit EndIf Local $avArray,$iRows,$iColumns $iRval = _SQL_GetTable2D(-1,"select * from comp_pune",$avArray,$iRows,$iColumns) ; ==> Fetch data from comp_pune table If $iRval = $SQL_OK then _ArrayDisplay($avArray, "Records from comp_pune table;") Local $D_Start_Date,$D_End_Date,$G_Start_Date,$G_End_Date,$Fetch_Records,$Retreival_Time $sqlCon= ObjCreate("ADODB.Connection") $D_Start_Date=$sqlCon.execute("DECLARE @Start_Date datetime;") $D_End_Date=$sqlCon.execute("DECLARE @End_Date datetime;") $G_Start_Date=$sqlCon.execute("SET $D_Start_Date = getdate();") $Fetch_Records=$sqlCon.execute("select * from dbo.all_lv_records_4report;") $G_End_Date=$sqlCon.execute("SET $D_End_Date = getdate();") $Retreival_Time=$sqlCon.execute("SELECT cast((datediff(ms, $G_Start_Date, $G_End_Date) / 60.0) as FLOAT) AS DiffMiliSecond;") MsgBox(0+1,"Retreival_Time_Value_Msgbox1",$Retreival_Time) $sqlCon.Close _SQL_Close() When I run the above code, _SQL_GetTable2D() function displays a list box as attached, with this post. But 'MsgBox(0+1,"Retreival_Time_Value_Msgbox1",$Retreival_Time)' pops up as a blank one. I couldn't deduce what is wrong with the code script and why this Msgbox pops up with no value? Could anyone help me out with this issue? Thanks. Learning is Lifelong! Share this post Link to post Share on other sites
hannes08 39 Posted May 9, 2011 Hi shreeks, it seems that $sqlcon.execute just returns no value. Did you try measuring the time using TimerInit() and TimerDiff() ? Regards,Hannes[spoiler]If you can't convince them, confuse them![/spoiler] Share this post Link to post Share on other sites