santhosh kumar
2011-03-01 10:14:00 UTC
hello,
I there is a table leavetable which consists of grade,leavetype,
n.oofLeaves JOINED With gardetable Grade as primary key
for garde G1 -- > Leavetype no.of Leaves
L1 12
L2 10
I have to select no. of leave type using select statement as follows
select leavetype,no.OfLeave From leavetable where grade == "G1"
i have taken a menuitem from emplform to open the leavetableform whith
unbounded string control LeaveType and no.of Leaves to display L1 -
please can help me out!
I there is a table leavetable which consists of grade,leavetype,
n.oofLeaves JOINED With gardetable Grade as primary key
for garde G1 -- > Leavetype no.of Leaves
L1 12
L2 10
I have to select no. of leave type using select statement as follows
select leavetype,no.OfLeave From leavetable where grade == "G1"
i have taken a menuitem from emplform to open the leavetableform whith
unbounded string control LeaveType and no.of Leaves to display L1 -
12 has to diaplay L2 -> 10 as next record in grid but its not
displaying the two records only one record is displayedplease can help me out!