B4A Class TD_Recordset the Resultset alternative

Name: TD_recordset
Type: Custom B4A Class (b4xlib)
Version: 1.0
State: Testphase
Licence: free for personell use, free for commercial use after donation.

Download here

TD_Recordset is a custom class that allows you to store and manage selected data from an SQLite or SQLCipher database.

TD_Recordset is an alternative to using the B4X SQL result set and provides significantly more data management functionality. Like the result set , the recordset is a database-independent object. The database serves merely as a data provider.

The recordset consists of records . Each record contains data columns. The data columns are identified by a column name and have the object data type; therefore, they can contain all database data types (text, numeric, blob).

The position of a record ( record pointer ) is determined by its location in the recordset . When the recordset is sorted or reordered, the record receives a new position number. The position number is therefore not identical to the RowID of a database table.

Administrative functions:

• Load data from the database and save it in the recordset .
• Add, Update, Delete Data in the recordset without the need to reload it.
• Recover deleted data.
• Sort the recordset data based on a column value.
• Find a record based on a column value.
• Jump to a specific record position.
• Convert the recordset to a list, e.g. for loading a B4XTable .

Information functions:

• Number of records in the recordset .
• Number of columns in a record.
• List of column names of a record.
• Value of a specific column
• Retrieve columns and values of the current record.
• Last used SELECT command and its arguments.
• Current record pointer position.
• List of deleted records.

---

I tested the Recordset with a manual load of 10.000 Records (one numeric Column) and the loading time was less a second. I please you to do some more testing as well and reporting any error or whishes to me as reply to the post.
Please find a detailed manual in the Documents Folder of the Example project.

 

[Sandman]

free for commercial use after donation

What does this mean? Isn't that just a sale?

 

[Guenter Becker]

It means what it says. There are a couple of professionals in this forum who are investing much time and knowledge to produce good additional libraries a.s.o. A donation has nothing to do with the sale! It is only to pay of a small fee to respect the work others do. Most of the developers of this forum will often give there work away for free but there may be some cases where they also request a donation for there work. In the past I did it as well but in the meantime I changed my mind and my license for commercial usage. I think it is not a correct way of respect to use foreign work for free in commercial work where they get money for.

 

[Sandman]

I have zero issues with you (or anyone else) requesting money for work done. I'm just amused by the fact that you require a "donation". A donation is a voluntary gift. If you require something for your product, then it's not a donation. Then it's a price, as part of a sale.

However, it's not really related only to you, it's been done like that for ages on this site. I suppose it's just a method to avoid paying taxes, or something like that.

Don't mind me, I was just curious. Best of luck with your "donations".

 

[aeric]

It may not a good place to discuss this here, probably a better place is Chitchat.

@Sandman first, I want to let you know I am not against you but I want to express my point here.

I'm just amused by the fact that you require a "donation".

For me, any library developer can make a request.
But not every request is getting fullfil or respected.
Most people will just ignore all of them. It is sad to hear most of the time.

A donation is a voluntary gift.

Yes, the word donation in this forum for getting a library or other work seems not very accurate. It has been discussed before. I would say it is better to call it a "token of appreciation", "coffee", "beer" (may sounds not halal for Muslim) or in Chinese a "red packet".
This small amount of money will not make someone a fortune.

If you require something for your product, then it's not a donation. Then it's a price, as part of a sale.

From the perspective of the people who like to take things for granted, this is a big cost. They never understand the effort someone has put to produce the work.
From the perspective of the author, he is offering a product which worth thousands or millions times the value of a coffee.

Time = Money.
Many people don't get it.
Skill = Money.
Both add up will save someone lot of money and time.
If you paid an experience developer salary to produce the work, it may take like 2 months salary to do R&D, bugs fixes, QA and management which translated to 4 to 5 grands.
When someone take it, it is just take him a few seconds.
If the piece of code is useful in commercial, it can make him a fortune to earn thousands time or more.
At the end, the original author is gaining nothing at all.

it's been done like that for ages on this site. I suppose it's just a method to avoid paying taxes, or something like that.

Yet, many still don't see and understand the meaning behind.
I think because some people never make donations.
I started making donation to even code that I don't use anywhere, personally nor commercially.
For me, I want to encourage the author to continue doing more.
In fact, sometimes I am getting back the same donation by someone else in the future.
This is how the donation cycles through a chain in this forum.

Another thing is not every member here is rich. Someone like me has not yet retired but still struggle to make ends meet. We still spend our time to earn for a living.

This is totally not a way to avoid tax. I am totally disagree with this mindset.

For example, when someone make a PayPal donation of $5, I only received $3.50 and in one donation last time, $10 become $5 depends on the country of the original donor.

Tl;dr a "donation" is a meaning to encourage the author to continue his great work.
It is same as donating to Anywhere Software to continue it's development.

 

[TILogistic]

It means what it says. There are a couple of professionals in this forum who are investing much time and knowledge to produce good additional libraries a.s.o. A donation has nothing to do with the sale! It is only to pay of a small fee to respect the work others do. Most of the developers of this forum will often give there work away for free but there may be some cases where they also request a donation for there work. In the past I did it as well but in the meantime I changed my mind and my license for commercial usage. I think it is not a correct way of respect to use foreign work for free in commercial work where they get money for.

I completely agree with you, which is why I'm no longer publishing the code. I offer guidance to those interested and other members who have asked me internally how to develop it.

 

[Mashiane]

Hi

Is this still avaialable?

 

[Guenter Becker]

Hello,
If you like to get it I will look if there is a copy in my repositiory.
Yet I am delevloping a B4X lib B4XUtils2 that is an extension of the standard B4XUtils Features including the TD Recordset functionality. At the moment I am hard working to get my WIndows AppInstaller Application Project to the end and that binds all free ressources. Therefore it will take some time to come back to work on B4XUtils2.

 

[Guenter Becker]

Hello,
I'm sorry but due to a drive crash I lost my older work including TD_Recordset. But I think at least after summer time I will finalize the B4XUtils2 = extB4xUtils. AS a Preview what is in the Pipeline of my WIP see here: