Dim DBxdoKey As Double=bxdokey
SqlStr="SELECT * FROM pedidos WHERE bxdo=" & DBxdoKey & " ORDER BY idnuvem"
' SqlStr = SELECT * FROM pedidos WHERE bxdo=45.1 ORDER BY idnuvem
List=DBUtils.ExecuteMemoryTable(Starter.SQL3, SqlStr , Null, 0)
The bxdo field is a "DOUBLE" var type.
Even if SqltStr is "SELECT * FROM pedidos WHERE bxdo=45.1 ORDER BY idnuvem" the list returns allways as empty ....
Dim DBxdoKey As Double=bxdokey
SqlStr="SELECT * FROM pedidos WHERE bxdo=? ORDER BY idnuvem"
List=DBUtils.ExecuteMemoryTable(Starter.SQL3, SqlStr , Array As String(DBxdoKey),0)
1) There is no record with value 45.1 for bxdo, or
2) You are not using the right database, or
3) You are having a floating point issue (the DB stored 45.1 as 45.099999999 or 45.100000001 or something like that), or
4) Something else - have you checked the logs?
Sub Start(DummyBxdoI As Float, DummyBxdoF As Float)
SqlStr="SELECT idp3, idnuvem FROM pedidos WHERE bxdo>=" & DummyBxdoI & " AND bxdo<" & DummyBxdoF & " ORDER BY idp3"
Lista=DBUtils.ExecuteMemoryTable(Starter.SQL3, SqlStr , Null, 0)
.
.
.
.
.
So I can encrease the DNr "60"-payment option with more options and still beying in the "60"-class.
Maybe not so elegant solution but for now its working.