RE: Comment field available to JDBC?

[Alexander Schroeder]

Hi Aaran,

look into the JDBC documentation of the class java.sql.DatabaseMetaData,
here the method 'getColumns', and you will find out that the result of
this function is a result set, that among other fields contain: 

  REMARKS String => comment describing column (may be null) 

which is what DBVisualizer shows, and you probably want.

Regards
Alexander Schröder
SAP DB, SAP Labs Berlin

> -----Original Message-----
> From: Aaran Stent [mailto:aaran@stripped]
> Sent: Sunday, April 13, 2003 4:37 AM
> To: sapdb.general@stripped
> Subject: Comment field available to JDBC?
> 
> 
> Hi,
> 
> I want to use the comment field in SAPDB as tool tips for 
> data entry fields
> but can not find a where to access the column comment from 
> the JDBC driver.
> I know this is possible as using DBVisualizer I can see the 
> comment in a
> column called REMARKS but have no idea where this value is stored.
> 
> Aaran
> 
> ascc.net.au
> 2/6 Batman Rd
> Eltham Victoria 3095
> 
> www.ascc.net.au
> Tel: [phone]
> Fax: [phone]
> Mob: [phone]
> 
> Confidentially Notice: This message and any attachments are 
> intended for the
> use of the individual or entity to which it is addressed, and 
> may contain
> information that is privileged, confidential and exempt from 
> disclosure
> under applicable law. Please do not use or disclose the 
> contents of this
> e-mail or any attachments for any purpose or to any person. 
> If you have
> received this e-mail in error, please notify us immediately 
> by telephone or
> return e-mail and delete the message from your computer.
> 
> 
> 
> _______________________________________________
> sapdb.general mailing list
> sapdb.general@stripped
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>