Hello lantica community,
In this example, the max key returned by sesame is 1336, although I can find a record with key = 1337. How come ? (search on !key=Max 1 should have returned 1336 instead of 1337, no ?)
In [13]: rs = sesame.SesameSearch("Customers.db","Customers",0,2,"!Key=Max 1","","")
In [14]: sesame.SesameTotal(rs)
Out[14]: 1
In [15]: sesame.SesameGetValue(rs,"Key")
Out[15]: '1336.00000000'
In [16]: rs = sesame.SesameSearch("Customers.db","Customers",0,2,"Key=1337","","")
In [17]: rs
Out[17]: 2
In [18]: sesame.SesameTotal(rs)
Out[18]: 1
In [19]: sesame.SesameGetValue(rs,"Key")
Out[19]: '1337.00000000'
In [20]: sesame.SesameGetValue(rs,"First")
Out[20]: 'Clooney'
In [21]: sesame.SesameGetValue(rs,"Last")
Out[21]: 'George'
In [22]: sesame.SesameGetValue(1,"Key")
Out[22]: '1336.00000000'
In [23]: sesame.SesameGetValue(1,"First")
Out[23]: 'Belbachir'
In [25]: sesame.SesameGetValue(1,"Last")
Out[25]: 'Lamine'