Getting the 'Description' of a field from an Access DB

Hi,How can we get rhe contents of the 'Description' of a field in an Access DB?

[95 byte] By [prakharbirlaa] at [2007-10-3 5:08:51]

«« ActionPerformed Problem
»» Application Security in GlobalPlatform

# 1

You should sue DatabaseMetaData.getColumns API.

zhaoyha at 2007-7-14 23:15:04 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

Sorry, but what is 'DatabaseMetaData.getColumns' and how to use it?I'm quite new to java so please bear with me.

prakharbirlaa at 2007-7-14 23:15:04 >

# 3

For instance,DatabaseMetaData dbmd = con.getMetaData();ResultSet rs=dbmd.getColumns(null,null,"%","%");You should read JDK API about DatabaseMetaData.getColumns to know more about what in that rs object:)

zhaoyha at 2007-7-14 23:15:04 >

# 4

Thanks i'll try that out!

prakharbirlaa at 2007-7-14 23:15:04 >

# 5

Ok, thanks a lot dude!I figured out that to get the 'Description' you have to use sa.getString("REMARKS")!But now, can i also change/update the value?

prakharbirlaa at 2007-7-14 23:15:04 >

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Getting the 'Description' of a field from an Access DB

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified