473,513 Members | 2,562 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

can i extract a perticular column of data to a combo box.

kirubagari
158 New Member
i have a combo box in vb6.0 which i need to get a column of data from oracle database, how can i extract a perticular column of data to a combo box.

Expand|Select|Wrap|Line Numbers
  1. Private Sub SSTab1_DblClick()
  2.  
  3.         Private Sub SSTab1_DblClick()
  4.  
  5.            Dim sSQL As String
  6.            Dim oSQL As New clsSQL
  7.  
  8.            sSQL = " select COMMENT_CODE  FROM CIM_TBL_MULTIPLEHOLD  "
  9.            sSQL = sSQL & "Where STATUS ='Hold ' "
  10.            oSQL.Server = "CATdefault"
  11.            oSQL.SqlCall = sSQL
  12.  
  13.            coReasonCode.Clear
  14.            coReasonCode.AddItem ("")
  15.            'cbopict2.AddItem ""
  16.  
  17.        'BRIEF_DESC,'DESC FROM
  18.            Set oSQL = Nothing
  19.            'Set cRow = Nothing
  20.            '****** START POP FAILSAFE ***********************************
  21. FailSafe_Exit:
  22.            Trace "Exit", 9
  23.            Pop
  24.           Exit Sub
  25. FailSafe_Error:
  26.            ' *** Insert Special Error Handling Here ***
  27.           LogError
  28.            Resume FailSafe_Exit             'default is to exit this procedure
  29.            '*** STOP POP FAILSAFE *******************************************
  30.     End Sub
  31.  
  32.  
sample code but its not working..kindly help
Mar 30 '11 #1
1 1608
VijaySofist
107 New Member
Hi,

Similar question is asked in .Net Framework Section but in VB.Net. Here Solution is given for this. There is no much difference in code. So you can try to use that code.

Link
http://bytes.com/topic/net/answers/6...-database-item

Regards
Vijay.R
Mar 31 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
2038
by: Meyer1228 | last post by:
VB6 - We have three data combo boxes with identical properties, each pointing to a different data file. We're using an odbc driver with a 4th gl indexed database. All that is working beautifully. In properties, match Entry is set to 1-dblExtendedMatching although we've also tried basic matching. The problem is that only one of the data...
2
1428
by: bissatch | last post by:
If I want to determine what data types a table has, how would I do this using PHP? I tried looking into SHOW TABLES but would I be correct in saying that just displays a list of tables? I want some way of analizing a single table and outputing the column data types. Btw, I am using a PostgreSQL database. Cheers
3
21690
by: David M | last post by:
When using a dataset, how can one get to a column data element using this format: dataset.Tables.Rows.... I can get to a specific row, but I am not sure how to get to the column or data. I tried using the keyword Column, but no luck. Also, is direct access the best way to access this data, or should I be using different DataRows, etc....
0
2521
by: adjuster11 | last post by:
Bear with me, Noob question. I'm not a programmer, but a proprietary software program, Xactimate 24 property estimate, is forcing me to be one. I've tried multiple installs of their program on a new AMD 3200+ with 64 bit capable, but 32 bit as the operating setting, and XP Pro 32 bit as the OS. They blame my 64 bit capable computer, for...
0
3895
by: Sandeep Khandelwal | last post by:
Hi All. I want to extract and Load data from PostgreSQL using Libpq C API. Please let me know which approach will be good to load large number of rows into PostgreSQL(Insert or COPY FROM) and, which approach will be good to extract large number of rows from PostgreSQL (COPY TO or SELECT). I want to handle all the data types supported in the...
0
1427
by: Daniel | last post by:
how does ado.net SqlDataReader.GetString() know which encoding to read the data into a string as? Does sql sever set this at the column data type level, server wide encoding setting, os encoding?
2
5747
by: bogie | last post by:
Hello I have some problem to change my column data type in my table property from character(15) to character(100). I use Postgresql 7.4. The problem is I try to make new column with charcater(100) then i copy the data from teh original column to the new column, then i try to drop the column but i get the following ERROR : Cannot drop table...
6
6397
chiragvithlani
by: chiragvithlani | last post by:
In SQL Server 2005... with some 11K rows I am having two tables T1 and T2(as bkup of T1), now i need one column data of T2 as i accidently updated T1 column data, (Update T1.colx with T2.colx) I tried with <code> update T1 set colx=(select colx from T2) </code> but this is syntactically wrong as subquery returns multiple rows,
1
3654
by: sunilkds | last post by:
How to count total number of items in the Data Combo in Vb6.0
2
3318
by: venkat chitta | last post by:
Hi, I want to extract the below column details of a given table of PostgreSQL database. 1.column name 2.column data type 3.column length 4.column precision 5.column scale 6.column's default value
0
7565
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7128
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7543
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5704
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5103
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3255
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3242
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1612
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
473
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.