
RB: row order by RB database
Hi Frank,
Quote:
> I'am a little befor to jump out of my windw
Beachte: Nur sinnvoll bei hohen Geb?uden, ansonsten droht
berlebensgefahr.
Quote:
> them) ... is this a bug in the RB database??? Please help!
I don't think so. Perhaps oyu have a small bug in the sequence of
reading the db fields.
Have a lokk at s1 and s2. These are strings with different ways of
reading a from the db.
s1 will contain (Hans, Miller, 1234)
s2 will contain (1234, Hans, Miller)
Code:
Dim db as Database
Dim dbCursor as DatabaseCursor
Dim s1, s2 as String
db.SQLExecute("Create table People (number varchar, firstname
varchar, lastname varchar)")
db.SQLExecute("Insert into People (number, firstname, lastname)
values (1234, Hans, Miller)")
dbCursor = db.SQLSelect("select * from people where people.lastname
like '%'")
s1 = dbCursor.idxField(1).getString + " " +
dbCursor.idxField(2).getString + " " + dbCursor.idxField(3).getString
s2 = dbCursor.Field("number").getString + " " +
dbCursor.Field("firstname").getString + " " +
dbCursor.Field("lastname").getString
Gru?
Andreas