dibesw Active Member Licensed User Longtime User Dec 2, 2013 #1 I wish read an access table e.g.: 1111 2222 3333 4444 5555 6666 If I must positioning a row, I do Code: Copy Table.Initialize(Access.GetTable("TABLE")) Index.Initialize(Table.GetIndex("PrimaryKey")) Cursor.Initialize(Table.GetTable, IndexEnt.GetIndex) CODE=2222 Cursor.FindClosestRowByEntry(Array As Object(CODE)) how do to read the next line? (3333,4444....) I tried Code: Copy Table.GetNextRow but does not work Any help? Thanks
I wish read an access table e.g.: 1111 2222 3333 4444 5555 6666 If I must positioning a row, I do Code: Copy Table.Initialize(Access.GetTable("TABLE")) Index.Initialize(Table.GetIndex("PrimaryKey")) Cursor.Initialize(Table.GetTable, IndexEnt.GetIndex) CODE=2222 Cursor.FindClosestRowByEntry(Array As Object(CODE)) how do to read the next line? (3333,4444....) I tried Code: Copy Table.GetNextRow but does not work Any help? Thanks
Erel B4X founder Staff member Licensed User Longtime User Dec 3, 2013 #2 I'm not really familiar with this library. Can't you read all the values and then find the matching value in your code? Upvote 0
I'm not really familiar with this library. Can't you read all the values and then find the matching value in your code?
dibesw Active Member Licensed User Longtime User Dec 3, 2013 #3 (Library is Jakccess.). Yes, if I start from first value I can read all values. But I have many records and whenever I must positioning from one of this and readnext. I have found FindFirstRow FindNextRow GetNextRow but but I did not find any example. I do not know what to do. Are still Upvote 0
(Library is Jakccess.). Yes, if I start from first value I can read all values. But I have many records and whenever I must positioning from one of this and readnext. I have found FindFirstRow FindNextRow GetNextRow but but I did not find any example. I do not know what to do. Are still
dibesw Active Member Licensed User Longtime User Dec 3, 2013 #4 I found it! correct is cursor.readnextrow not table.readnextrow Upvote 0
