User Profile

Collapse

Profile Sidebar

Collapse
ordit
ordit
Last Activity: Aug 16 '08, 01:47 PM
Joined: Aug 10 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ordit
    replied to sql query with txt para
    in Visual Basic
    hey i found it!

    i changed the host para type to str!
    See more | Go to post

      Leave a comment:

    • ordit
      started a topic sql query with txt para
      in Visual Basic

      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"....
      See more | Go to post
      • ordit
        replied to use command connecting datagrid to database
        in Visual Basic
        Thanks!!!
        it works!! (:
        _______________ ____...
        See more | Go to post

          Leave a comment:

        • ordit
          started a topic use command connecting datagrid to database
          in Visual Basic

          use command connecting datagrid to database

          hey everybody!, Im new in the forum & to vb6.
          I want to connect a datagrid with the
          .datasource, .datamember prperties.
          my command requires a parameter:
          select order,name from tabe1 where order=?
          during run of the program i try to attach the datagrid like so:
          datagrid.dataso urce = "dataenvironmen t1"
          datagrid.datame mber = "my_command " & ordr_num.text

          **...
          See more | Go to post
          No activity results to display
          Show More
          Working...