E Elby dev Member Licensed User Longtime User Jun 3, 2020 #1 Now that Erel has told me not to use Tableview but B4XTable I had to rethink my project top level layout and the role of SQLite for basic tasks. Here are my thoughts. Any comments please. Perhaps a thought for others to do the same or comment especially with so many modules to do things. Thanks For utility tasks in the office I usually start with a data file/s from an ERP system ie data.txt. etc Project Flow I am thinking of: Data.txt (on Disk) | My Thought Note: This structure allows flexibility on Program Start with SQLite db instead of CSV files only (on Disk) List (memory) | SQLite DB & table (on disk)<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<Create/Replace Table from list<<<<<<<<<<<<<<<<<<<<<< | ^ Filter Above (memory) ^ | ^ List (Memory) ^ | ^ B4XTable (is like a memory SQL table) (memory <<< ^ | ^ ^ Do 'Things' what you like with the B4XTable object--^ or >>when done Create List (memory)>>>Save to CSV (disk)>>>Optionally>>List (memory)>>>
Now that Erel has told me not to use Tableview but B4XTable I had to rethink my project top level layout and the role of SQLite for basic tasks. Here are my thoughts. Any comments please. Perhaps a thought for others to do the same or comment especially with so many modules to do things. Thanks For utility tasks in the office I usually start with a data file/s from an ERP system ie data.txt. etc Project Flow I am thinking of: Data.txt (on Disk) | My Thought Note: This structure allows flexibility on Program Start with SQLite db instead of CSV files only (on Disk) List (memory) | SQLite DB & table (on disk)<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<Create/Replace Table from list<<<<<<<<<<<<<<<<<<<<<< | ^ Filter Above (memory) ^ | ^ List (Memory) ^ | ^ B4XTable (is like a memory SQL table) (memory <<< ^ | ^ ^ Do 'Things' what you like with the B4XTable object--^ or >>when done Create List (memory)>>>Save to CSV (disk)>>>Optionally>>List (memory)>>>
Erel B4X founder Staff member Licensed User Longtime User Jun 4, 2020 #2 B4XTable creates it own memory based database, so it doesn't matter too much where the data comes from. Upvote 0
B4XTable creates it own memory based database, so it doesn't matter too much where the data comes from.
E Elby dev Member Licensed User Longtime User Jun 4, 2020 #3 The B4XTable database will be gone when the program is finished is it not? . Also my thought is that if the incoming are multiple text files it be easier to bring them into a DB with tables to do the joining before presenting it to the B4XTable object. I suppose "many ways to skin a cat" Thanks Upvote 0
The B4XTable database will be gone when the program is finished is it not? . Also my thought is that if the incoming are multiple text files it be easier to bring them into a DB with tables to do the joining before presenting it to the B4XTable object. I suppose "many ways to skin a cat" Thanks
Erel B4X founder Staff member Licensed User Longtime User Jun 4, 2020 #4 Elby dev said: The B4XTable database will be gone when the program is finished is it not? Click to expand... Yes. Upvote 0
Elby dev said: The B4XTable database will be gone when the program is finished is it not? Click to expand... Yes.
