To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
The technical storage or access that is used exclusively for statistical purposes.
The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Hi,
thanks for fabules work you share with us. I bought premium counting for more great features in the future 😉
I have a question regarding functions, procedures and views.
Is there any way to strore and exec procedures and fucntions in your plugin?
For example I would like to have procedure that add records (with random data) to multiple tables I have created at same time. Just for populating them.
Same for functions. Creating scalar functions would be useful for me.
And views. I like to have view with single row from many tables and use this view to build table on my site.
Is this all possible?
regards
Hi Zielony,
You can create and use database triggers, functions, procedures and views. You just have to do it manually.
You can for example create a procedure directly from the Data Explorer. Just create a SQL script file and click on button “Import data/Execute script(s)” to execute your script file.
Please keep in mind that you need to follow the plugin guidelines for your SQL script. Every SQL statement has to end with a ; and a new line. For procedures containing SQL statement in their body, just add a space behind the ;.
For example:
create procedure myproc()
begin
insert into mytable values(‘myvalue’);[make sure to add a space here]
end;
You can execute a procedure in the same way or from a filter or action hook.
Does this help?
Peter
Hello,
In that exemple, if I delete a department in the depatments table, does this depatment is deleted too in field department of the employee table ?
Hi François,
This depends on the table definitions. The user can use foreign key constraints to protect relationships. In that case it will not be possible to remove a child row if it still used in the parent table. But this is handle on DBMS level, not in our plugin.
Hope that helps! Let us know if you have other questions.