Welcome!

This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!

1

1
Álvaro Damas
Activé 14/05/2020 16:58

At this moment the function Agora is returning a DateTime, contrary to what is said in the function itself in Genio, return Text.

I suggest creating a function in Genio itself, e.g., TimeNow, and implementing it for C # and JavaScript. See images below.




Then you can call this function in the formulas to fill in the fields.


After Genio generates the code, there is a warning that the function is not implemented for Transact SQL.

warning: Function 'TimeNow' is not implemented for 'T-SQL' but used in formula 'formula' of table filed [HORAR->NOW].

This function should also be implemented. But in this case, as we are exemplifying filling in the interface, there is no calculation component on the server. That is, if we perform a database maintenance using WebAdmin, this field is not changed. If it were, there would be a need to create a function for T-SQL as well.



0
José Fonseca
Activé 14/05/2020 13:52

Hi Martins,

There a formula in Genio that returns the current time named Agora:


Hope this helps.


Keep Informed

About the Community

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

19 follower(s)

Stats

Asked: 14/05/2020 08:11
Seen: 1761 times
Last updated: 22/08/2020 15:40