Home » Developer & Programmer » Forms » prob while inserting
prob while inserting [message #77712] Tue, 06 November 2001 21:38 Go to next message
chandrakanth
Messages: 16
Registered: October 2001
Junior Member
table name = Ah_mast
Columns are :-
Ah_Date Date
Ac_code varchar2
Ac_desc Varchar2
Bal Number
Co_code Varchar2
F_year Varchar2
s_flg varchar2
about keys & variables:-
Unique-key :- (ah_date+ac_code+co_code+f_year)
Ac_code, Ac_Desc, Bal :- user inputs (forms)
ah_date, co_code, f_year :- Global.variables

s_flg is a check_box item and if selected "Y" if not then "N" and copied into blockitem s_flg (properties copy value from).

start_dt, end_dt :- Global.variables to calculate the number of records to be inserted while updating the ah_mast i e it start date is 01-04-2000 and end_dt is 31-dec-2001 then while BUTTON-PRESSED(SAVE) 365 records to be inserted into ah_mast inbetween the dates from start_dt and end_dt.

Example:
01-Apr-2000, 'ac_code1','desc1', 1234.00,'co_code1','8889','Y'

second record will be start_dt + 1

02-Apr-2000, 'ac_code1','desc1', 1234.00,'co_code1','8889','Y'

my coding for inserting is as below:

when-button-pressed trigger

declare
temp_start date;
temp_end date;

begin
temp_start := :global.start_dt;
temp_end := :global.end_dt;
while :temp_start <= :temp_end
loop
insert into ah_mast values(:temp_start,
blockname.ac_code,
blockname.ac_desc,
blockname.bal,
:global.co_code,
:global.f_year,
block.s_flg);
:temp_start = :temp_start+ 1
end loop;
end;

While running the form ERROR MESSAGE IS:- COMMA IS MISSING...

Pls help...

----------------------------------------------------------------------
Re: prob while inserting [message #77715 is a reply to message #77712] Wed, 07 November 2001 02:39 Go to previous messageGo to next message
Shilpa
Messages: 59
Registered: November 2001
Member
You missed a semicolon after this statement.

:temp_start = :temp_start+ 1

----------------------------------------------------------------------
Re: prob while inserting [message #77750 is a reply to message #77712] Mon, 12 November 2001 02:50 Go to previous message
waris
Messages: 115
Registered: November 2001
Senior Member
hi chandrakanth...

i think u have missed out semicoln...after incrementing temp_start

/*temp_start = :temp_start+ 1 */

i hope u r clear...

----------------------------------------------------------------------
Previous Topic: Re: Matrix Report by period - Can this be done ? - Builder 3.0
Next Topic: assigning global.variables to local
Goto Forum:
  


Current Time: Fri Mar 29 00:52:35 CDT 2024