Ricky D Well-Known Member Licensed User Longtime User May 7, 2012 #1 I have a simple app testing out my idea of a simple database. I am using a code module that holds the tables in arrays. The problem arises when I add a new entry then immediately add another the internal array gets screwed up. I have no idea what's causing it. I've tried coding this with lists but it does the same :BangHead: Attached is the simple project. Any ideas? regards, Ricky Attachments mydbrafarrays.zip 10 KB · Views: 320
I have a simple app testing out my idea of a simple database. I am using a code module that holds the tables in arrays. The problem arises when I add a new entry then immediately add another the internal array gets screwed up. I have no idea what's causing it. I've tried coding this with lists but it does the same :BangHead: Attached is the simple project. Any ideas? regards, Ricky
Erel B4X founder Staff member Licensed User Longtime User May 7, 2012 #2 I recommend you to use DBUtils. You can then work with tables using DBUtils.ExecuteMemoryTable. Upvote 0
Ricky D Well-Known Member Licensed User Longtime User May 8, 2012 #3 I found the problem. The fix is to dim a variable then assign the one in db to it. I do that when I use Add, Update & Delete. I use lists to keep the data & using random files to persist the data. I'll code it for my application and see how it goes. Regards, Ricky Upvote 0
I found the problem. The fix is to dim a variable then assign the one in db to it. I do that when I use Add, Update & Delete. I use lists to keep the data & using random files to persist the data. I'll code it for my application and see how it goes. Regards, Ricky