<div>Hi all,</div> <div> </div> <div>I have difficulties on executing sql statement through cursor in QUICK. Below is my statement :</div> <div> </div> <div>let tmp_where_cnt = 0</div> <div>let tmp_where = "where"</div> <div>if tmp_a <> ""</div> <div>then begin</div> <div> let tmp_where = " name = '"+tmp_a+"'"</div> <div> let tmp_where_cnt = 1</div> <div>end</div> <div> </div> <div>if tmp_b <> ""</div> <div>then begin</div> <div> if tmp_where_cnt = 1</div> <div> then let tmp_where = tmp_where + "and ic_no = '"+tmp_b+"'"</div> <div> else let tmp_where = tmp_where + "ic_no = '"+tmp_b+"'"</div> <div>end</div> <div> </div> <div>.....</div> <div> </div> <div>SQL OPEN "cursor_name" where ((tmp_where))<BR></div> <div>----------------------------------------------</div> <div> </div> <div>I need to substitute the "WHERE" statement using the "tmp_where"
field.</div> <div>Can SQL statement in Powerhouse able to be substituted as above?</div> <div>For your information, I'm running Powerhouse Web Version 8.4D1 under Windows platform using Axiant 3.4D1</div> <div> </div> <div>Thank You</div> <div> </div> <div>Regards</div> <div>Kim Han</div> <div> </div> <div> </div><p>
<hr size=1>Brings words and photos together (easily) with<br>
<a href="http://us.rd.yahoo.com/mail_us/taglines/PMDEF3/*http://photomail.mail.yahoo.com">PhotoMail </a> - it's free and works with Yahoo! Mail.