B4J Question closes programming style

[michaelleewebb]

been writing in vba (msaccess) for over 20 years, i have a "style" i like to use. can someone point me to a class ? lib ? sql lib ? that would allow be to continue using something like the same style? below is an example of me using my style to "edit","delete" or update a record , i'm looking at b4xtable at the moment.

'EDIT RECORD
Set MyDB = OpenDatabase(Mydatabase)
Set MyTable = MyDB.OpenRecordset("citytbl", DB_OPEN_TABLE)

MyTable.MoveFirst   ' Locate first record.
Do Until MyTable.EOF    ' Begin loop.
    If MyTable!Zip = Val(Me.Combobox45) Then   
        MyTable.edit       
        MyTable!City = "NewYork"
        MyTable.Update
        Exit Do
    End If
    MyTable.MoveNext    ' Locate next record.
Loop                            ' End of loop.
MyTable.Close           ' Close table.
MyDB.Close              'close database

'DELETE RECORD
Set MyDB = OpenDatabase(Mydatabase)
Set MyTable = MyDB.OpenRecordset("citytbl", DB_OPEN_TABLE)

MyTable.MoveFirst   ' Locate first record.
Do Until MyTable.EOF    ' Begin loop.
    If MyTable!Zip = Val(Me!Combo599) Then   
        MyTable.Delete       
    End If
    MyTable.MoveNext    ' Locate next record.
Loop                            ' End of loop.
MyTable.Close           ' Close table.
MyDB.Close              'close database

'ADD RECORD
Set MyDB = OpenDatabase(Mydatabase)
Set MyTable = MyDB.OpenRecordset("citytbl", DB_OPEN_TABLE)
dim MatchFound as bool = False
MyTable.MoveFirst   ' Locate first record.
Do Until MyTable.EOF    ' Begin loop.
    If MyTable!Zip = Val(Me!Combo599) Then   
        MatchFound = True
        Exit Do
    End If
    MyTable.MoveNext    ' Locate next record.
Loop                            ' End of loop.
if Matchfound = False then
        mytable.Add
        mytable!City = "New York"
        mytable!zip = "1111113"
        mytable.UpDate
End if
MyTable.Close           ' Close table.
MyDB.Close              'close database

 

[Erel]

I'm not sure what you are looking for. Making B4XTable an editable table is not trivial.
This class will help you: InlineEditing - extends B4XTable with inline editing features

 

[aeric]

Maybe this is what you are looking for

SQL Tutorial

B4J jSQL library is similar to Basic4android SQL library. This tutorial will cover the differences between the two libraries. You can read more about the library methods here: http://www.b4x.com/android/forum/threads/sql-tutorial.6736/#content jSQL library is not tied to any specific SQL...

www.b4x.com