Android Question Record not found (jackcess)

[dibesw]

This code works well if cursor found any records.

Dim IndVal As Object
Dim targetDate As Long = DateUtils.SetDate(2013, 6, 1)

Table.Initialize(Access.GetTable("TAB"))
Index.Initialize(TableEnt.GetIndex("CODE_DT"))
Cursor.Initialize(TableEnt.GetTable, IndexEnt.GetIndex)
IndVal=targetDate
Cursor.FindClosestRowByEntry(Array As Object(IndVal))
Do Until CursorEnt.IsAfterLast
      .....
      (If condition Then Exit)
      .....
      CursorEnt.GetNextRow
Loop

But if cursor does not find any record (no records >= CODE_DT)
Cursor.FindClosestRowByEntry(Array As Object(IndVal))
have immediatly this error:

I have need read this table with >=
and then to do readnext.
Can anyone help me who has had experience with jackcess?

 

[Erel]

What is the value of IsBeforeFirst at that point?

 

[dibesw]

I modified the code

Dim IndVal As Object
Dim targetDate As Long = DateUtils.SetDate(2013, 6, 1)

Table.Initialize(Access.GetTable("TAB"))
Index.Initialize(TableEnt.GetIndex("CODE_DT"))
Cursor.Initialize(TableEnt.GetTable, IndexEnt.GetIndex)
IndVal=targetDate
Cursor.FindClosestRowByEntry(Array As Object(IndVal))
Msgbox(CursorEnt.IsBeforeFirst,"")
Msgbox(CursorEnt.IsAfterLast,"")
Do Until CursorEnt.IsAfterLast
      .....
      (If condition Then Exit)
      .....
      CursorEnt.GetNextRow
Loop

when give error I press button YES (continue yes)
but not have msgbox

 

[dibesw]

Can I post my code?

 

[Erel]

Which error do you get? You should post it from the logs.

 

[dibesw]

I thing that is a Jackaccess bug.
I post my code (with mdb access).
In the code there is a test.
Try...

Dim targetDate As Long = DateUtils.SetDate(2013, 6, 1)

Program read a table with key >= DATE
This test (targetDate=2013/6/1) works well.

If you try targetDate=2013/7/1 (or major) that not exits, program give this error

THANKS!!

 

[Erel]

You can use Try / Catch to catch this error.

 

[dibesw]

I'm sorry, but I do not understand.
You can try the program that I post?

 

[Erel]

Please use File - Export as zip and upload the zip file.

 

[dibesw]

Ok, I do it

 

[Erel]

What are the steps to reproduce the error?