vb.net - SQL Select results in 0 rows only if I use a date or date range -


so i've been stuck on awhile because every statement came test in sql developer , worked fine, pulling on 300 rows. error in vb.net saying 0 rows exist. 

select distinct mti_part_no,sum(mpcs.shop_inv_history.quantity) febqty  mpcs.shop_inventory, mpcs.shop_inv_history  shop_inv_history.date_time between '" & dt1.text & "' , '" & dt2.text & "' ,       shop_inv_history.comments = 'check item out' , mpcs.shop_inventory.si_key=mpcs.shop_inv_history.si_key ,       shop_inventory.category between 900 , 999 , shop_inventory.scrap_flag <> 1  group mti_part_no  order febqty desc

now, have tried date more vague like '%feb%' or more precise 05-feb-15

all of these pull rows fine in sql developer produce 0 rows in vb. tried in c# in case , results same.

the moment take date out of equation together, data fine in vb.

i'm @ loss here.

here statement sent when ran , when copied on sql dev produces 1,022 rows

    select distinct mpcs.shop_inventory.mti_part_no,      sum(mpcs.shop_inv_history.quantity) febqty     mpcs.shop_inventory,     mpcs.shop_inv_history mpcs.shop_inventory.si_key = mpcs.shop_inv_history.si_key , mpcs.shop_inv_history.date_time between '22-jun-2015' , '14-sep-2016' , mpcs.shop_inv_history.comments = 'check item out' , mpcs.shop_inventory.category between 900 , 999 , mpcs.shop_inventory.scrap_flag <> 1 group mpcs.shop_inventory.mti_part_no order febqty desc

enter image description here


-

Comments

Post a Comment

Popular posts from this blog

php - isset function not working properly -

the page unable see login form code written under isset function statement. have written code correctly , have executed many times , code written inside isset statement not works. here code:- <?php session_start(); echo "<p style=\"font-color: #ff0000;\"> catogoies </p>"; echo '<link href="var/www/html/sample.css" rel="stylesheet">'; require_once('../html/conn.php'); $query = "select * catogories"; mysqli_select_db($dbc, 'odit'); $retrieve = mysqli_query($dbc, $query); if(!$retrieve) { die(mysqli_error($query)); } while($row=mysqli_fetch_array($retrieve, mysql_assoc)){ echo "<p style=\"font-color: #ff0000;\">".'<a href="cats.php? catogory='.urldecode($row["name"]).'">'.$row["name"].'</a>'."</p>"; $_session['cat']=$row["name"]; } if(!($_session)) ...
Read more

javascript - Thinglink image not visible until browser resize -

Image
i trying repurpose pre-existing theme, includes drop down menu displays image. trying embed thinglink drop down menu's content section, not visible until resize browser window. here menu looks like: then when clicked, can see empty space image should show: then when browser resized, image appears: this code content of menu: <div class="ajax_accordion_content" style="display: none;"> <div class="report-detail"> <table border="0" cellpadding="0" cellspacing="0" width="100%" class="table_basic"> <tbody> <!-- thinglink image embedded --> <img style="max-width: 100%;" src="http://cdn.thinglink.me/api/image/832705713204625409/1024/10/scaletowidth#tl-832705713204625409;1043138249'" class="alwaysthinglink"/> <script async charset="utf-8" src="http://cdn.thinglink.me/jse/embed.j...
Read more

firebird - Error "invalid transaction handle (expecting explicit transaction start)" executing script from Delphi -

i'm developing update app delphi 10. i'm running windows 7 64x, firebird 2.5.1.26351 32x. execution order: checks current version(select statement firebird database) downloads update(via ftp) apply it(.exe files, , execute .sql) error code -901 pops out when try execute .sql files. know there incompatibility issue w7 64x , fdb 32x, but, can everything: backup , restore(gbak), db commands(all). tried fdb 64x instead, , not working. code: //components fdwaitcursor: tfdguixwaitcursor; fddriverlink: tfdphysfbdriverlink; fdconnection:tfdconnection; fdscript: tfdscript; function tthr_script.createcomponents:boolean; begin try fddriverlink := tfdphysfbdriverlink.create(fddriverlink); fdwaitcursor := tfdguixwaitcursor.create(fdwaitcursor); fdconnection := tfdconnection.create(fdconnection); fdconnection begin drivername := 'fb'; params.username := thrbanco.bduser; params.password := thrbanco.bdpass; params.database := ...
Read more