326

(6 replies, posted in General)

tcoton smile Thank You For Comment

Love tcoton

*****
This Project for teach my student easy start ....

327

(6 replies, posted in General)

World Database from MySQL Convert To SqLite
Compile MVD 1.52
You Can Download For Example Easy Start...
world_db.7z

-Basic 3 Table
Master Table : Country
Detail Table 1 : City
Detail Table 2 : Country Language
http://s21.postimg.org/5y3ic67ud/2015_08_24_Image_014.png

-Basic Script
Show Message
Grid Color When Column  Set value

//start script
//script 001 show message even form show
procedure frm_001_main_OnShow (Sender: string; Action: string);
begin
   showmessage('Hello World! Basic Example')
end;
//script 002 grid color highlight if Country Language Is Official ='T' At frm_001_main
procedure frm_001_main_TableGrid1_OnChange (Sender: string);
var
   i,c: integer;
   k,q: integer;
begin
     c := frm_001_main.TableGrid1.RowCount - 1;
     q := frm_001_main.TableGrid1.Columns.Count - 1;
     for i := 0 to c do
begin
     if frm_001_main.TableGrid1.Cells[19,i] ='T' then
     for k := 0 to q do frm_001_main.TableGrid1.Cell[k,i].Color := $507FFF  ;
end;
end;
//script 003 grid color highlight if Country Language Is Official ='T' At frm_002_country
procedure frm_002_country_TableGrid2_OnChange (Sender: string);
 var
   i,c: integer;
   k,q: integer;
begin
     c := frm_002_country.TableGrid2.RowCount - 1;
     q := frm_002_country.TableGrid2.Columns.Count - 1;
     for i := 0 to c do
begin
     if frm_002_country.TableGrid2.Cells[3,i] ='T' then
     for k := 0 to q do frm_002_country.TableGrid2.Cell[k,i].Color := $507FFF  ;
end;
end;

//script last can not delete
begin
end.

Form Preview Effect
http://s24.postimg.org/i2tc10cmr/2015_08_24_Image_002.png
http://s13.postimg.org/6mb7ii2o5/2015_08_24_Image_006.png

-Basic Report Design
http://s21.postimg.org/56o9t23hy/2015_08_24_Image_010.jpg

-Basic Print All And Print Select At Mouse in TableGrid
http://s12.postimg.org/7vx9e9q1o/2015_08_24_Image_011.jpg
http://s7.postimg.org/iqd3q8da2/2015_08_24_Image_012.jpg

Thank You
-Dmitry. For More Example And More People In This Forum

Comming Soon
-Report Design Master Detail
-Function  In Database
   Cal Date Year,Month,Date or Number Day
   Concat String Columa+ColumnB Or More
   Substring In Text,Date
   Script Update Database By Script SQL Resize ,Index ETC

328

(5 replies, posted in Reports)

Thank You Very Much love...

329

(5 replies, posted in Reports)

Where are dataset(Employee,Email,Phone)
link or relation at code ?
Script

    
Employees.frxReport.Clear;
    Employees.frxReport.DataSets.Clear;
    Employees.frxReport.DataSets.Add(frxDBDataset1);
    Employees.frxReport.DataSets.Add(frxDBDataset2);
    Employees.frxReport.DataSets.Add(frxDBDataset3);

Or Report Edit Code

procedure MasterData3OnBeforePrint(Sender: TfrxComponent);
begin
      MasterData3.Visible := <Employee."id">=<Email."id_Employees">;              
end;
  
procedure MasterData2OnBeforePrint(Sender: TfrxComponent);
begin
       MasterData2.Visible := <Employee."id">=<Phone."id_Employees">;           
end;

Yes/Or No

330

(5 replies, posted in Reports)

Help Me Please How To Edit same This Example ?
http://community-static.jaspersoft.com/sites/default/files/static/tutorials/ir_subreports/figure_1.png
http://community-static.jaspersoft.com/sites/default/files/static/tutorials/ir_subreports/figure_12.png
http://community.jaspersoft.com/wiki/subreports
Download MVD
subreport.zip

331

(5 replies, posted in General)

Um I will to add dataset more 1 dataset because edit subreport  to show master and detail data
but detail data that more than 1 table

Um.... i don't know to how edit  show

master data - patient = fname ,lname ,age,birtdday
detail data 1 - show diagnosis = icd10 code
detail data 2 - show service = icd9 code

same  example this
http://community-static.jaspersoft.com/sites/default/files/static/tutorials/ir_subreports/figure_1.png
to
http://community-static.jaspersoft.com/sites/default/files/static/tutorials/ir_subreports/figure_12.png
Subreports!
http://community.jaspersoft.com/wiki/subreports

332

(5 replies, posted in General)

Onho Thank You For  example it Good create dataset in report design

Um if dataset1  link or relation dataset 2
how to set script
http://s18.postimg.org/oa6nhnt1x/2015_08_19_Image_001.jpg
http://s8.postimg.org/b4pv0jbup/2015_08_19_Image_002.jpg

333

(5 replies, posted in General)

i will increase dataset in report editor from 1 to 2 and more
how to ?
http://s1.postimg.org/pcsgxl2ez/Image_007.jpg

how to use function system group
- FindWindow(ClassName , WindowName : String):interger
- GetHardDiskSerial(driveLetter:string):String
- GetTickCount:cardinal
for show system in my computer
http://s29.postimg.org/7htcscsxf/2015_08_13_14_13_27_001.jpg
http://s2.postimg.org/cze16l8d1/2015_08_13_14_09_10_001.jpg

335

(17 replies, posted in Script)

It have not effect  !

336

(17 replies, posted in Script)

how to edit script for display clock in footer
and update time every second . . .
http://www.delphicoding.com/images/mgDigiTimer.jpg

How have free license for the educational ?
i work in small hospital and free teach in "basic database and apply in your work" 
my student is children student ,doctor,nurse and people etc

by use my visual database 1.2 1.3 to 1.46 for teach because free edition 
but 1.47 and later not free and in i haven't  license

Thank You .... My Visual Database Example easy for my student
http://www.bloggang.com/data/m/mrpostcard/picture/1409626181.jpg

Hi derek.
Thank  You for sample download but i use My Visual Database 1.46 can not open project
I need Try  send sample by old version ..
Help me please
Pra House Family
http://s10.postimg.org/wobzpj3gl/2015_06_26_Image_001.jpg

Thank You Very much
But I need Show effect in lable not in table

340

(7 replies, posted in Script)

It Work Nice !
Function Easy Fix bug By Multiple Show Form
smile Thanks Dmitry

How To edit script when DateTimePicker  On_Change and display in lable or textbox

sample
A = Start Date (01/01/2015)
B = Stop Date (25/06/2015)
Answer
B - A
Display = " Year=0 Month=5 Day=24 "


How to edit Script  ?
My Student  Ark me  but I Haven't Answer because function this can apply birth ,expire date or etc
help me please !
Download My Project
09 Lesson Script.zip

Sample Screen Shot
http://s21.postimg.org/nfhhlv3bn/2015_06_25_Image_001.jpg

342

(7 replies, posted in Script)

Thank You very much
Thank you again by Love...

343

(7 replies, posted in Script)

I Have  2 Form
1- frm_a (start from)
   - Button(open from b)
2- frm_b



how to edit script when click button open frm_b  and  close frm_a

344

(1 replies, posted in Reports)

I want to edit  in report display  by
aaa = type date in mvd

concat(aaa,substr(aaa,1,4))

it error  Help me please !
http://s3.postimg.org/4elsh1nq7/2015_06_09_Image_001.jpg

345

(1 replies, posted in Script)

i set button when click  run sql:update table
but after no action to display

procedure frm_item_Button2_OnClick (Sender: string; var Cancel: boolean);
begin
SQLExecute(
 'update alldata '+
 'set tm_group = '+
 'case '+
 'WHEN substr(dateservice,6,2) ="01" then "jan" '+
 'WHEN substr(dateservice,6,2) ="02" then "feb" '+
 'WHEN substr(dateservice,6,2) ="03" then "mar" '+
 'WHEN substr(dateservice,6,2) ="04" then "apr" '+
 'WHEN substr(dateservice,6,2) ="05" then "may" '+
 'WHEN substr(dateservice,6,2) ="06" then "jun" '+
 'WHEN substr(dateservice,6,2) ="07" then "jul" '+
 'WHEN substr(dateservice,6,2) ="08" then "aug" '+
 'WHEN substr(dateservice,6,2) ="09" then "sep" '+
 'WHEN substr(dateservice,6,2) ="10" then "oct" '+
 'WHEN substr(dateservice,6,2) ="11" then "nov" '+
 'WHEN substr(dateservice,6,2) ="12" then "dec" '+
 ' end ;'
);
end.

http://s2.postimg.org/jjk14mp9h/2015_06_08_Image_002.jpg
My Project
jintana.zip
Help me please ?

346

(1 replies, posted in Reports)

How to set or edit display datetime in report  print preview same report(SQL) print preview

To format YYYY-mm-dd


Help me please !!!

http://s28.postimg.org/9anzs5mzt/2015_06_04_Image_003.jpg

347

(1 replies, posted in Reports)

In Group  Footer  It Display  Logic Error
I will to display
Sum (-3600 ,-3600) = -7200


But Report display = -3600-3600
How to edit  in System memo or Where ?

348

(4 replies, posted in Script)

How To Auto load value Datagrid to combobox when
-click film
-click add film lating
-in combobox auto load value from datadrid to combobox

349

(4 replies, posted in General)

It Easy Very Much .....


Yesterday      "Increm.Search"   is ???????

Today              "Increm.Search"  Understand

I and Student Thank you Very much......  Dmitry Teacher

350

(4 replies, posted in General)

I need to show in  example