Topic: Calulated field
Hello everyone
Can you tell me why the calculated field is not working in
Re: Calulated field
Hi Abdou,
A little more information is required if someone is to help you.
Calculated field is not working with what formula?
Please post the fields you are trying to use and the result that you are looking for.
Attaching the project would be useful as well.
On a clear disk you can seek forever
- k245
- Member
- Offline
Re: Calulated field
More details about calculated field in My Visual Database - https://k245.ru/en/mvdb-en/using-sql-in-mvdb.html
Визуальное программирование: блог и телеграм-канал.
Re: Calulated field
In the report sql when fetching fields it is not acceptable to have a calculated field
- k245
- Member
- Offline
Re: Calulated field
abdou88 wrote:
In the report sql when fetching fields it is not acceptable to have a calculated field
That's right. Calculated fields are an internal MVDB mechanism that are used when setting up tables and other UI elements. If you use SQL queries to retrieve data (including for reports) and want to get a result similar to that obtained when using calculated fields, then you need to include the code for the calculated fields directly in your SQL query.
Визуальное программирование: блог и телеграм-канал.
Re: Calulated field
hi K245
Thank you very much for the clarification, I understand.