SCOUG-Programming Mailing List Archives

<< Previous Message << >> Next Message >>

Date:	Wed, 6 Aug 2003 23:03:13 PDT7
From:	"Steven Levine" <steve53@earthlink.net >
Reply-To:	scoug-programming@scoug.com
To:	scoug-programming@scoug.com
Subject:	SCOUG-Programming: Re: Warpstock 2003 Presentation

In <200308070532.h775WAoM023178@mta4.rcsntx.swbell.net>, on 08/06/03
at 10:30 PM, "Lynn H. Maxson" said:

>That more
>do in SQL than any other language

Got a reference for this? My empirical belief has been that more program
in Visual Basic than any other language.

Also, FWIW, anyone who does serious SQL programming also does a lot of SPL
programming which has all the same control structures you will find in
your everyday programming language.

Somone will have to explain to me how the following in based on logic
programming:

create trigger "xxxxx".ins_on_inv_trans
insert on "informix".inv_trans
referencing new as new_rec
for each row (
insert into "xxxxx".inv_trans_std_cost(tr_id, it_dir_lbr,
it_matl, it_matf,
it_subc,
it_ind_lbr,
it_fix_oh,
it_var_oh,
it_c_dir_lbr,
it_c_matl,
it_c_matf,
it_c_subc,
it_c_ind_lbr,
it_c_fix_oh,
it_c_var_oh) select
new_rec.tr_id, x0.it_dir_lbr, x0.it_matl, x0.it_matf, x0.
it_subc, x0.it_ind_lbr, x0.it_fix_oh, x0.it_var_oh, x0.
it_c_dir_lbr, x0.it_c_matl, x0.it_c_matf, x0.it_c_subc,
x0.
it_c_ind_lbr, x0.it_c_fix_oh, x0.it_c_var_oh from
"informix".part x0 where((x0.it_part_nbr =
new_rec.tr_part_nbr)
and
(x0.it_rev = new_rec.tr_rev)));

I will agree that it is logically correct code, if that is what meant. Of
course that was proven by inspection ad QA testing which are two of the
accepted form of requirements verification.

Steven

--
----------------------------------------------------------------------
"Steven Levine" MR2/ICE 2.37 #10183 Warp4/FP15/14.093c_W4
www.scoug.com irc.webbnet.info irc.fyrelizard.org #scoug (Wed 7pm PST)
----------------------------------------------------------------------

=====================================================

To unsubscribe from this list, send an email message
to "steward@scoug.com". In the body of the message,
put the command "unsubscribe scoug-programming".

For problems, contact the list owner at
"rollin@scoug.com".

=====================================================

Return to [ 06 | August | 2003 ]

SCOUG, Warp Expo West, and Warpfest are trademarks of the Southern California OS/2 User Group. OS/2, Workplace Shell, and IBM are registered trademarks of International Business Machines Corporation. All other trademarks remain the property of their respective owners.