Hi Kevin,
>> So i make a sub set of data from my server's database in say an imdb "Bruce"
This is not the approach I would use.
Basically I would just add a filter to the NetWebService Method, Return View, based on whatever filter was appropriate. For example;
a) Customers table. Customer is Added by a specific salesman. Only that Salesman can read and write that record.
So added a User field to Customer, simple filter on Customers table, cus:user = p_web.GSV('user')
b) Products are assigned to specific salesmen. some sell A and B, some C and D some B and C.
So we need a table (Allocated) which basically creates a multi-multi link between Salesmen and Products. (Say, Salesman, Product, Allowed). Then the View in the WebServiceMethod joins to the Allocated table, and only exports records where Allowed = true.
>> How do I get it to the device? Can I make a Sql Lite db and send that to the device? Do you have provision for this?
no. We're not talking about "databases" here, we're talking about "data". Assuming that the device supports SQLite for example reduces the options etc. The idea is to think about "data" rather than "the data store". Let each platform choose whatever datastore is appropriate for that platform. The _transfer_ of the data is completely independent of the data store.
Cheers
Bruce
Topic: NT9 Apps - sending data (Read 3895 times)