Re: HELP: How to generate sequential Primary Keys on a master-detail form?
Date: Tue, 23 Apr 2002 05:13:23 GMT
Message-ID: <T36x8.5881$df1.2631021605_at_newssvr14.news.prodigy.com>
other resources
"IF" <tlfbi98_at_terra.es> wrote in message
news:qtp6busn2ci5rh6ho4232g3e8suit35mmm_at_4ax.com...
> Thanks a lot for your answers.
>
> In order to not post the same answer in two different threads, please
> read my answer to the message "Re: HELP: How to generate sequential
> Primary Keys on a maste"
>
> Thanks again
>
> On Mon, 01 Apr 2002 16:09:51 GMT, IF <tlfbi98_at_terra.es> wrote:
>
> >We have a master-detail form and we need to generate sequential
> >primary keys values for the records of the master block just before
> >inserting them into the database.
> >
> >We cannot use Oracle Sequences because we cannot lose any value in the
> >sequence. Therefore, in order to generate the sequential values for
> >the primary key, we have to use a value stored in another table.
> >
> >Anyone could give us advice on how to solve this problem when using
> >Forms Builder? (how and where to establish the lock, what Forms
> >triggers to use, how to establish the master-detail relationship since
> >the values of the primary keys will not be known until commit time,
> >etc.)
> >
> >thanks in advance
> >.
> >.
> >.
> >.
> >.
> >.
> >.
> >.
> >.
> >.
> >.
> >.
> >.
> >.
> >.
> >.
> >.
> >.
> >
> >.
> >.
> >.
> >..
> >
> >.
> >.
> >.
> >.
> >.
> >.
> >..
> >
> >..
> >.
> >.
> >.
> >.
> >.
> >.
> >
> >.
> >.
> >.
> >.
> >
> >.
> >.
> >.
> >.
> >.
> >.
> >.
> >.
> >.
> >..
>
yiwan.ching_at_sun.com
sylvia.zele_at_sun.com
privacy_at_sun.com
sunware_at_promark.com
amy.maclennan_at_corp.sun.com
dcbpolls_at_sun.com
es-support_at_argentina.sun.com
suporte_at_brazil.sun.com
eservice_at_chile.sun.com
soporte_at_colombia.sun.com
sc.japan_at_Japan.Sun.COM
soporte_at_sunmexico.sun.com
info_at_sunmexico.sun.com
uk-response_at_farn-home.UK.Sun.COM
ven-techopsteam_at_venezuela.sun.com
sponsorships_at_sun.com
hq_at_asug.com
Sun_at_America.Latina
webmaster_at_czech.sun.com
janos.szkurka_at_hungary.sun.com
info_at_poland.sun.com
template_at_sun.com
request_at_returns.ebay.sun.com
kneil_at_aethersystems.com
dw-info_at_sun.com
cpcsales_at_sun.com
jonathan.fox_at_sun.com
exec_focus_at_Central.sun.com
14_at_126.cP37aamNbpH
netscape6-feedback_at_eng.sun.com
templates_at_sun.com
csr-customer-service_at_sun.com
order_status_at_sun.com
scsl_license_at_sun.com
doc_feedback_at_sun.com
corppub_at_iuniverse.com
yourname_at_sun.com
blueprints_at_sun.com
swing-feedback_at_java.sun.com
folder_at_134.KBTXaaO5aIw
folder_at_111.1ALva7lYaVk
folder_at_31.RZ7jalsAbn9
14_at_149.Z8ZAapI3e4F
discuss_at_sunsource.net
soldc_online_polls_at_sun.com
esd_customer_service_at_sun.com
globalwebmaster_at_sun.com
15_at_163.Nk2Ladtrcq6
18_at_163.Nk2Ladtrcq6
15_at_177.V0laaXIedri
yourname_at_domain.com
rweeks_at_eng.sun.com
basysop_at_sun.com
SolDCpolls_at_sun.com
mrbill_at_sunhelp.org
drew.wrenn_at_sun.com
www.microsoft.com_at_dmoz.org
basubmittals_at_eng.sun.com
iplanetchannel_at_sun.com
partnerweb-feedback_at_sfbay.sun.com
mysun_at_sun.com
j1papers_at_sun.com
j1webmaster_at_sun.com
bobbie_isas_at_us.ibm.com
sam_costello_at_idg.com
franke.smith_at_sun.com
mparkinson_at_alexanderogilvy.com
jo.chun_at_sun.com
julia.zhang_at_sun.com
mark.paisley_at_sun.com
maria.squicciarini_at_sun.com
karen.zamel_at_sun.com
realitycheck-feedback_at_sun.com
rc_ip_feedback_at_sun.com
nicola.busick_at_sun.com
judy.democker_at_sun.com
newsletters_at_sun.com
andy.lark_at_sun.com
aaron.cohen_at_sun.com
beth.pampaloni_at_sun.com
diane.carlini_at_sun.com
penelope.bruce_at_sun.com
carrie.motamedi_at_sun.com
judy.kaneko_at_sun.com
cinthia.portugal_at_sun.com
prentiss.donohue_at_sun.com
sam.moulton_at_sun.com
randy.schultz_at_sun.com
kasey.holman_at_sun.com
debbie.walery_at_sun.com
susie.quitter_at_sun.com
liza.santos_at_sun.com
sabrina.guttman_at_sun.com
martin.chorich_at_sun.com
ann.oleary_at_sun.com
russ.castronovo_at_sun.com
marie.domingo_at_sun.com
jim.grisanzio_at_sun.com
corina.ulescu_at_sun.com
melissa.pereira_at_sun.com
may.goh_at_sun.com
kim.evans_at_sun.com
brett.smith_at_sun.com
laura.ramsey_at_sun.com
jennifer.doettling_at_sun.com
tracy.matsumoto_at_sun.com
nicole.taggart_at_sun.com
elizabeth.mcnichols_at_sun.com
deana.alvy_at_sun.com
ingrid.kambe_at_sun.com
terri.nissen_at_sun.com
michael.zeglin_at_sun.com
chris.lagrand_at_sun.com
ceo_at_sun.com
scottmcnealy_at_sun.com
angie.devlin_at_sun.com
editor_at_bigbluesmoke.com
teleleads_at_central.sun.com
contact-us_at_sun.com
IIedesgnkit_at_sun.com
lisa.ruecker_at_sun.com
doron.aronson_at_sun.com
sbettencourt_at_alexanderogilvy.com
Greg.Bardsley_at_sun.com
15_at_38.JlTlazcYeNA
weimin.wang_at_sun.com
readers_at_gimlet.eng.sun.com
laura.schmidt_at_ogilvypr.com
jimmy.huang_at_sun.com
diana.reed_at_sun.com
celia.chase_at_sun.com
kim.mason_at_sun.com
julie.uiterwijk_at_sun.com
Otto.Wright_at_sun.com
dottie.wanat_at_sun.com
kdelaney_at_alexanderogilvy.com
allison.kelley_at_sun.com
bevans_at_apple.com
Caroline.Ohlson_at_lme.ericsson.se
Paula.Angel-Jones_at_am1.ericsson.se
edoyne_at_alexanderogilvy.com
Julie.Uiterwijk_at_corp.sun.com
akimber_at_alexanderogilvy.com
I_found_the_fives_at_sun.com
linda.hein_at_sun.com
dawn.marshall_at_sun.com
suzanne.eaton_at_sun.com
dlarusso_at_alexanderogilvy.com
laura.schmidt_at_sun.com
ehurley_at_alexanderogilvy.com
emcelroy_at_citigatecunningham.com
mripperger_at_citigatecunningham.com
tim.mooney_at_sun.com
Karena.Reynolds_at_sun.com
henry.kennedy_at_sun.com
SBU61_at_sun.com
J2EEBluePrints-interest_at_java.sun.com
webcast-alert_at_sun.com
scottg.mcnealy_at_sun.com
investor-relations_at_sun.com
support_at_broadware.com
getjava-showcase_at_sun.com
jackson.wong_at_sun.com
sun.com-templates_at_sun.com
resumes_at_sun.com
mproulx_at_volunteerexchange.org
ebonesteel_at_vcsmco.org
lizg_at_vcsmco.org
sonia_at_uwmv.org
paul_at_edinburghvolunteers.org
mike.potter_at_uk.sun.com
corpaffrs_at_Corp.Sun.Com
lizg_at_volunteerconnection.cnchost.com
ehs_at_sun.com
SUPerG_at_sun.com
studentzonefeedback_at_sun.com
java-jobs_at_israel.sun.com
mike.mogensen_at_belgium.sun.com
ljacobs_at_belgium.sun.com
maud.manzen_at_sweden.sun.com
Alex.Sinclair_at_uk.sun.com
hotjobs_at_ireland.sun.com
rh_at_brazil.sun.com
trademarks_at_sun.com
marketing_at_java.sun.com
copyright_at_sun.com
auctions.sun.com_at_sun.com
ses_auctions_at_sun.com
auctions.sun.com_at_corp.sun.com
feedback-auction_at_sun.com
eritchie_at_pacbell.net
michelle_at_auctionwatch.com
SSSupportRepr_at_loa.eng.sun.com
license_at_Sun.com
eu-licensing_at_UK.sun.com
license_at_rrd.co.jp
nfo_at_portugal.sun.com
info_at_portugal.sun.com
john.doe_at_somewhere.com
edu_website_contact_at_eng.sun.com
oemweb_at_sun.com
MPesler_at_spoerle.com
ph_at_microtronica.dk
paul.ojavien_at_microtronica.fi
ablanc_at_microtronica.fr.com
ascholz_at_spoerle.com
avik_at_ankor.co.il
SenadB_at_microtronica.no
msalguero_at_arrowiberia.com
jorgen_at_microtronica.se
jpape_at_spoerle.com
vgasser_at_spoerle.com
sales_at_ideal.co.uk
jsmith_at_microtronicauk.com
ipc_at_capax.se
ipc_at_capax.fr
info_at_ibus.fr
kitmicro_at_attglobal.net
info_at_quavis.fr
g.kroeger_at_atxx.de
mschustereder_at_de.azzurri.com
hesc_at_ganycomp.com
sales_at_ibus-deutschland.de
sales_at_pyramid.de
hgr_at_ractech.de
ipc_at_capax.it
mferranti_at_delfo.it
paul_at_sovintel.ru
sbrown_at_gnp.com
ipc_at_capax.co.uk
bfryer_at_uk.azzurri.com
bill_at_broadberry.co.uk
jeremy.bruty_at_centerprise.co.uk
gary_at_ccpu.com
adam_clark_at_europeone.com
sales_at_ibus.com
grh_at_icsadvent.co.uk
sales_at_westekuk.com
timo.juutilainen_at_expressfinland.com
Billy.Foo_at_mayerkrieg.com.sg
vg_at_gthome.com
edwin.chu_at_rti.com.hk
yaginuma_at_tkmkd.mitsui.co.jp
m_kawahara_at_shinden.co.jp
ycchen_at_ultra.com.tw
george_at_axus.com.tw
andre_at_ood2.tatung.com.tw
jkuo_at_htsd.sertek.com.tw
gary_at_donovan.com.sg
Mayer_Embedded_at_mayerkrieg.com.au
dromanelli_at_nuhorizons.com
kkalb_at_ccpu.com
sales_at_tadpole.com
chris.marzilli_at_gdcs.com
rbaar_at_gnp.com
chrisw_at_pinnacle.com
rdarter_at_rave.com
jgeorge_at_themis.com
Mainframe-Affinity_at_sun.com
emarketing_dallas_at_central.sun.com
Marylou.Bolduc_at_sun.com
LeaseDesk_AS_at_eng.sun.com
LeaseDesk_GC_at_eng.sun.com
LeaseDesk_Jap_at_eng.sun.com
LeaseDesk_Korea_at_eng.sun.com
LeaseDesk_ANZ_at_eng.sun.com
suzanne.eaton_at_ebay.sun.com
darcy_harrison_at_sfo.bm.com
govt-feedback_at_sun.com
govt-online_at_sun.com
gary.balog_at_Sun.COM
mike.dibiase_at_gdc4s.com
phillip.wieser_at_Sun.COM
rannett_at_c3smail.monmouth.army.mil
moreilly_at_logicon.com
jstegall_at_logicon.com
vince.pratuch_at_sun.com
erich.meding_at_Sun.COM
SASS2_at_Sun.Com
thomas.bub_at_Sun.COM
TACJW_at_Sun.Com
Johnny.Daly_at_Gunter.af.mil
Claude.Kentner_at_gunter.af.mil
daniel.vaughn_at_trw.com
todd.florey_at_west.Sun.COM Received on Tue Apr 23 2002 - 07:13:23 CEST