Greetings,
I was able to get Dolphin 4 Pro at work, but
the shop standards are Visual C++ and java,
so I'm quite isolated.
I would like to exchange ideas on using Dolphin
for database work with the worldwide Dolphin
user community. I'm thinking I could start
a Database category on the Dolphin Wiki
to exchange ideas and code snippets.
I don't see any database related category
on the wiki now, so I wonder if there is any interest.
I've started writing a helper class for
prepared statements. I've attached what I came up
with in my first session.
begin 666 CraigDBPreparedInsert.cls
M(D9I;&5D(&]U="!F<F]M($1O;'!H:6X@4VUA;&QT86QK(#(P,# @<F5L96%S
M92 T+C B(0T*#0I/8FIE8W0@<W5B8VQA<W,Z("-#<F%I9T1"4')E<&%R961)
M;G-E<G0-"@EI;G-T86YC959A<FEA8FQE3F%M97,Z("=T86)L92!A;&Q&:65L
M9',@<')E<&%R961&:65L9',@<')E<&%R9613=&%T96UE;G0G#0H)8VQA<W-6
M87)I86)L94YA;65S.B G)PT*"7!O;VQ$:6-T:6]N87)I97,Z("<G#0H)8VQA
M<W-);G-T86YC959A<FEA8FQE3F%M97,Z("<G(0T*0W)A:6=$0E!R97!A<F5D
M26YS97)T(&-O;6UE;G0Z("<B(%-U<'!O<G0@9F]R('!R97!A<F5D(&EN<V5R
M=" B#0HB(&%$0D-O;FYE8W1I;VX@851A8FQE3F%M92!&:65L9'-.86UE<R B
M#0HB('!R97!A<F5);G-E<G1$0CH@841"0V]N;F5C=&EO;B!T86)L93H@851A
M8FQE3F%M92!F:65L9',Z($9I96QD<TYA;65S("(G(0T*#0I#<F%I9T1"4')E
M<&%R961);G-E<G0@9W5I9#H@*$=5240@9G)O;5-T<FEN9SH@)WLX-#DT13(V
M,2U$.#E!+3$Q1#0M.3A%-BTP,#0P,#5!,#0X1C5])RDA#0H-"B%#<F%I9T1"
M4')E<&%R961);G-E<G0@8V%T96=O<FEE<T9O<D-L87-S(55N8VQA<W-I9FEE
M9"$@(0T*(4-R86EG1$)0<F5P87)E9$EN<V5R="!M971H;V1S1F]R(0T*#0II
M;G-E<G13=')I;F<-"B(@:6YS97)T(&EN=&\@4W5P<&QI97)S("A#;VUP86YY
M3F%M92P@2&]M95!A9V4I('9A;'5E<R H/RP@/RD@(@T*?"!S<R!\#0IS<R Z
M/2!7<FET95-T<F5A;2!W:71H.B H4W1R:6YG(&YE=RDN#0IS<R!N97AT4'5T
M06QL.B G:6YS97)T(&EN=&\@)SL@(&YE>'10=71!;&PZ('1A8FQE.R!N97AT
M4'5T06QL.B G("@@)RX-"G!R97!A<F5D1FEE;&1S(&1O.B!;(#IE86-H1FEE
M;&0@?"!S<R!N97AT4'5T06QL.B G("<[(&YE>'10=71!;&PZ("AE86-H1FEE
M;&0@;F%M92D[(&YE>'10=71!;&PZ("<L)R!=+@T*<W,@<&]P.R!N97AT4'5T
M06QL.B G("D@=F%L=65S("@@)RX-"BAP<F5P87)E9$9I96QD<R!S:7IE*2!T
M:6UE<U)E<&5A=#H@6R!S<R!N97AT4'5T06QL.B G(#\L)R!=+@T*<W,@<&]P
M.R!N97AT4'5T06QL.B G("DG+@T*7G-S(&-O;G1E;G1S(0T*#0IP<F5P87)E
M26YS97)T1$(Z(&%$0D-O;FYE8W1I;VX@=&%B;&4Z(&%486)L94YA;64@9FEE
M;&1S.B!&:65L9'-.86UE<PT*=&%B;&4@.CT@851A8FQE3F%M92X-"F%L;$9I
M96QD<R Z/2!A1$)#;VYN96-T:6]N(&-O;'5M;G,Z(&%486)L94YA;64N#0IP
M<F5P87)E9$9I96QD<R Z/2!/<F1E<F5D0V]L;&5C=&EO;B!N97<N#0I&:65L
M9'-.86UE<R!D;SH@6R Z96%C:$9I96QD('P@<')E<&%R961&:65L9',@861D
M3&%S=#H@*"AA;&Q&:65L9',@<V5L96-T.B!;(#IC:&5C:R!\("AC:&5C:R!N
M86UE*2!S86UE07,Z(&5A8VA&:65L9"!=*2!A=#H@,2D@72X-"G!R97!A<F5D
M4W1A=&5M96YT(#H](&%$0D-O;FYE8W1I;VX@<')E<&%R93H@*'-E;&8@:6YS
M97)T4W1R:6YG*2X-"G!R97!A<F5D4W1A=&5M96YT('!A<F%M0V]L<SH@*'!R
M97!A<F5D1FEE;&1S(&%S07)R87DI+@T*#0HA("$-"B%#<F%I9T1"4')E<&%R
M961);G-E<G0@8V%T96=O<FEE<T9O<CH@(VEN<V5R=%-T<FEN9R$J+75N8VQA
M<W-I9FEE9"%P=6)L:6,A("$-"B%#<F%I9T1"4')E<&%R961);G-E<G0@8V%T
M96=O<FEE<T9O<CH@(W!R97!A<F5);G-E<G1$0CIT86)L93IF:65L9',Z(2HM
:=6YC;&%S<VEF:65D(7!U8FQI8R$@(0T*#0H`
`
end
Locked
