It's working when I give table_name after getting table object programatically, but when the same syntax is used for column names in update statement it returns syntax error; please consider the following statement: *db((db[table_name].id == rowid) & (db[table_name][myfld] == "")).update( [myfld] = myvalue)*
thanks On Thursday, 27 December 2012 19:41:45 UTC+5, Anthony wrote: > > * > db(db[tname].id <http://db.tname.id/> == rowid).select() > > *or just: > > db[tname](rowid) > > Anthony > > On Thursday, December 27, 2012 9:35:55 AM UTC-5, at wrote: >> >> >> Wanted to avoid hard-coding table name in the following statement by >> using var *tname*, but not successful: any tip pls? >> *db(db.tname.id == rowid).select* >> >> Thanks >> >> On Thursday, 27 December 2012 19:10:31 UTC+5, at wrote: >>> >>> gr8! >>> *tname,z=my_rows.colnames[0].split('.')* gave the desired table name >>> >>> thanks very much! >>> >>> best regards >>> >>> On Thursday, 27 December 2012 18:47:07 UTC+5, Massimo Di Pierro wrote: >>>> >>>> Yes and No. You can get rows.colnames and they contain table names . >>>> field name >>>> >>>> On Thursday, 27 December 2012 07:45:52 UTC-6, at wrote: >>>>> >>>>> >>>>> How can we get table name from ROWS object? >>>>> >>>>> Thanks >>>>> >>>> --