SQL statements in Zoho
SQL statements in Zoho
I am now beginning to understand Zoho a little better. Obviously there is some sort of database in the background that is at work when we use a Zoho app we have created.
1) Is there any way to have access to the database for my app through SQL statements either to execute some sort of transactional statement or statements? Ex. "Update mytable join mytable2 on . . . set myfield=1, myfield2 = 2 . . . where . . ." "Create table . . . " Etc. In some of these cases we would need to know to to access table keys.
2) Can I create a complex recordset to display in a view using an SQL statement with joins, conditions, etc?
3) Export data using SQL syntax . . . "drop table . . .", "create table . . .", "insert . . ."
I have seen from prior inquiries that this may not be possible at this time, but just asking for an update.
Thanks for reading!
David