B4J Question DBUtils Replace All Fields With Record Number

[almontgreen]

Very much beginner, so thank you for any help...
I need to understand how to replace each field in a database with a record number that's based upon how the database is sorted. With dBase or something like that you'd just use REPLACE ALL [FIELD] with RECNO()

It appears a much more daunting task with B4J DBUtils...

Indeed, stepping through the records in a SUB and processing the fields seems difficult to me, argh! Nothing like dBase or FoxPro...

I've made some progress, but having a tough go.

 

[Erel]

It appears a much more daunting task with B4J DBUtils...

DBUtils is a set of helper methods. You are not limited to these methods. You can execute any valid SQL statement that you like.

SQLite adds an id field automatically named rowid. You can probably use it instead.

 

[almontgreen]

DBUtils is a set of helper methods. You are not limited to these methods. You can execute any valid SQL statement that you like.

SQLite adds an id field automatically named rowid. You can probably use it instead.

I need to modify a record number field for a given sorted list to export. I'll dig into SQL and learn. I'm amazed at what I've been able to achieve so quickly! B4J and B4A are tremendous RAD tools that I am happy to support! I just wish I could learn faster ;^)

I think it might be possible to write a dBase like application with B4J but that is beyond my pay grade for now.