51

(1 replies, posted in General)

hi everyone any Idea why this code not working?
I already have Main_OnShow on my event tab too. but not working sad

procedure Main_OnShow (Sender: TObject; Action: string);
begin
   ShowMessage('hello');
end;

how can I fix this?

many many thanks

52

(5 replies, posted in General)

Wow,
Many thanks @k245 and @CDB

53

(5 replies, posted in General)

Hi,
I just wondering about dynamic forms in MVDB!

Imagine we have a database with some items, and want to have a button for each item in database which is clickable to open that item showrecord form and be able to drag and rearrange buttons like in editor but in end software! so end user can customize forms (at least rearrange buttons).

is it possible at all?

54

(1 replies, posted in General)

Hi,
I have a strange problem!
simply onKeyPress event not working! here is the script:

procedure Form1_OnKeyPress (Sender: TObject; var Key: Char);
begin
    ShowMessage('some text to test');
end;

also I can see my function name in in event tab of the form.

any Idea why its not working?

many thanks

55

(12 replies, posted in General)

Hi is there any way to change a button color?
not font, but button it self!
I just want to change buttons background color based on results in Grid or DB.

Many Thanks

joshuA wrote:

sonixax,
.
Without seeing your project and from my interpretation of your request, I would suggest experimenting with a `record_count` field to keep track of the items in your database.  I had forgotten about this until recently, and it has solved many issues for me.
.
I'm not sure if I can provide a solution for your request, but adding a sample of what you're working with will certainly get a faster response.  Just my two cents.


Thanks a lot that helps a lot.
I just used this query and everything seems fine.

INSERT INTO levels (level) VALUES ((SELECT COUNT(levels.id) FROM levels)+1)

one more question:

any Idea how to translate
mbyes and mbno

??

Many Thanks

Any Idea?

58

(6 replies, posted in General)

Thank you for the solution,
did top level images ignore transparent areas as hotspots?

Hi,
I just searched for it but not manage to find anything.

I have a table with only two fields one integer and another one is calculated.
calculated fiel just count the child items.

so I don't need a new form to add new parent (in my case level). all I need is to know how can I add a new row in database and of course remove it from level manager with only one button without need to open a new form.

I want to add a new level (as example level 2) with one click. and of course with auto increment.
Also need to delete levels without select one of them from the grid, if user click on delete just remove the last one (bigger one)

many many Thanks

60

(6 replies, posted in General)

I did, as you can see My title is Image button but unfortunately cannot find anything!
look at attachment, this is my image and every single box need to be a button.
I have no Idea how can I add some hotspot on this image or similar sad

https://i.imgur.com/5tZqjY2.jpg

61

(6 replies, posted in General)

Hi Dimitri,
I have a question,
I want to have custom shape Buttons using images, actually want to have a map with buttons as states so need to have something like html hotspot.
how can I achieve that?

many many Thanks

62

(6 replies, posted in General)

I believe something can help to protect our compiled projects from illegal copies are fine too! currently there is absolutely nothing! decrypting .pas or .dcu files need few minutes!
I can write an online activation script but cracking it need few minutes because there is absolutely no protection! all I can do currently is using third party software line enigma to pack executable and scripts together!!!
Also, ability to change software icon is nice too big_smile

63

(3 replies, posted in General)

any idea?!

64

(3 replies, posted in General)

Hi everyone,
This new grid functions to add, edit and delete are awesome!
but the row on the top is some sort of ugly smile
these are my bunch of questions smile))

1 - How can I add + icon on first of the add row to let users knowing here designed to add new records?

2 - Grid will show calculated field text for, calculated database tables! how can I remove that text and replace it with something else?! as example some colors or icons!

3- I have two columns input and output! both of them are currency but cannot have amount at the same time (logically) by using normal method I can write very simple script to set input field to 0 if output have value and set output to 0 if input have value! how can I do the same for grid?!

4- How can I switch between new input columns with tab?! its easier to add big_smile

5- How can I format date time picker in grid? currently its on MM/dd/YYYY I want it as dd.MM.YYYY (Europian Version)

6- and lastly, I just have a search button there to search between records. but I don't know how can I restart grid to its original state! just tried dbUpdate, Refresh and Clear but not working!

Thanks a lot and have a lovely day

many many Thakns,
Its worked smile

Thanks a lot,
yep its exactly what I need, Just another question!
My columns in database are not integer! is total(a.columnname0 work with currency type too?!

Thanks a lot again

Hi,
I just want to have a column in Grid without having a table in database!
this column will show values from sum of three of other rows in another column in same grid!

some Example:

             column1 | column2 | VirtualColumn |

row1    10              20               sum of 1 and 2 = 30
row2    -10             40               sum of 1 and 2 and top virtual grid = 60
.
.
.
row    10                20                 sum of 1 and 2 and top virtual grid = x

is there any way?!

Thanks a lot and have a lovely day

68

(1 replies, posted in General)

Hi,
is it possible to have fullscreen form to show images ?
the images will be put in a folder with seq numbering!
thnaks a lot

69

(1 replies, posted in General)

Hi,
I just have some strange problem,
Ive just make an application which using mysql to connect.
the problem is if I open a new form using new record! and prevent to close the form after saving it, by every click on save button MVDB add a new record to DB!!!!
its mean I have duplicate content every time I click on the save button!!!
Is it bug or something else ?

Thanks a lot smile

70

(3 replies, posted in Reports)

Thanks a lot smile
And one more problem!
Dear Dimitri, I have a date field with type of Time in my project.
in database it is Time field again!
But in reports it shows strange things!

For example for 22:23:44 it shows : 22:September:44

How can I fix this too ?
thanks again smile

71

(3 replies, posted in Reports)

Hi,
I just need to replace yes with JA and no with Nein in Report designer!
How can I do that ?
because variable come from booleans in MVDB are in english sad
Thanks a lot

72

(4 replies, posted in Reports)

Thanks a lot dear Dimitri,
And how can I make a loop in another loop ?

I mean Print categories and under it print subcategories and all of these are dynamics!

Thanks again smile

73

(4 replies, posted in Reports)

any Idea ?

74

(4 replies, posted in Reports)

Hi,
I just need to know how can I have a loop in another loop in reports ?

For example I have X categories, under those categories I have another Categories!

So I want to print every Main Categories in two colums with Bold text, and print subcategories under each main category that they belongs to!
Something like this :

Category1         Category2
SUB1.1             SUB2.1
SUB1.2             SUB2.2
SUB1.3             SUB2.3
Category3         Category4
SUB3.1             SUB4.1
SUB3.2             SUB4.2
SUB3.3             SUB4.3
...


Thanks a lot smile

75

(5 replies, posted in SQL queries)

Thanks a lot smile it worked tongue