You cannot unless you first load the data in a database. You can use a temporary in memory database like this:
fields = [Field('one'), Field('two'), Field('three'), ...] temp_db = cache.ram('tmp_db',lambda: DAL('sqlite:memory').define_table('mytable',*fields)._db, None) temp_db.mytable.truncate() temp_db.mytable.insert(....) form = SQLFORM.grid(temp_db.mytable) On Sunday, 8 September 2013 05:35:13 UTC-5, Gliese 581 g wrote: > > Hi Massimo, > I will try to be more specific. > I am developing a web2py application(APP1) which works on the data which > it gets from another web2py application(APP2). > We do not have access to the database of APP2, we access their data > through jsonrpc web services exposed by APP2. > Now, there is an API(get_objects) of APP2 which gives us a list of certain > type of objects. APP2 internally fetch this data from its database and > convert it to a list of specific type of objects. > I want it to be displayed in a table with sorting and paging capabilities. > Can I use web2py's SQLFORM.grid to achieve this? > Please suggest me any solution. > > Thank you. > > On Friday, 6 September 2013 20:26:54 UTC+5:30, Gliese 581 g wrote: >> >> ** >> >> I am working on a project where we have a different subsystem whose API >> returns a list of certain type of objects. >> >> I want it to be displayed on my form. Can I use SQLForm.grid for this? >> Please suggest. >> > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.