Home » Developer & Programmer » Forms » 2 blocks...2 stored procedures..common values.
2 blocks...2 stored procedures..common values. [message #83373] Wed, 01 October 2003 08:21 Go to next message
bluebyte
Messages: 25
Registered: September 2003
Junior Member
hi all!
my form has 2 blocks..
block 1 contains items a,b,c,d,e,f,g
block 2 contains items j,k,l.

block 1 refers to db table 1.
block 2 refers to db table 2.

now,the the values in :block1.a/b/c are required to
be inserted into table 2 also.

so, i created 2 SPs.. the parameters for which are sent
from 2 form procedures viz. fp_add_tab1, fp_add_tab2.

for the common values, am using :block1.a,:block1.b,
:block1.c in both the procudures.

fp_add_tab1 is sending all the parameters.

** but, fp_add_tab2 is sending null values in parameters :block1.a,:block1.b,:block1.c

can't i use :block1 item values along with :block2 values??

also, i tried to store :block1.a/b/c into variables & sent those variables as parameters in fp_add_tab2..
but,no luck!!!
am getting *cannot insert NULL error*...

pls help me fix this one...

thnx.

Report message to a moderator

Re: 2 blocks...2 stored procedures..common values. [message #83385 is a reply to message #83373] Fri, 03 October 2003 01:21 Go to previous message
LT
Messages: 29
Registered: August 2003
Junior Member
store the values as global variables instead. you are doing something with navigation.

Report message to a moderator

Previous Topic: forms built-in : create_record/delete_record
Next Topic: Triggers
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 03:52:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.