Android Question Insert SQL string in config.properties file automatically

Erel said:

Check the code in RDCConnector. The RDCHandler calls its GetCommand to get the SQL command.

Click to expand...

Public Sub GetCommand(Key As String) As String
    Key = "Get_Daily_Report = SELECT * FROM Visits_Table"
    If commands.ContainsKey("sql." & Key) = False Then
        Log("*** Command not found: " & Key)
    End If
    Return commands.Get("sql." & Key)
End Sub

1. Now does this mean I must not include SQL commands in config.properties?
2. Or can I include fixed ones and only dynamic ones in Public Sub GetCommand?
3. What if I have more than one dynamic SQL string?
4. Also, will it work if I add the SQL strings in a CSV file and place it in the same folder as config.properties, which will be on the VPS? Referenced in LoadConfigMap sub?

aeric said:

I see you are making thing more and more complicated. Why you want to make every user has his own table?

Click to expand...

1. Employee table
2. Devices table
3. Reports table
4. Assets table
5. Visits table

Setlodi said:

Not every user will have their own table but companies that have purchased devices. This is an app on a specific device that will allow companies to have the following tables, specific to them:

1. Employee table
2. Devices table
3. Reports table
4. Assets table
5. Visits table

Every company that buys devices the system will create the tables when they 'Activate'. All the devices that the company has purchased will be stored in the devices table together with their serial numbers, device ID, OS version as well as my app version. The users of the devices will be in the employee table, with the employee details including usernames and passwords for logging into the app. Basic information will be captured in the management app which is a B4J application. As "visitors" visit the company premises, they are recorded and all the assets that they receive are stored in assets table using the device with B4A app. Managers will be able to log in the management app and generate reports for visitors who entered the company premisses, the assets that they have received, the employee that assisted them, etc.

Click to expand...