Have followed Javier's hints to edit view of staffviewposition by applying security to the invoker instead of the definer. But still unable to solve the problem ie unable to fetch view data. see http://www.bbrclubhk.com/testdb/testdb.html as compared to the one in another web hosting service provider that works. http://www.bbrchk.com/testdb/testdb.html
Tried to enable DB query log but the web hosting provider disallow me to do so because the service provided is a shared web hosting server which enabling DB query log is prohibited. Still stuck with the problem of fetching view data. Any suggestions welcomed. Regards, David -- Sent from: http://apache-flex-users.2333346.n4.nabble.com/