I have SQL that is returning 24 rows in SQLPlus however when I run the same query in VS2010 using Provider=OraOLEDB.Oracle its doesn't return any rows. I am using a LIKE operator with to_date. Any suggestions? Is it the provider I am using the problem?
select level from testTable where dTime LIKE to_date('3/27/2013','MM/DD/YYYY') and station = '019654'orderby dTime
Dim dsFred = New DataSet
conn = New OleDbConnection("Provider=OraOLEDB.Oracle;User ID=test;Password=testPass;Data Source=ARC")
sql = "select level from testTable where dTime LIKE to_date('3/27/2013','MM/DD/YYYY') and station = '019654' order by dTime"
myCommand = New OleDbDataAdapter(sql, conn)
Dim fred AsInteger = dsFred.Tables("fred").Rows.Count
That's a funny Oracle feature. LIKE with a date/datetime field does not make sense, I think. But I learned that "The date column will be implicitly converted to a character string (according to nls_date_format) before the comparison" (https://forums.oracle.com/forums/thread.jspa?threadID=2132385[^]) with Oracle. Never did I expect such a nonsense. What's your requirement behind that LIKE?
And I guess that the cited text shows the reason for the failure in one situation and the success in another: the nls_date_format differs.
What I am trying to do is capture any records that happened that day. Where it is a datetime field there are 24 records during that time period. I can always put in qualifers for midnight to midnight however I thought the LIKE would work. I will have to try the other way I guess...
ShowWindow(p.MainWindowHandle, ShowWindowCommands.Hide)'ShowWindowsCommand is an enum
After that I'm have an option to show it again.
I use this code
Dim h AsIntPtr = FindWindow(vbNullString, cms.Text)'cms comes from an contextmenustripIf h <> 0Then
ShowWindow(h, ShowWindowCommands.Show) 'p.MainWindowHandle'ShowWindow(hwndMain, SW_SHOWDEFAULT);
The handle h is fine but I the window do not restore. I also tryed sw_restore
Please keep in mind that I 'm testing what is possible and that there is a loot of nonsense in the code
The idea is to hide a window when I'm clicking with the middle mouse button and that I restore through a icon in the system area
Posting it here is hardly the same as comparing it. Your enum-declaration is not a UINT, but defaults to INT. I suggest you use the version from the P/Invoke website, preferably with the same name. Below code works;
<DllImport("user32.dll", SetLastError:=True, CharSet:=CharSet.Auto)> _
PrivateFunction ShowWindow(ByVal hwnd AsIntPtr, ByVal nCmdShow As WindowShowStyle) AsBooleanEndFunctionPrivateEnum WindowShowStyle : uint
Hide = 0
Show = 5EndEnumSub Main()
Dim p = Process.Start("calc.exe")
Console.WriteLine("Any key to hide")
Console.WriteLine("Any key to show")
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
Dim height As Double'inches
Dim weight As Double 'pounds
Dim name As String
Dim stats As Appearance
Private Sub btnDisplay_Click(...) Handles btnDisplay.Click
Dim personl, person2 As Person
Dim person1 As String = Michael
(missing lines –come from a, b, c, d, & e listed below)
(a) Give person, the name Michael
(b) Set Michael's height and weight to 71 and 190, respectively.
(c) Give person2 the name Jacob.
(d) Set Jacob's height and weight to 70 and 175, respectively.
(e) If one person is both taller and heavier than the other, display a sentence of the form