Search options (Page 30 of 34)

Dmitry, I have sent my project

Oh, it reminds me something very important regarding using mvdb applications on small screens.

Is there any way to make a common mvdb application developped on a "standard" office screen display correctly on a smaller screen? I mean, I have developped an application with mvdb on my desktop computer with a very comfortable screen, but when time has come to use this application on a laptop, it becomes nearly unusable as the windows do not scale the new screen. I have even tried on a windows 8 tablet, it is just a nightmare.

Is it somehow planned to implement auto-scale windows to fit any kind of screen,? This is already possible in css so why not with "hard" programming

Thanks Dmitry,

It works absolutely fine, I have added the code to disable the buttons once db is set-up to avoid modification by the end users.

Form1.Help_DBImage1.dbShowButtons := False;

I use the dbimage for the help section of my application

How do you display a picture which has been saved in the database please?

I tried this feature, I have a picture in the database but no way on how to display it using 1.50 beta.

Actually, I would like to have a condition on the text as well so the colour would not apply on all rows with a number in the set colour range....

so the 2 variables are

cell 1 (Status) and cell 2 (Count)

in cell 1 I can have different text : Ready, Defect, To restage

in cell 2 I can have different numbers : from 0 to n

but I do not want cell 2 of each row being colored the same way on each row!

If I use the current known scripts, all row change their colour when the count reaches the defined threshold which is useless in my project. I need different colours for different information, a count of 2 Ready would be Red whereas a count of 2 Defect would be Green and a count of 2 To restage would be Orange, you see!

I have a simple grid which displays the result of the following query:

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

) temp

And it is displayed as shown in the attached screenshot.

The colours are not yet established, it is under construction

Thanks for the script mathmathou, I was looking for something like this

Another question on same topic, is it possible to change colours depending on cell with 2 variables?

example:

Status                     Count

Ready                     40                  ---------> above 5= green, under 5=Red
Defect                     3                    ---------> 0= green, from 1=text red, above 2= background red
Unavailable             2                   ---------> 0= green, from 1=text red, above 5= background red

Can I change the colours depending of the count for each status independently but in same tablegrid?

I remember also having seen a topic about changing the colour depending on time... will try to retrieve it.

Yes it is, sorry for the double post

And how to display the records into a grid when getting the variable from a textbox?