776

(9 replies, posted in Script)

Ok, so waiting for the possibility to auto execute a custom sql query in grid for a future release, how should I write this in my project?

procedure Form1_onShow (Sender: string; Action: string); //display form containing


this is the query which works great with a button:

SELECT *
FROM
(
   SELECT 'Nb Ready'  as "Status", COUNT(id)  AS Count FROM computers where id_status="3"
  UNION ALL   
  SELECT 'Nb Defect'  as "Status", COUNT(id)  AS Count FROM computers where id_status="2"
   UNION ALL
  SELECT 'Nb To be Restaged'  as "Status", COUNT(id)  AS Count FROM computers where id_status="4"

) temp

The funny thing is that the grid refreshes automatically when I change the status of a record, would it be possible to initiate this refresh when loading the form and hide the button?

777

(9 replies, posted in Script)

So, how could we create a counter which can filter specific informations?


for example:

I would like a small box which displays automatically a count of number of pc with status "Ready" and/or "To be Restaged"

I did not find yet a simple way of doing this and it really bothers me to add a button with such a query :

select count(id) as "Ready" from computers where id_status="3"
select count(id) as "To be Restaged  from computers where id_status="4"

Next step would be to change the background of the cell depending of the returned value... roll

778

(5 replies, posted in General)

Fantastic, it looks much more professional now with these text hints!!

Thanks Dmitriy!!

779

(17 replies, posted in Script)

That's great, thanks a lot!

780

(17 replies, posted in Script)

Actually there is no way to tell the checkbox which value to display!
I will send you the project, it is still in draft.


Oh! I can see the attachments option now! smile

I have a special request for you smile

I am looking for a way to display a name in a combo box so everyone knows what this combo box contains instead of adding a text beside like for a button.

For example:

In the attached screenshot, I would like to display the name of the comboxbox inside the combo by default and then, when a choice is made, it should display the chosen value.

if no value chosen then display: IMG

IMG list = 203.1
                202.2
                204.0

if IMG value 203.1 chosen, then display: 203.1


I would be great if we could do the same in the textbox component!

if no value in textbox, then display textbox name
if value in textbox, keep this value tongue

782

(17 replies, posted in Script)

I would like to see the translated data in the grid. I cannot add a picture in this forum as there is no "download picture" choice.

for example:


I want to return the following information in a grid with a default query using no filter nor script:


PC Name  |  Installation Date   |  Config Record created

L2006       |   24.01.2014          |    Yes
L2007       |   24.01.2015          |    No



What I get currently is:

PC Name  |  Installation Date   |  Config Record created

L2006       |   24.01.2014          |    1
L2007       |   24.01.2015          |    0

783

(17 replies, posted in Script)

0 & 1 are working fine, that's right. But I would like to see words instead of 0 or 1 if I request this information.


For example, I would like to display "No" instead of "0" and "Yes" instead of "1". Using checkboxes this way may give more sense.

It is actually translating a value by a more readable one for the users.

How would you do that?

784

(9 replies, posted in Script)

Aaaaaah!!! Well actually I misunderstood the use of this component.

I thought it was there to give the ability to count rows like a "select count(*) where...." but here it is just displaying an value in a row.

I wish I could do that actually, it would be helpful in my current project, I would like to have a counter which displays the number of rows containing a given information.

785

(1 replies, posted in General)

I found some smal bugs in 1.48

- If you create a form and dispose all your components the way you want, you may not bring to the front the "TextBox" component after having added a panel which you bring to back. This is somehow annoying when you change your mind during the design.

I have exaggerated the effect in the attached screenshot to spot it. (my panel is not green ! lol )

- The component "Counter" counts nothing!

- The component "Checkbox" has a property "FieldName" which cannot be chosen. You can choose the Tablename though... (giving him a property value=" "  if checked would be great)

786

(17 replies, posted in Script)

I would need some help with another use of the checkbox component:

I have a field with a default value= "NO"

If I check the checkbox, I would like this value to be updated to "YES", is that possible or should I use a dropdown list?

787

(9 replies, posted in Script)

In the video linked here, there is nothing about the counter component!

Is it possible to script the component so it would count exactly what we want?

788

(24 replies, posted in General)

Everything works perfectly, thanks a lot Dmitry for your fast replies.

I just changed a detail, I use the OnShow event so the memo is automatically displayed and I tick the Read Only property before compiling so the users cannot edit my memo smile

This makes my life way easier to log / display the dev history.

789

(24 replies, posted in General)

That was too easy for you smile

790

(24 replies, posted in General)

Very good!

And what about a scroll bar? big_smile

791

(24 replies, posted in General)

Thanks, this does the trick, however, speach marks  ( " ) and  single quotes ( ' ) generate SQL error while saving.

792

(187 replies, posted in General)

Would it be possible to implement radio button beside checkbox.

I need to create radio buttons which would change a status of an item depending on which is chosen. I read a thread in the forum where it is possible by scripts, but well....how to say... It is tricky to guess the exact location of the radio button when there is no grid nor cursor position displayed and I am not going to waste my working time with trials and errors, my employer would not appreciate smile I am not even talking about maintaining the application in the future...

Morevover, how to add actions to this buttons?

For example, I need 3 buttons, depending on which one is chosen, the status of my item will change and it can be only one choice at a time.

* - Defect
* - In preparation
* - Ready

It might be working like a combobox but radio button are more eye catching.

793

(5 replies, posted in General)

Ok, so if it is a common table, what does the "dictionary table" flag does actually? Does it add a key?

794

(5 replies, posted in General)

Thanks Dmitry for the simple explaination, if I understand it well, this is a static table like a view actually? Would a dropdown list work without a dictionary table?

Is there any other case where a dictionary table would be needed or required in myvisualdatabase?

795

(24 replies, posted in General)

Sounds good, thanks Dmitry.

How would do to save and load the text from database instead of an external text?

796

(5 replies, posted in General)

Hi there, I tried to figured out in the document what a dictionary table means within myvisualdatabase with no success.

Could someone explain very clearly and using simple words the purpose and the use of a dictionary table in myvisualdatabase?

797

(187 replies, posted in General)

Would it be possible to sign your software so we would not get security alert when trying to download myvisualdatabase. On some computer, it is blocked by antivirus.

798

(24 replies, posted in General)

Thanks to you guys, both solution are pretty interesting.

I actually would need a mix of both solution: displaying a read only form which automatically loads a separate text file , so I would not need to edit any script afterward nor have to manage any button. Just editing a text file would suffice to update the information displayed.


I think I would use this in the script:

procedure Form1_OnShow (Sender: string; Action: string);
begin
     form1.memo1.lines.loadfromfile('test.txt');
end;


@mr_d We may ask ourself about the use of a read only checkbox since anyone can disable it smile
       I will keep your version for text editing though, thanks a lot

A more elegant way of doing it would be to save the text in a table and load this text into the memo, so the text would not be easily edited by end users.

I wonder if it is possible to format the text inside this multiline textbox?

799

(24 replies, posted in General)

I have actually no clue what this component is for, I was unable to write any text in it during project edition.

What I would like is a component which allows me to fill in free text like for a changelog or even this forum when you reply. I could edit it but not the users.

800

(24 replies, posted in General)

Hi there, is there a way to insert a multiline text box in a project? And if yes, how to fill in the line breaks?
Using single line text boxes is just a chore when you want to explain something or just display a long text.