using zero as a record key (OpenInsight 32-bit)
At 09 JUL 2021 03:51:57PM Mike ONeal wrote:
Hello folks -
A client has three records with zero(s) as record keys:
0
00
000
The command…
SELECT tablename WITH key = 0… returns all three keys
OI 9.4.4
Has anyone else seen this, and any fix or workaround available?
Thanks much,
Mike O.
At 09 JUL 2021 04:14PM D Harmacek wrote:
In basic+ when i am doing a compare where this exists, or, when a "E" is in the key which is seen as exponential notation and thus does a numeric comparison. I do the comparison by forcing EQ to compare two strings. I add a "A" to each of the values during comparison. I know you want a SELECT but possibly this workaround will work in a Symbolic.
Dave Harmacek - Harmacek Database Systems - near Boston, MA USA
At 09 JUL 2021 08:22PM Barry Stevens wrote:
In basic+ when i am doing a compare where this exists, or, when a "E" is in the key which is seen as exponential notation and thus does a numeric comparison. I do the comparison by forcing EQ to compare two strings. I add a "A" to each of the values during comparison. I know you want a SELECT but possibly this workaround will work in a Symbolic.
Dave Harmacek - Harmacek Database Systems - near Boston, MA USA
Is the 'key' field in the dict specified as alpha or numeric - try alpha