Not allowing users to edit/delete other records
Hi is there a way of not allowing someone else to edit or delete a record without permission? Thanks Cory
Removing Public Database from my account listings
In trying out Zoho DB, I added a public database to my "listings." I'm now not able to remove it. It continues to show in "Recent Items". Is it possible to clear that listing?
Integration of databse with zoho
Hi, How to integrate database with zoho for getting multi user support.
Using INNER JOIN to link related tables
Has anyone managed to get a query using INNER JOIN to work correctly? Every time I introduce a field from another table into a query, I get an SQL parsing error. I am using (I think) pretty standard dialect SQL: tablename."Fieldname" and SELECT t1.f1, t1.f2, t1.f3, t1.f4, t2.f1, t2.f2 FROM t1 INNER JOIN t2 ON t1.f1=t2.f1;< br/>< br/> I have managed to create a join using the following: SELECT Staff."FirstName",Staff."Surname",Role."Position" FROM Staff,Role WHERE Staff."RoleID"=Role."PositionID";
Mask on Date fields
Hi; Is it possible to display date fields in differents Formats (YYMMDD or YYYYMMDD, or else ....) I didn't find this capability in this current version of this DB. Regards
relative time
When filtering the graphs relatively by time I selected last 1 hour. It shows a time 3 hours before, in my case would UTC/GMT. Is there a setting for time zone for the DB.