Android Question RDC Table Name

[mmieher]

Is it possible to get the table name for the DBResult in JobDone?

 

[DonManfred]

Based on the fact that the sql-queries are stored in the config and you just use the name defined of the query. Der table is not visible. It can be anything what you define...
for ex: selectcustomer=Select * from mycustomertable......
You only know the name; selectcustomer
RDC does not know more. the name of the query is selectcustomer and the query is just send to the database and you´ll get the result returned

I dont think you can get the table in the result. Where should the value come from?

 

[OliverA]

Is it possible to get the table name for the DBResult in JobDone?

1) See @DonManfred's answer.
2) Why would this be needed?

 

[inakigarm]

1) See @DonManfred's answer.
2) Why would this be needed?

And 3) You can add the tablename on the query defined at RDC server config.properties (like sql.selectcustomer="Select 'mycustomers' as tablename, * from mycustomers")

 

[OliverA]

3) You can add the tablename

Yes, but this can get complex once more than one table is involved. For single table queries, that would be a solution (just remember this will return you result set size depending on number of records returned). Gotta love this forum.

 

[mmieher]

@myBuddyOliver -- "Why?"

I want to create a generic JobDone that I can use in multiple Apps. Basically, create and download an entire mySql database to DBUtils, then stop talking to the server until a refresh is needed. The mySql databases are not very large. Users are ReadOnly.

 

[OliverA]

I want to create a generic JobDone that I can use in multiple Apps

Is this JobDone for

Basically, create and download an entire mySql database to DBUtils

? If it is, I think you need more than table name, unless the structure is always the same (how else do you recreate the structure?) What am I missing here? You may need something like the output of sqldump so that you can recreate the database tables and load them will all the data. Or you create the necessary SQLite db file on the server and download the complete db file. Some people use CloudKVS to download SQLite db file in this manner.

 

[mmieher]

I am in 3rd grade compared to you guys, but it looks like I can get the column names and data types from DBResult. Table Name would be all I need? I have not used DBUtils yet but from all the posts I read I think it will do what I want. Thanks, Oliver.

 

[OliverA]

but it looks like I can get the column names and data types from DBResult

1) Duh (on my part)
2) Then I would go with @inakigarm's solution. If you are just dealing with one table that you are downloading, then the name should not be important (for a single table download per app) and you would not even need that solution.