sql query with txt para

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ordit
    New Member
    • Aug 2008
    • 4

    sql query with txt para

    hey everybody

    im having a trouble with a command i wrote:
    select KCLIENT from CLIENTS where CLIENTNAME=?

    the command sould receive a txt parameter- i guess i just dont know how to define it properly. .
    CLIENTNAME is defined on my database as VARCHAR2(8 BYTE)
    how do i let vb know that?
    i see that in the command tab, there is an option to define para type-
    i tried "adunkown".

    ______
    "type mistake" while command1 client_name.tex t

    thank you in advance!!
  • ordit
    New Member
    • Aug 2008
    • 4

    #2
    hey i found it!

    i changed the host para type to str!

    Comment

    Working...