26 Reply by lejoso

(14 replies, posted in General)

Sorry.
I posted my question in my native language. Sorry.
Great, Derek! You saved my day once again.
I got the translation.
Thank you all for your collaboration.
Bet regards!

Go to forum: General

27 Reply by lejoso

(14 replies, posted in General)

Olá a todos.
Ainda não consegui.
A questão é o nome form 'Change your password'.
Esse que será apresentado para o usuário trocar a sua senha...

Go to forum: General

28 Reply by lejoso

(14 replies, posted in General)

  • Thank you CDB. I will look at the vk.com article.

  • jean.brezhonek i didn't create the form. As Derek said the function was implemented by Dmitriy therefore the difficulty.
    Many thanks for the reply.

  • Derek, I think I will have to do as you indicated, unless Dmitriiy makes the code available for change.
    Best Regards.

Go to forum: General

29 Reply by lejoso

(14 replies, posted in General)

Hello CDB
Thank you for your interest.

My question refers to the box that opens after selecting "Change your password"...

Thanks

Go to forum: General

30 Topic by lejoso

(14 replies, posted in General)

Hello everyone.

How to translate this form?

Thanks

Go to forum: General

31 Reply by lejoso

(8 replies, posted in General)

Hello Dmitry.

Congratulations on the new version of MVD.
I have version 4.6 installed.
I would like to try version 6 but the program says my trial period is over ...
How can I test this new version?

Thanks

Go to forum: General

32 Reply by lejoso

(17 replies, posted in General)

Hello friends.
I was able to solve my problem:

concat(
  concat(
    concat(
      concat(
        concat(
          concat(
            concat(
              concat(
                concat(
                  concat(
                    concat(
                      concat(
                        concat(
                          concat(
                            concat(
                              concat(
                                concat(
                                  concat(
                                    concat(
                                      concat(
                                        concat(
                                          concat(
                                            cast(ifnull((
                                              select cid_a.cid_num
                                              from cid_a
                                              where cid_a.id = bienal.id_cid_a
                                            ), '') as char), 
                                            ' '
                                          ), 
                                          cast(ifnull((
                                            select cid_a.cid_num
                                            from cid_a
                                            where cid_a.id = bienal.id_cid_a1
                                          ), '') as char)
                                        ), 
                                        ' '
                                      ), 
                                      cast(ifnull((
                                        select cid_a.cid_num
                                        from cid_a
                                        where cid_a.id = bienal.id_cid_a2
                                      ), '') as char)
                                    ), 
                                    ' '
                                  ), 
                                  cast(ifnull((
                                    select cid_a.cid_num
                                    from cid_a
                                    where cid_a.id = bienal.id_cid_a3
                                  ), '') as char)
                                ), 
                                ' '
                              ), 
                              cast(ifnull((
                                select cid_a.cid_num
                                from cid_a
                                where cid_a.id = bienal.id_cid_a4
                              ), '') as char)
                            ), 
                            ' '
                          ), 
                          cast(ifnull((
                            select cid_a.cid_num
                            from cid_a
                            where cid_a.id = bienal.id_cid_a5
                          ), '') as char)
                        ), 
                        ' '
                      ), 
                      cast(ifnull((
                        select cid_a.cid_num
                        from cid_a
                        where cid_a.id = bienal.id_cid_a6
                      ), '') as char)
                    ), 
                    ' '
                  ), 
                  cast(ifnull((
                    select cid_a.cid_num
                    from cid_a
                    where cid_a.id = bienal.id_cid_a7
                  ), '') as char)
                ), 
                ' '
              ), 
              cast(ifnull((
                select cid_a.cid_num
                from cid_a
                where cid_a.id = bienal.id_cid_a8
              ), '') as char)
            ), 
            ' '
          ), 
          cast(ifnull((
            select cid_a.cid_num
            from cid_a
            where cid_a.id = bienal.id_cid_a9
          ), '') as char)
        ), 
        ' '
      ), 
      cast(ifnull((
        select cid_a.cid_num
        from cid_a
        where cid_a.id = bienal.id_cid_a10
      ), '') as char)
    ), 
    ' '
  ), 
  cast(ifnull((
    select cid_a.cid_num
    from cid_a
    where cid_a.id = bienal.id_cid_a11
  ), '') as char)
)

Go to forum: General

33 Reply by lejoso

(17 replies, posted in General)

Hello sibprogsistem, thezimguy and ehwagner.

Thank you so much for your interest in helping.
I will test the suggestions in my project and as soon as possible I will give an answer.

Thanks

Go to forum: General

34 Reply by lejoso

(17 replies, posted in General)

Hello everyone.

Could someone tell me why this code does not work on MySql?

Thanks a lot.

ifnull((SELECT cid_a.cid_num FROM cid_a WHERE cid_a.id=bienal.id_cid_a),'')||' '||     
ifnull((SELECT cid_a.cid_num FROM cid_a WHERE cid_a.id=bienal.id_cid_a1),'')||' '||   
ifnull((SELECT cid_a.cid_num FROM cid_a WHERE cid_a.id=bienal.id_cid_a2),'')||' '||    
ifnull((SELECT cid_a.cid_num FROM cid_a WHERE cid_a.id=bienal.id_cid_a3),'')||' '||    
ifnull((SELECT cid_a.cid_num FROM cid_a WHERE cid_a.id=bienal.id_cid_a4),'')||' '||    
ifnull((SELECT cid_a.cid_num FROM cid_a WHERE cid_a.id=bienal.id_cid_a5),'')||' '||    
ifnull((SELECT cid_a.cid_num FROM cid_a WHERE cid_a.id=bienal.id_cid_a6),'')||' '||    
ifnull((SELECT cid_a.cid_num FROM cid_a WHERE cid_a.id=bienal.id_cid_a7),'')||' '||            
ifnull((SELECT cid_a.cid_num FROM cid_a WHERE cid_a.id=bienal.id_cid_a8),'')||' '||    
ifnull((SELECT cid_a.cid_num FROM cid_a WHERE cid_a.id=bienal.id_cid_a9),'')||' '||    
ifnull((SELECT cid_a.cid_num FROM cid_a WHERE cid_a.id=bienal.id_cid_a10),'')||' '||   
ifnull((SELECT cid_a.cid_num FROM cid_a WHERE cid_a.id=bienal.id_cid_a11),'')

Go to forum: General

35 Reply by lejoso

(17 replies, posted in General)

Hello Derek

I understand.
I will continue searching the forum for a solution.
Thank you very much.

Best Regards

Go to forum: General

36 Reply by lejoso

(17 replies, posted in General)

Hi Derek.

I can't get the same result as the calculated field "cfcidsearch" in MySql.
Is there anything I can do?
Thanks.

Lejoso

Go to forum: General

37 Reply by lejoso

(17 replies, posted in General)

Hello sibprogsistem

I did not understand...
Thank you anyway

Go to forum: General

38 Reply by lejoso

(17 replies, posted in General)

Hello Mr. Derek

Thanks again.
It's perfect ... and the script you put in got even better.
My users and I appreciate it.

Best regards

Go to forum: General

39 Reply by lejoso

(17 replies, posted in General)

Hello again Mr. Derek

I have a new problem. I need the CID field lookup to return me exactly the code described, for example R63.
But the search also returns other records that have R63, such as R635 ...
Unfortunately I need the value to be exact.
See in the picture.
It's possible?

Thank you very much.

Go to forum: General

40 Reply by lejoso

(17 replies, posted in General)

Hi Mr. Derek
Thank you very much for welcoming my project.
The correction is perfect and meets exactly what I need.
As for your questions:
1. It was a slip of mine. As I am new to MVD I sometimes make these mistakes.
2. I tried to do it this way, but couldn't make a TableGrid compatible with the need for my project. I know there is a more coherent form and at some point I will find it.
3. Users register according to a previously completed form.

I have noticed in many projects that “Calculated Field” solves most of MVD users' problems. It really is very powerful and makes the script cleaner.
If possible, I would like you to give me a place or a way for me to study this tool further.
Sorry for English, my language is Portuguese and I am using Google Translator.
Again my thank you very much.

Go to forum: General

41 Topic by lejoso

(17 replies, posted in General)

Hello everyone.
Could someone tell me why the search button stops working when I do a search using the "CID" field.
Project attached.
Thank you very much.

Go to forum: General

42 Reply by lejoso

(5 replies, posted in Russian)

Hello friends

It happened to me today.
Could someone describe me the solution?

Thanks

Go to forum: Russian

43 Reply by lejoso

(3 replies, posted in General)

Hello Mr. Dmitry. Did you open the file?

Go to forum: General

44 Topic by lejoso

(3 replies, posted in General)

Hello everyone.
I created several tables for the same data type, from "cid_a" to "cid_j".
They have the same records (12,438 each table) so that each record chosen is in a specific column in the Tablegrid.
For this I am using 10 Comboboxes, each directed to one of these specific tables.
It works for me but I'm trying to do it in an easier way.
Can I use only one table to populate the columns?

Go to forum: General

45 Topic by lejoso

(1 replies, posted in General)

What about versions 4.7, 4.8 and 4.9?

Go to forum: General

46 Reply by lejoso

(13 replies, posted in General)

No problem. Thanks for trying.
I'll look for another way.

Go to forum: General

47 Reply by lejoso

(13 replies, posted in General)

Hello Mr. Dimtry
Unfortunately I am not able to implement the report in my project with this example.
Was there any other in the forum?
Thanks

Go to forum: General

48 Reply by lejoso

(13 replies, posted in General)

Thank you, Mr Dmitry.
I will try to adapt it to my project. I think it will work.
Best reggards

Go to forum: General

49 Reply by lejoso

(13 replies, posted in General)

Hello, Derek and Ehwagner.
I am not able to report with GROUP BY of proc.
Is there any example in the forum that I can follow?
Thank you

Go to forum: General

50 Reply by lejoso

(13 replies, posted in General)

Hi ehwagner
Many thanks for this tip. Now it works the way I wanted it to.
thankful

Go to forum: General