SQL OPEN Error

[I H LIM]

Hi all,
   
  I have difficulties on executing sql statement through cursor in QUICK. Below is my statement :
   
  let tmp_where_cnt = 0
  let tmp_where = "where"
  if tmp_a <> ""
  then begin
    let tmp_where = " name = '"+tmp_a+"'"
    let tmp_where_cnt = 1
  end
   
  if tmp_b <> ""
  then begin
    if tmp_where_cnt = 1
    then let tmp_where = tmp_where + "and ic_no = '"+tmp_b+"'"
    else let tmp_where = tmp_where + "ic_no = '"+tmp_b+"'"
  end
   
  .....
   
  SQL OPEN "cursor_name" where ((tmp_where))

  ----------------------------------------------
   
  I need to substitute the "WHERE" statement using the "tmp_where" field.
  Can SQL statement in Powerhouse able to be substituted as above?
  For your information, I'm running Powerhouse Web Version 8.4D1 under Windows platform using Axiant 3.4D1
   
  Thank You
   
  Regards
  Kim Han
   
   

		
---------------------------------
Brings words and photos together (easily) with
 PhotoMail  - it's free and works with Yahoo! Mail.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060209/8c813c55/attachment.html