Newbie2 error 936 Missing Expression

From: <ywure_at_interaccess.com>
Date: Sat, 13 Nov 99 16:37:01 GMT
Message-ID: <s2r4tgnthsq63_at_corp.supernews.com>

[Quoted] College Student needs help

I keep getting a missing expression error. I've used number and varchar and various insert combinations and can't rid the error message. Professor suggested what I am using now for product_make_table. No success.

have attached a spool file and the two sql files needed.

Thanx

Jim Quinlan

begin 644 usenet.LST
M<W1A<G0_at_<')O9'5C=%]M86ME7W1A8FQE+G-Q;#L-"E-13#X_at_0U)%051%(%1! M0DQ%(%!23T150U0-"B`_at_,B`@*%!?0T]$10D@("`@(%9!4D-(05(R*#$P*2`@ M("!.3U0_at_3E5,3`D@("`@(%!224U!4ED_at_2T59+`T*("`S("!07T1%4T-225!4 M(`D_at_("`@(%9!4D-(05(R*#,U*2`@("!.3U0_at_3E5,3"P-"B`_at_-"`_at_4%])3D1!

M5$4)"2`_at_("`_at_1$%410D)("`@("!.3U0_at_3E5,3"P-"B`_at_-2`_at_4%]/3DA!3D0)
M"2`_at_("`_at_3E5-0D52*#,I+`T*("`V("!07TU)3_at_D)("`@("!.54U"15(H,RD)
M"2`_at_("`_at_3D]4($Y53$PL#0H@(#<@(%!?4%))0T4)("`@("!.54U"15(H-BPR
M*0D_at_("`@($Y/5"!.54Q,+`T*("`X("!07T1)4T-/54Y4(`D@("`@($Y534)%

M4B_at_T+#(I"2`@("`_at_3D]4($Y53$PL#0H@(#D@(%9?0T]$10D@("`@(%9!4D-( M05(R*#4I("`_at_("!.54Q,#0H@,3`@("D-"B`Q,2`@+PT*4U%,/B!S=&%R="!P M<F]D=6-T7V%D9%]P<F]D=6-T+G-Q;#L-"E-13#X_at_<V5T(&1E9FEN92!O9F8- M"E-13#X_at_24Y315)4($E.5$\@4%)/1%5#5"!604Q515,H)S$Q4452+S,Q)RP@

M("=0;W=E<B!086EN=&5R+"`Q-7!S:2P_at_,RUN;WIZ;&4G+`D)("`@("`G,#(M
M1&5C+3DV)RP_at_("`@."P@("`@("`U+"`@("`@(#$P.2XY.2P)("`@("`P+C`P
M+"`_at_(#(U.3DU*3L-"E-13#X_at_24Y315)4($E.5$\@4%)/1%5#5"!604Q515,H
M)S$S+5$R+U`R)RP_at_("<W+C(U+6EN('!W<BX@<V%W(&)L861E)RP)"0D@("`@

M("<Q,BU.;W8M.38G+"`_at_("`S,BP@("`@(#$U+"`@("`@,30N.3DL"2`@("`@ M,"XP-2P_at_("`R,3,T-"D[#0I344P^($E.4T525"!)3E1/(%!23T150U0_at_5D%, M5453*"<Q-"U1,2U,,R<L("`G.2XP,"UI;B!P=W(N('-A=R!B;&%D92<L"0D)

M("`_at_("`G,3(M3F]V+3DV)RP@("`@,3_at_L("`@("`Q,BP@("`@(#$W+C0Y+`D@
M("`_at_(#`N,#`L("`@,C$S-#0I.PT*4U%,/B!)3E-%4E0_at_24Y43R!04D]$54-4
M(%9!3%5%4R_at_G,34T-BU143(G+"`@)TAR9"X_at_8VQO=&@L(#$O-"UI;BP@,E_at_U
M,"<L"0D_at_("`@("<Q-"U!=6<M.38G+"`@("`Q-2P@("`@(#_at_L("`@("`@,SDN
M.34L"2`_at_("`@,"XP,"P@("`R,S$Q.2D[#0I344P^($E.4T525"!)3E1/(%!2
M3T150U0_at_5D%,5453*"<Q-34X+5%7,2<L("`G2')D+B!C;&]T:"P@,2\R+6EN
M+"`S6#4P)RP)"2`_at_("`@)S$T+4%U9RTY-B<L("`@(#(S+"`@("`_at_-2P@("`@
M("`T,RXY.2P)("`_at_("`P+C`P+"`@(#(S,3$Y*3L-"E-13#X_at_24Y315)4($E.

M5$\_at_4%)/1%5#5"!604Q515,H)S(R,S(O4519)RP@("=")D0@:FEG<V%W+"`Q

M,BUI;BP_at_8FQA9&4G+`D)("`@("`G,CDM3V-T+3DV)RP@("`@."P@("`@("`U
M+"`_at_("`@(#$P.2XY,BP)("`@("`P+C`U+"`@(#(T,C_at_X*3L-"E-13#X_at_24Y3
M15)4($E.5$\_at_4%)/1%5#5"!604Q515,H)S(R,S(O45=%)RP@("=")D0@:FEG

M<V%W+"`X+6EN+"!B;&%D92<L(`D)("`_at_("`G,#DM4V5P+3DV)RP@("`_at_-BP@ M("`_at_("`U+"`@("`@(#DY+C_at_W+`D@("`@(#`N,#4L("`@,C0R.#_at_I.PT*4U%, M/B!)3E-%4E0_at_24Y43R!04D]$54-4(%9!3%5%4R_at_G,C(S."]14$0G+"`@)T(F

M1"!C;W)D;&5S<R!D<FEL;"P_at_,2\R:6XG+`D)("`@("`G,3DM3V-T+3DV)RP@
M("`_at_,3(L("`@("`U+"`@("`@(#,X+CDU+`D@("`@(#`N,#4L("`@,C4U.34I
M.PT*4U%,/B!)3E-%4E0_at_24Y43R!04D]$54-4(%9!3%5%4R_at_G,C,Q,#DM2$(G
M+"`_at_)T-L87<@:&%M;65R)RP)"0D)("`@("`G,3DM3F]V+3DV)RP@("`@,C,L

M("`_at_("`Q,"P@("`@(#DN.34L"0D@("`@(#`N,3`L("`@,C$R,C4I.PT*4U%, M/B!)3E-%4E0_at_24Y43R!04D]$54-4("A07T-/1$4L4%]$15-#4DE05"Q07TE. M1$%412Q07T].2$%.1"Q07TU)3BQ07U!224-%+%!?1$E30T]53E0I(%9!3%5% M4R_at_G,C,Q,30M04$G+"`@("=3;&5D9V4@:&%M;65R+"`Q,B!L8BXG+`D)"2`@ M("`_at_)S`Q+41E8RTY-B<L("`@(#_at_L("`@("`_at_-2P@("`@("`Q-"XT,"P)("`@ M("`P+C`U+"`I(#L-"DE.4T525"!)3E1/(%!23T150U0_at_*%!?0T]$12Q07T1% M4T-225!4+%!?24Y$051%+%!?3TY(04Y$+%!?34E.+%!?4%))0T4L4%]$25-# M3U5.5"D_at_5D%,5453*"<R,S$Q-"U!02<L"2=3;&5D9V4@:&%M;65R+"`Q,B!L

M8BXG+`D)"2<P,2U$96,M.38G+`DX+`DU+`DQ-"XT,"P)"3`N,#4L("D)#0H_at_
M("`_at_("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
M("`_at_("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
M("`_at_("`@("`@(`D@("`@("`@("`@("`@("`@("`@("`@("`)"0D@("`@("`@
M("`_at_("`)("`)("`)("`@("`@"0D@("`@("`J#0I%4E)/4B!A="!L:6YE(#$Z

M(`T*3U)!+3`P.3,V.B!M:7-S:6YG(&5X<')E<W-I;VX_at_#0H-"@T*4U%,/B!) M3E-%4E0_at_24Y43R!04D]$54-4(%9!3%5%4R_at_G-30W-S@M,E0G+"`@)U)A="UT M86EL(&9I;&4L(#$O."UI;BP_at_9FEN92<L"2`@("`@)S$T+4IU;BTY-B<L("`@

M(#0S+"`_at_("`@,C`L("`@("`T+CDY+`D)("`@("`P+C`P+"`@(#(Q,S0T*3L-
M"E-13#X_at_24Y315)4($E.5$\@4%)/1%5#5"!604Q515,H)S_at_Y+5=212U1)RP@
M("=(:6-U="!C:&%I;B!S87<L(#$V(&EN)RP)"0D_at_("`@("<P-BU*=6PM.38G

M+"`_at_("`Q,2P@("`@(#4L("`@("`@,C4V+CDY+`D@("`@(#`N,#`L("`@,C0R M.#_at_I.PT*4U%,/B!)3E-%4E0_at_24Y43R!04D]$54-4("`H4%]#3T1%+%!?1$53 M0U))4%0L4%])3D1!5$4L4%]/3DA!3D0L4%]-24XL4%]04DE#12Q07T1)4T-/

M54Y4*2!604Q515,H)U!60S(S1%)4)RP_at_("=05D,@<&EP92P@,RXU+6EN+B`X
M+69T)RP)"0D_at_("`@("<Q.2U$96,M.38G+"`@("`Q.#_at_L("`@(#<U+"`@("`@
M-2XX-RP)"2`_at_("`@,"XP,"P@*2`[#0I)3E-%4E0_at_24Y43R!04D]$54-4("`H

M4%]#3T1%+%!?1$530U))4%0L4%])3D1!5$4L4%]/3DA!3D0L4%]-24XL4%]0 M4DE#12Q07T1)4T-/54Y4*2!604Q515,H)U!60S(S1%)4)RP))U!60R!P:7!E M+"`S+C4M:6XN(#_at_M9G0G+`D)"2<Q.2U$96,M.38G+`DQ.#_at_L"3<U+`DU+C_at_W

M+`D)"3`N,#`L("D)#0H_at_("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
M("`_at_("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
M("`_at_("`@("`@("`@("`@("`@("`@("`@("`)("`@("`@("`@("`@("`@("`@
M("`_at_("`@(`D)"2`@("`@("`@("`@(`D@("`@"2`@(`D@("`@(`D)"2`@("`@

M("H-"D524D]2(&%T(&QI;F4_at_,3H@#0I/4D$M,#`Y,S8Z(&UI<W-I;F<@97AP M<F5S<VEO;B`-"_at_T*#0I344P^($E.4T525"!)3E1/(%!23T150U0_at_5D%,5453

M*"=332TQ.#(W-R<L("`G,2XR-2UI;B!M971A;"!S8W)E=RP_at_,C4G+"`)"2`@
M("`_at_)S(X+4YO=BTY-B<L("`@(#$W,BP@("`_at_-S4L("`@("`V+CDY+`D)("`@
M("`P+C`P+"`_at_(#(Q,C(U*3L-"E-13#X_at_24Y315)4($E.5$\@4%)/1%5#5"!6

M04Q515,H)U-7+3(S,3$V)RP_at_("<R+C4M:6X@=V0N('-C<F5W+"`U,"<L"0D)

M("`_at_("`G,#DM4V5P+3DV)RP@("`@,C,W+"`@("`Q,#`L("`@(#_at_N-#4L"0D@
M("`_at_(#`N,#`L("`@,C$R,S$I.PT*4U%,/B!)3E-%4E0_at_24Y43R!04D]$54-4
M(%9!3%5%4R_at_G5U(S+U14,R`G+"`@)U-T965L(&UA='1I;F<L-%_at_X6#$O-B(L

M-2(_at_;65S:"<L"0D@("`@("<Q-BU.;W8M.38G+"`@("`Q."P@("`@(#4L("`@ F("`_at_,3$Y+CDU+`D@("`@(#`N,3`L("`@,C4U.34I.PT*4U%,/B!I
`

end

begin 644 product_make_table.sql
M0U)%051%(%1!0DQ%(%!23T150U0-"BA07T-/1$4)"59!4D-(05(R*#$P*0E. M3U0_at_3E5,3`E04DE-05)9($M%62P-"E!?1$530U))4%0)"59!4D-(05(R*#,U M*0E.3U0_at_3E5,3"P-"E!?24Y$051%"0E$051%"0D)3D]4($Y53$PL#0I07T]. M2$%.1`D)3E5-0D52*#,I+`T*4%]-24X)"0E.54U"15(H,RD)"4Y/5"!.54Q, M+`T*4%]04DE#10D)3E5-0D52*#8L,BD)"4Y/5"!.54Q,+`T*4%]$25-#3U5. M5`D)3E5-0D52*#0L,BD)"4Y/5"!.54Q,+`T*5E]#3T1%"0E605)#2$%2,B_at_U /*2`)3E5,3`T**0T*+PT*
`

end

begin 644 product_add_product.sql
M<V5T(&1E9FEN92!O9F8-"DE.4T525"!)3E1/(%!23T150U0_at_5D%,5453*"<Q M,5%%4B\S,2<L"2=0;W=E<B!086EN=&5R+"`Q-7!S:2P_at_,RUN;WIZ;&4G+`D) M)S`R+41E8RTY-B<L"3_at_L"34L"3$P.2XY.2P)"3`N,#`L"3(U.3DU*3L-"DE. M4T525"!)3E1/(%!23T150U0_at_5D%,5453*"<Q,RU1,B]0,B<L"2<W+C(U+6EN M('!W<BX_at_<V%W(&)L861E)RP)"0DG,3(M3F]V+3DV)RP),S(L"3$U+`DQ-"XY M.2P)"3`N,#4L"3(Q,S0T*3L-"DE.4T525"!)3E1/(%!23T150U0_at_5D%,5453 M*"<Q-"U1,2U,,R<L"2<Y+C`P+6EN('!W<BX_at_<V%W(&)L861E)RP)"0DG,3(M M3F]V+3DV)RP),3_at_L"3$R+`DQ-RXT.2P)"3`N,#`L"3(Q,S0T*3L-"DE.4T52 M5"!)3E1/(%!23T150U0_at_5D%,5453*"<Q-30V+5%1,B<L"2=(<F0N(&-L;W1H M+"`Q+S0M:6XL(#)8-3`G+`D)"2<Q-"U!=6<M.38G+`DQ-2P)."P),SDN.34L M"0DP+C`P+`DR,S$Q.2D[#0I)3E-%4E0_at_24Y43R!04D]$54-4(%9!3%5%4R_at_G M,34U."U15S$G+`DG2')D+B!C;&]T:"P_at_,2\R+6EN+"`S6#4P)RP)"0DG,30M

M075G+3DV)RP),C,L"34L"30S+CDY+`D),"XP,"P),C,Q,3DI.PT*24Y315)4
M($E.5$\_at_4%)/1%5#5"!604Q515,H)S(R,S(O4519)RP))T(F1"!J:6=S87<L
M(#$R+6EN+"!B;&%D92<L"0D))S(Y+4]C="TY-B<L"3_at_L"34L"3$P.2XY,BP)
M"3`N,#4L"3(T,C_at_X*3L-"DE.4T525"!)3E1/(%!23T150U0_at_5D%,5453*"<R

M,C,R+U%712<L"2=")D0_at_:FEG<V%W+"`X+6EN+"!B;&%D92<L"0D))S`Y+5-E M<"TY-B<L"38L"34L"3DY+C_at_W+`D),"XP-2P),C0R.#_at_I.PT*24Y315)4($E. M5$\_at_4%)/1%5#5"!604Q515,H)S(R,S_at_O45!$)RP))T(F1"!C;W)D;&5S<R!D M<FEL;"P_at_,2\R:6XG+`D)"2<Q.2U/8W0M.38G+`DQ,BP)-2P),S_at_N.34L"0DP M+C`U+`DR-34Y-2D[#0I)3E-%4E0_at_24Y43R!04D]$54-4(%9!3%5%4R_at_G,C,Q M,#DM2$(G+`DG0VQA=R!H86UM97(G+`D)"0D))S$Y+4YO=BTY-B<L"3(S+`DQ M,"P).2XY-2P)"0DP+C$P+`DR,3(R-2D[#0I)3E-%4E0_at_24Y43R!04D]$54-4 M("A07T-/1$4L4%]$15-#4DE05"Q07TE.1$%412Q07T].2$%.1"Q07TU)3BQ0 M7U!224-%+%!?1$E30T]53E0I(%9!3%5%4R_at_G,C,Q,30M04$G+`DG4VQE9&=E M(&AA;6UE<BP_at_,3(@;&(N)RP)"0DG,#$M1&5C+3DV)RP)."P)-2P),30N-#`L M"0DP+C`U+"`I"3L-"DE.4T525"!)3E1/(%!23T150U0_at_5D%,5453*"<U-#<W M."TR5"<L"2=2870M=&%I;"!F:6QE+"`Q+S_at_M:6XL(&9I;F4G+`D))S$T+4IU M;BTY-B<L"30S+`DR,"P)-"XY.2P)"0DP+C`P+`DR,3,T-"D[#0I)3E-%4E0_at_ M24Y43R!04D]$54-4(%9!3%5%4R_at_G.#DM5U)%+5$G+`DG2&EC=70_at_8VAA:6X@ M<V%W+"`Q-B!I;B<L"0D))S`V+4IU;"TY-B<L"3$Q+`DU+`DR-38N.3DL"0DP M+C`P+`DR-#(X."D[#0I)3E-%4E0_at_24Y43R!04D]$54-4("`H4%]#3T1%+%!? M1$530U))4%0L4%])3D1!5$4L4%]/3DA!3D0L4%]-24XL4%]04DE#12Q07T1) M4T-/54Y4*2!604Q515,H)U!60S(S1%)4)RP))U!60R!P:7!E+"`S+C4M:6XN

M(#_at_M9G0G+`D)"2<Q.2U$96,M.38G+`DQ.#_at_L"3<U+`DU+C_at_W+`D)"3`N,#`L
M("D).PT*24Y315)4($E.5$\_at_4%)/1%5#5"!604Q515,H)U--+3$X,C<W)RP)
M)S$N,C4M:6X_at_;65T86P@<V-R97<L(#(U)RP)"0DG,C_at_M3F]V+3DV)RP),3<R

M+`DW-2P)-BXY.2P)"0DP+C`P+`DR,3(R-2D[#0I)3E-%4E0_at_24Y43R!04D]$ M54-4(%9!3%5%4R_at_G4U<M,C,Q,38G+`DG,BXU+6EN('=D+B!S8W)E=RP_at_-3`G

M+`D)"0DG,#DM4V5P+3DV)RP),C,W+`DQ,#`L"3_at_N-#4L"0D),"XP,"P),C$R
M,S$I.PT*24Y315)4($E.5$\_at_4%)/1%5#5"!604Q515,H)U=2,R]45#,@)RP)
M)U-T965L(&UA='1I;F<L-%_at_X6#$O-B(L-2(@;65S:"<L"0DG,38M3F]V+3DV

_at_)RP),3_at_L"34L"3$Q.2XY-2P)"3`N,3`L"3(U-3DU*3LL
`

end Received on Sat Nov 13 1999 - 17:37:01 CET

This message: [ Message body ]
Next message: Robert Francis: "Re: RegSvr32"
Previous message: Dolf-Jan Mulder: "Forms OLE Automation with Word"
Next in thread: Thomas Kyte: "Re: Newbie2 error 936 Missing Expression"
Reply: Thomas Kyte: "Re: Newbie2 error 936 Missing Expression"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message