Most annoying problem

[Ricky D]

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]

I recommend you to use DBUtils. You can then work with tables using DBUtils.ExecuteMemoryTable.

 

[Ricky D]

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