Hi,
I have a strange problem!
When I make a new record! if click on Print (Report) button before saving it! it will save item in database!!! (No problem)
The problem is when I click on save button , it will duplicated !
So how can I prevent this ?! (Please check attachment for project files - report file corrupted! please remove or replace it!)
Thanks a lot
101 2015-08-10 22:14:59
Topic: Duplicate Records on Print/Save (2 replies, posted in General)
103 2015-07-07 23:02:12
Re: Database speed! (6 replies, posted in General)
Hello sonixax
Not enough informations about your application
.
How many tables have you created ?
How many side tables ?Do you use pictures in your main table ?
If yes, how are they stored in the table (StoreFile or LinkFile) ?Also, what is your PC OS ?
Thanks for all your answers, then we shall be able to help you.
JB
Hi,
I have only 2 tables!
And no I do not have any pictures in my tables!
I have 3 PC's , One of them running windows 8.1 anothers running windows 7!
The PC with windows 8 using 2X Xeon E5-2620 with 32GB of ram! another PC's using I7 as CPU with 16GB of ram! (all of them have SSD)
in all of them after about 2500 records inserting is going slow! I don;t know why my database file size is only 250KB!!!!
How do you insert data in you database? Which size is your SQLite.db file?
Which method? Do you use specific scripts? Do you have an antivirus checking on access files?
@Dmitry
There is a very interesting post here, at the end: http://stackoverflow.com/questions/3852 … -very-slow
Is it enabled in MVDB?
I do not know! I just using MVDB!
Please check attached file for project files! (There is nothing in Database because All of data's are Private)
104 2015-07-06 01:41:55
Topic: Database speed! (6 replies, posted in General)
Hi,
I've just made a database software using MVDB! Everything works fine unless i reached to 2500 records!
now my DB is so slow ! and I should wait about 10 sec to save every new record!
so how can I solve this problem ?!
Thanks a lot
105 2015-04-30 00:20:39
Re: A very tiny change to Invoice Project (3 replies, posted in General)
Thanks a lot
106 2015-04-25 19:00:14
Re: A very tiny change to Invoice Project (3 replies, posted in General)
?!?!
107 2015-04-25 18:58:57
Topic: Calculated Field not workin! (1 replies, posted in General)
This code is not working on calculated field :
(
(services.cost / 1.19) - services.cost
)
What is the problem ?!
I want to calculate TAX and save it in database!
Thanks a lot
108 2015-04-24 23:41:33
Topic: A very tiny change to Invoice Project (3 replies, posted in General)
Hi,
I want to edit Invoice Project (which is available for download in samples).
I need to add is an Invoice number in this format (Year/Integer)
my current number is 200!
so I want to have Invoice numbers from (20158/200) !!!
And also I want to calculate Taxes and save them in database! (19%) That's all
How can I do that ?!
Thanks a lot
109 2014-12-04 19:40:17
Re: Sort combobox Options! (5 replies, posted in General)
it is not working when i use this format :
user 1
user 5
user 4
user 2
...
but it is work with this format :
David
Jones
Martin
Andy
...
110 2014-11-29 03:14:27
Re: Sort combobox Options! (5 replies, posted in General)
Thanks , but Ive test it before! it does not work
111 2014-11-28 20:07:17
Topic: Sort combobox Options! (5 replies, posted in General)
Hi,
I need to know how can I sort Combobox options by name (ASC) ?!
Thanks a lot
112 2014-11-24 01:31:27
Re: Beta version 1.47 (3 replies, posted in General)
Please add ability to set custom icons for buttons
113 2014-11-24 01:29:37
Re: Restart the form after click on save (4 replies, posted in General)
Thank you
114 2014-11-18 01:36:54
Re: Restart the form after click on save (4 replies, posted in General)
Thank you and how can I Clear ComboBoxes ?!
115 2014-11-17 02:24:37
Topic: Restart the form after click on save (4 replies, posted in General)
Hi,
I need to restart the form (Clear all fields values) after click on save without closing the form to add new record!
how can i do that ?!
116 2014-11-13 02:12:02
Re: Using Grid Results in Report (11 replies, posted in Reports)
Hi,
Dear Dimitri did you Received My Email ?!
117 2014-11-11 01:16:13
Re: Using Grid Results in Report (11 replies, posted in Reports)
Dear Dimitri ,
I cannot Understand this Script and how it works !
I cannot get values in Report designer side!!!
Also I do not know how can I wok with Cross component
118 2014-11-11 00:51:07
Re: Using Grid Results in Report (11 replies, posted in Reports)
Should I Use scripting like this ? :
procedure frxReportBeforePrint(Sender: TfrxReportComponent);
var
Cross: TfrxCrossView;
x, y, cx, cy: Integer;
begin
if Sender is TfrxCrossView then
begin
Cross := TfrxCrossView(Sender);
// Columns name
cx := Form1.GridEmployees.Columns.Count - 2;
for x := 0 to cx do
Cross.AddValue([-1], [x], [Form1.GridEmployees.Columns[x].Header.Caption] );
// data
cy := Form1.GridEmployees.RowCount - 1;
for y := 0 to cy do
for x := 0 to cx do
Cross.AddValue([y], [x], [Form1.GridEmployees.Cells[x,y]]);
end;
end;
begin
end.
119 2014-11-10 02:55:45
Topic: Using Grid Results in Report (11 replies, posted in Reports)
Hi,
Is it possible to use Grid Results Directly in Reports ?!
Because I do many math with scripts to Grid result and it is near to Impossible to do all of them again in Report!
For example I have a ComboBox in my Project,
If the combobox Select number one , and first column of any row is not equal to ComboBox Text, then my script set those values to negative!
so, It is easier to have Grid results Directly into the Report!
120 2014-11-06 01:01:42
Re: How to Change Grid Text Color ? (16 replies, posted in Script)
Oh, Thanks a lot
And what is the correct code for Footer text color ?!
121 2014-11-06 00:37:19
Topic: SUM Different types seperately! (1 replies, posted in Script)
Hi,
I have two type of products in my Grid! that I show them with 1 and 2.
I want to SUM the values of type 1 and two in separate vars! and then show them in a text label !
In "C" like Syntax we can use this += in a loop (For,Do,While) but i Don't know how can i do that in Delphi!
For example in PHP we can use something like this :
<?php
$arr = array(1, 2, 3, 4);
foreach ($arr as &$value) {
$value += $value;
}
echo $value;
?>
Can we do the same in Delphi ?!
123 2014-11-05 00:32:10
Topic: How to Change Grid Text Color ? (16 replies, posted in Script)
Hi,
This is the question! how can I change Grid Text Color ?!
(Not the Cell BG Color)
124 2014-11-04 23:52:38
Topic: Radio Button (9 replies, posted in General)
Hi,
How can I have Radio buttons on MVDB ?!
Thanks a lot
125 2014-11-04 20:39:05
Re: Get Bilance from inputs! (3 replies, posted in Script)
and pics for person 2