tcoton smile Thank You For Comment
Love tcoton
*****
This Project for teach my student easy start ....
My Visual Database → Posts by prahousefamily
tcoton smile Thank You For Comment
Love tcoton
*****
This Project for teach my student easy start ....
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
-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

-Basic Report Design

-Basic Print All And Print Select At Mouse in TableGrid

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
Thank You Very Much love...
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
Help Me Please How To Edit same This Example ?

http://community.jaspersoft.com/wiki/subreports
Download MVD
subreport.zip
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
to
Subreports!
http://community.jaspersoft.com/wiki/subreports
It have not effect !
how to edit script for display clock in footer
and update time every second . . .
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
Thank You Very much
But I need Show effect in lable not in table
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
Thank You very much
Thank you again by Love...
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
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.
My Project
jintana.zip
Help me please ?
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 ?
How To Auto load value Datagrid to combobox when
-click film
-click add film lating
-in combobox auto load value from datadrid to combobox
It Easy Very Much .....
Yesterday "Increm.Search" is ???????
Today "Increm.Search" Understand
I and Student Thank you Very much...... Dmitry Teacher
I need to show in example
My Visual Database → Posts by prahousefamily
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi