Results 1 to 2 of 2

Thread: Help

  1. #1
    Join Date
    Jul 2002
    Posts
    1

    Red face Unanswered: Help

    I have a prb on the accessing db2 by foxpro
    HERE is my code
    CREATE SQL VIEW grnviewtemp CONNECTION myConn as ;
    SELECT GDGRNN, GDCRWS, GDPROD, GDPORD, GDVEND, GDRCQT, GDCRDT, GDSADN ;
    FROM HGDL01 WHERE GDGRNN< testno ORDER BY GDGRNN

    U can c testno which is a variable storing 30, but I cannot access the database. It throws error SQL0206
    How can I solve it?

  2. #2
    Join Date
    Apr 2002
    Posts
    188
    check this thread it may be usefull

    http://dbforums.com/archive/8/2002/03/2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •