You may optionally enter a comparison operator (<, <=, >, >=, <> or =) at the beginning of each of your search values to specify how the comparison should be done.
If Me.ActiveMdiChild IsNot Nothing Then
Dim frm As SubForm = CType(Me.ActiveMdiChild, SubForm)
frm.textBox1.Text = "......."
End If
' Beispiel:
If Me.ActiveMdiChild IsNot Nothing Then
If Me.ActiveMdiChild.Name="frmHotel" Then
Dim frm As frmHotel = CType(Me.ActiveMdiChild, frmHotel)
MessageBox.Show(frm.hotelid)
End If
End If
4
VB.NET
GUI, MDI-Fenster
Alle MDIChilds durchlaufen
Dim oForm As Form
For Each oForm In Me.MdiChildren
If Not TypeName(oForm) = "MDIForm" Then
If oForm.Name = "frmHotel" Then
' Es gibt mind. 1 geöffnetes Browser-Fenster
' ...
End If
End If
Next
5
VB.NET
GUI, MDI-Fenster
Auf ein Object eines MDIChilds zugreifen
Dim oForm As Form
For Each oForm In Me.MdiChildren
If Not TypeName(oForm) = "MDIForm" Then
If oForm.Name = "frmHotel" Then
MessageBox.Show(oForm.GetType.ToString + "|" + CType(oForm, frmHotel).hotelid.ToString)
End If
End If
Next
6
MySQL
Datum, Zeit
Aktuelles Datum/Uhrzeit
SELECT NOW();
INSERT INTO table (datetime) VALUES (NOW());
7
Mumps
Datum, Zeit
Aktuelles Datum/Uhrzeit
; The first integer is the number of days since December 31, 1840, where day 1 is January 1, 1841. The second integer is the number of seconds since midnight of the current day
Set h=$horolog
S h=$H
W !,h ; gibt aus 61793,34937 was dem Datum 2010-03-08 und der Uhrzeit 09:42:17 entspricht
8
Caché
Datum, Zeit
Aktuelles Datum/Uhrzeit
; Datum und Uhrzeit formatiert ausgeben
Set datuhr=$ZDateTime($Horolog,8)
; ergibt 20100308 09:47:36
; nur Datum
Set dat=$ZDate($Horolog,3) ; = 2010-03-08
; nur Zeit
Set uhr=$ZTime($Piece($H,",",2)) ; = 09:50:20
SELECT * FROM myTable WHERE id=1;
SELECT field2,field17 FROM myTable WHERE id=1 AND name='test';
SELECT field3,field1 FROM myTable WHERE city like '%ew Yor%';
11
Mumps
Datenbank
Lesen Datensatzes
; In M werden Tabellen Globals genannt
S id=1
W !,^TABLE(id)
S street="Hollywood Drive"
S city="Los Angeles"
W !,^PERSONS(street,city)
S temp=^GLOBAL(0,"test","temp1")
