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.
S arr("dim1","dim2")="value"
Set arr("dim1",99)=187
; Persistent, will be saved with prefix ^:
S ^save("dim1","dim2")="saved value"
29
Java
Array
Array definieren
String[] ar = new String[] {"Satz1", "Satz2"};
62
VB.NET
Array
Array definieren
Dim myStrArray(3) As String
myStrArray(0)="First"
myStrArray(1)="Second"
myStrArray(2)="Third"
myStrArray(3)="Fourth"
ReDim strJahreszeiten(4)
myStrArray(4)="Fifth"
Dim my2DimStrArray(1,2) As String
my2DimStrArray(0,0) = "This"
my2DimStrArray(0,1) = "is"
my2DimStrArray(0,2) = "a"
my2DimStrArray(1,0) = "2"
my2DimStrArray(1,1) = "dimensional"
my2DimStrArray(1,2) = "matrix"
10
MySQL
Datenbank
Lesen Datensatzes
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")
12
Caché
Datenbank
Lesen Datensatzes
; Es existiert eine Tabelle namens Table.Cities welche einen Eintrag mit der ID=15 enthält. Diese Tabelle enthält das Feld "Name"
Set ds=##class(Table.Cities).%OpenId(15)
Write !,ds.Name
; Oder über SQL
Set result = ##class(%Library.ResultSet).%New()
Set sql = "SELECT Name FROM Table.Cities WHERE ID=15"
Do result.Prepare(sql)
Do result.Execute("")
For
{
Quit:'result.Next()
Set name=result.Data("Name")
}
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
