1

(2 replies, posted in SQL queries)

hello freands can i connect  to existing mdf file in the server and how to do that  ?

2

(20 replies, posted in General)

i need the free version where i can find it

Thank you gonpublic2k i'll post mine when it finiched too its rich with examples thank'x too fto this forum and his admin and members.

can i see u'r emplyee project for taking an idea me too i am working on that project and it is verry complicate

5

(2 replies, posted in General)

ok thank'x for reply brother

6

(2 replies, posted in General)

can i maximize form slidly with script and add some effects to closing fomrs

7

(1 replies, posted in General)

hello admin
i need to know if i finish my project with trial version 3.2 can i run it in auther computer or  mvd ask me to activate if trial version finish
its must instal mvd in the auther machin or just run the exe file

8

(7 replies, posted in Script)

Sloved thankx to admin

9

(7 replies, posted in Script)

we have evry 2 year 1 grade but the Time period from date enter to 14/04/2010 is calculated 1/2 + Time period from 15/04/2010 to 31/12/2016

10

(7 replies, posted in Script)

i mean if date_enter with is Grade.DateTimePicker1 > 14/04/2010 (Grade.DateTimePicker2) or 15/04/2010 (Grade.DateTimePicker3)
get the result just from Grade.DateTimePicker1 to 31/12/2016 or Grade.DateTimePicker4
i try to get the solution with false and true

11

(7 replies, posted in Script)

is attached my project thank you señor

12

(9 replies, posted in General)

just add function new record to the add button and slect   form1  and the buttons will enabled
then add event
procedure Form1_Button5_OnClick (Sender: string; var Cancel: boolean);
begin
     Form1.edLastName.SetFocus ;
end;

13

(1 replies, posted in General)

how can i write conditon

if frm1.datetimepiker1.date < = frm1.datetimepiker2.date then or do
or
if frm1.datetimepiker1.date < = frm1.edit1.date
if isen't null don't calculate

14

(7 replies, posted in Script)

other example

15

(7 replies, posted in Script)

hello admin and all members of MVD
here is my script if someone want help me and he want the  project i send it

function CalculateDateBetween(StartDate, EndDate: TDateTime): string;
var
    YY, MM, DD: Word;
    dv, ad, ac: integer;

begin

    YY := YearsBetween(EndDate, StartDate);
    MM := MonthsBetween(EndDate, StartDate) - (YY*12);
    DD := DaysBetween(EndDate, StartDate) - (YY*365) - (MM*30);

   //Result := 'سنة,' + IntToStr(YY) + 'شهر,'+IntToStr(MM) + 'يوم,'+IntToStr(DD);
     Result := (IntToStr(YY)+' سنة  ') + (IntToStr(MM)+' شهر  ') + (IntToStr(DD)+' يوم  ');


end;
//*********************************************************************************************************
procedure frmEmployee_Button2_OnClick (Sender: string; var Cancel: boolean);

      var
    s,: string;
begin

  Grade.Edit2.Text := frmEmployee.EditCounter1.Text;
  Grade.Edit1.Text := SQLExecute('SELECT Name FROM Employees WHERE id ='+inttostr(frmEmployee.TableGrid1.dbitemid));

  s := SQLExecute('SELECT Date_denter FROM Employees WHERE id='+frmEmployee.TableGrid1.sqlValue);
  if s <> '' then Grade.DateTimePicker1.Date := SQLDateTimeToDateTime (s)
  else Grade.DateTimePicker1.Checked := true;

     //     fixing  date in Grade.DateTimePicker2/Grade.DateTimePicker3/Grade.DateTimePicker4


     Grade.DateTimePicker2.Date := EncodeDate(2010, 4, 14);
     Grade.DateTimePicker4.Date := EncodeDate(2016, 12, 31);

  if Grade.DateTimePicker1.Checked and Grade.DateTimePicker2.Checked then
     Grade.DateTimePicker3.DateTime := Grade.DateTimePicker2.DateTime + 1;
  if Grade.DateTimePicker1.Checked and Grade.DateTimePicker2.Checked  then

     Grade.Edit3.Text := CalculateDateBetween(Grade.DateTimePicker2.Date, Grade.DateTimePicker1.Date);
     Grade.Edit5.Text := CalculateDateBetween(Grade.DateTimePicker3.Date, Grade.DateTimePicker4.Date);
     Grade.Edit12.Value := DaysBetween(Grade.DateTimePicker3.DateTime, Grade.DateTimePicker4.DateTime);
     Grade.Edit10.Value := DaysBetween(Grade.DateTimePicker1.DateTime, Grade.DateTimePicker2.DateTime);
     Grade.Edit11.Value := Grade.Edit10.Value/2;
     Grade.DateTimePicker5.DateTime := Grade.DateTimePicker1.DateTime + Grade.Edit11.Value ;
     Grade.Edit4.Text := CalculateDateBetween(Grade.DateTimePicker2.Date, Grade.DateTimePicker5.Date);
     Grade.Edit13.Value := Grade.Edit11.Value + Grade.Edit12.Value ;
     Grade.Edit7.Value :=  trunc((Grade.Edit13.Value / 365*30*12)/730) ;
     frmEmployee.Edit17.Value :=  Grade.Edit7.Value;
     frmEmployee.panel1.Visible := true;

16

(1 replies, posted in Reports)

SLOVED

17

(1 replies, posted in Reports)

hello
i cant show data to the second report in the same form
any idea

18

(6 replies, posted in General)

i used this example
http://myvisualdatabase.com/forum/viewt … 159#p19159

19

(2 replies, posted in Script)

nice work i'ts help me alot

20

(3 replies, posted in General)

what the reverse off this script
frmEmployee.Edit12.Text := SQLExecute('SELECT TotalD FROM conge WHERE id='+inttostr(frmEmployee.TableGrid1.dbitemid));
i want save record from table to table or bdedit.value

21

(3 replies, posted in General)

hello evryone
how to show automatically sub (records) in dbedit i mean with relation   look at the photos
and my project
user&password  admin/admin

22

(1 replies, posted in General)

hello admin is this a bug or becaouse i'ts trial version
using v 3.2
1- can't rename components like edit text, datetimepiker.... 
2- can't show the fields in tblgrid if i chose (show child recods if present)

23

(1 replies, posted in General)

how to change text in the Tgrid header (righit to left) and disable onclick sorting asecending descending in the header

24

(3 replies, posted in Script)

sorry don't seen u'r msg

25

(5 replies, posted in General)

waw good this is what i want thank you verry happy jajajajajajaja