Browse » Home » Archives for 2016
HINA SOFTWARES - NOW IN ABABIC & MALAY, MANDARINE LANGUAGES
Hina Softwares
delivers accounts software, billing software, inventory software, medical
software, ERP software, textiles software, school management software, college
management software, hotel management software, hospital management software,
MLM (netwoking) software, bulk SMS softwares, android application..
Send Tamil SMS through Oracle Forms6i - PL/SQL Procedure
sms 24.06.2016
Forms 6i Coding
select pri , com into pri , com from sms_com where rownum =1;
IF pri = 'ON' THEN
declare
p varchar2(100);
n varchar2(100) := ' Dear.'||initcap(:tb_personal.name);
r varchar2(20) := :tb_personal.regno;
m varchar2(100);
co varchar2(100) := com;
msg varchar2(1000);
msg1 varchar2(1000);
sms varchar2(100) := '+91'||:tb_personal.mobile1;
por varchar2(100) ;
por1 varchar2(100);
INST_NAME VARCHAR2(100) ;
begin
:system.message_level := '20';
select sum(b.amount) into p from tb_personal a, tb_billing b
where a.regno = b.regno and b.parity = :block3.date_3 ;
select initcap(inst_name) into inst_name from encrypt where rownum = 1;
msg :=inst_name||n||' RollNo. '||r||' Receipt No '||:block3.date_3||' Amount Rs.'||p|| ' has been paid in your Account Thank You!';
msg1 := msg;
por:= '/port:'||co||' /nologo /nosummary';
por1 := por;
host('d:\11i\sendsms\sendsms.exe '||por1|| ' " '||sms||' " " '||msg1||' "',NO_SCREEN);
IF NOT Form_Success THEN
Message('Error -- '||SMS||' Message not sent.');
MESSAGE ('CHECK YOUR COMMUNICATION PORT');
insert into tb_send_sms_ok values (1,:tb_personal.name,:tb_personal.regno,co,sms,msg1,'Message Not Sent',SYSDATE);
ELSE
Message(SMS||' Message Sent.');
insert into tb_send_sms_ok values (1,:tb_personal.name,:tb_personal.regno,co,sms,msg1,'Message Sent',SYSDATE);
END IF;
end;
commit;
sms 24.06.2016
sms 24.06.2016
Forms 6i Coding
select pri , com into pri , com from sms_com where rownum =1;
IF pri = 'ON' THEN
declare
p varchar2(100);
n varchar2(100) := ' Dear.'||initcap(:tb_personal.name);
r varchar2(20) := :tb_personal.regno;
m varchar2(100);
co varchar2(100) := com;
msg varchar2(1000);
msg1 varchar2(1000);
sms varchar2(100) := '+91'||:tb_personal.mobile1;
por varchar2(100) ;
por1 varchar2(100);
INST_NAME VARCHAR2(100) ;
begin
:system.message_level := '20';
select sum(b.amount) into p from tb_personal a, tb_billing b
where a.regno = b.regno and b.parity = :block3.date_3 ;
select initcap(inst_name) into inst_name from encrypt where rownum = 1;
msg :=inst_name||n||' RollNo. '||r||' Receipt No '||:block3.date_3||' Amount Rs.'||p|| ' has been paid in your Account Thank You!';
msg1 := msg;
por:= '/port:'||co||' /nologo /nosummary';
por1 := por;
host('d:\11i\sendsms\sendsms.exe '||por1|| ' " '||sms||' " " '||msg1||' "',NO_SCREEN);
IF NOT Form_Success THEN
Message('Error -- '||SMS||' Message not sent.');
MESSAGE ('CHECK YOUR COMMUNICATION PORT');
insert into tb_send_sms_ok values (1,:tb_personal.name,:tb_personal.regno,co,sms,msg1,'Message Not Sent',SYSDATE);
ELSE
Message(SMS||' Message Sent.');
insert into tb_send_sms_ok values (1,:tb_personal.name,:tb_personal.regno,co,sms,msg1,'Message Sent',SYSDATE);
END IF;
end;
commit;
sms 24.06.2016
QAMAR's BLOG: Send SMS from Oracle Forms through USB Connected GSM Devices
QAMAR's BLOG: Send SMS from Oracle Forms through USB Connected GSM Devices
The Polytechnic
Hi I am Senthilkumaran Oracle 10g OCP DBA from Tamilnadu,, India
Easy way to send sms through Oracle 10g Forms 6i Reports 6i
See my demo from
https://youtu.be/gLskpQ3W1Hk
https://youtu.be/oBP2Rul0ww4
smscaster + third party control usage (Airtel)
its free
thanks
The Polytechnic
Hi I am Senthilkumaran Oracle 10g OCP DBA from Tamilnadu,, India
Easy way to send sms through Oracle 10g Forms 6i Reports 6i
See my demo from
https://youtu.be/gLskpQ3W1Hk
https://youtu.be/oBP2Rul0ww4
smscaster + third party control usage (Airtel)
its free
thanks
Hina Softwares
Hina Billing Software (Since 2005)
(Admission +
Billing + Accounts + Auditing + Expenses + Balance Sheet + Ledger Balance + SMS
+ Group SMS + Barcode + NoDue + TC + CC + Bonafide + Declaration Forms +
Nominal Role + Govt. Related Forms + More than 100 Reports )
Features:
·
Oracle
based First Software in Tamil Language with SMS Support in LOW COST, No Hidden
Charges.
·
Software
Available in following Languages English, Tamil, Malayalam, Telugu, Hindi,
Arabic and Malay.
·
Fully
Password Protected Bills & Receipts,
·
Front
End : Python, Rail, Oracle Forms & Reports, Back End : Oracle 10g/11i
Express, OS : Windows XP
·
Also
available in Polytechnic Exam, Assessment, Library Management, Retail POS,
Medical POS
Thanks to Our New Clients – Year 2016
·
National
Institute of Polytechnic, Jayankondam
·
National
Arts & Science College, Jayankondam
·
Nelliandavar
Institute of Technology, Pudupalayam,Ariyalur
·
Modern
Polytechnic College, Mahimaipuram, Ariyalur
·
Modern
Arts & Science College, Ariyalur
·
Modern
Matric Hr.Sec.School, Jayankondam
·
Musiri
Institute of Technology, Musiri
·
Musiri
MIT Education College for Women, Musiri
·
Meenakshi
Ramasamy Arts & Science College, Thathanur, Ariyalur
·
Meenakshi
Ramasamy Polytechnic College, Thathanur, Ariyalur
·
Meenakshi
Ramasamy Engineering College, Thathanur, Ariyalur
·
Meenakshi
Ramasamy Catering College, Thathanur, Ariyalur,
·
Meenakshi
Ramasamy Educational Institute, Thathanur, Ariyalur
·
Meenakshi
Ramasamy CBSE Vidyalaya, Thathanur, Ariyalur
·
Meenakshi
Ramasamy Matric Hr.Sec.School, Thathanur, Ariyalur
·
Merit
Educational Institute, Ariyalur
·
Pari
Vallal CBSE School, V.Kaikatti, Ariyalur
·
Modern
Nursery & Primary School, Kattumananrkoil
·
Don
Bosco Hr.Sec.School, Varadharajanpet
·
Rajiv
Gandhi National Hr.Sec.School, Nattarmangalam,
·
Government
Middle School, Nattarmangalam
·
Mother
Gnanamma Arts & Science College, Varadharajanpet, Ariyalur. etc.,
Reasonable Prices:
Institutions
|
1 Server with
Client
|
If you want
Extra (Each) Client
|
AMC
|
Nursery & Primary Schools
|
10,000/-
|
1,000/-
|
2,000/-
|
Middle Schools, ITI
|
10,500/-
|
1,250/-
|
2,000/-
|
CBSE Schools
|
15,000/-
|
1,500/-
|
2,500/-
|
Higher Secondary Schools
|
15,000/-
|
1,500/-
|
2,500/-
|
B.Ed, Nursing Colleges
|
15,000/-
|
1,500/-
|
2,500/-
|
Polytechnic Colleges
|
20,000/-
|
2,000/-
|
2,500/-
|
Arts & Science Colleges
|
20,000/-
|
2,000/-
|
2,500/-
|
Engineering Colleges
|
30,000/-
|
3,000/-
|
3,500/-
|
Contact: (For Free Demo CD,
Information)
Senthilkumaran R
|
9952784002
|
Oracle 10g OCP DBA
|
8012784989
|
HINA SOFTWARES
|
abisekblogger@gmail.com WebSite : http://goo.gl/2QRs2B
|
hina billing demo
https://youtu.be/gLskpQ3W1Hk
https://youtu.be/oBP2Rul0ww4
Subscribe to:
Posts (Atom)