dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip of the Day
Language: Informix
Expertise: Beginner
Apr 3, 2000

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


Informix Stored Procedures to VB

Question:
I am returning a resultset from an Informix Stored Procedure to VB6 via ODBC and ADO. Is there any way of returning the field names? At this point I get the resultset, but the name property of the fields are blank.

Answer:
I'm not an ODBC programmer, but I'm pretty sure that the ODBC standard includes a way to get the field names (may be referred to as "headers") back from the database. You can probably get to this from VB.

On the other hand, since you're trying to get these field names from a stored procedure, you probably don't have a simple table to select from. In this case you may try something from SQL along the lines of:

SELECT fname as firstname from TABLENAME
Depending upon how you're building your stored procedures, the above syntax may be helpful.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date