Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT DBF
Rename columb
dms
2015-01-03 07:08:39.0
Hi

I am trying to rename column names to lower case with

ALTER TABLE plant RENAME ID TO id
ALTER TABLE plant RENAME AREA_CODE TO area_code

The case remains capital letters.

Is it possible to rename the case?
Re:Rename columb
HXTT Support
2015-01-04 06:37:43.0
You can try
ALTER TABLE plant RENAME ID TO id1

ALTER TABLE plant RENAME ID1 TO id
Re:Rename columb
HXTT Support
2015-01-04 06:38:46.0
In my memory, DBF format will store column name in upper case.
Re:Re:Re:Rename columb
dms
2015-01-04 07:53:48.0
Hi

The columb staysupper case. I use postgres and dbase with the same birt report.
Postgres uses small case and dbase uppercase. The dataset in birt does not work.

I can change the case manually to lower case with dbase, but this will take a long time.

Is it possible to rename fields to lower case?

I use hxtt properties.setProperty("versionNumber","DB2K");
properties.setProperty("DefaultExtension","DBF");
properties.setProperty("Default Index Suffix","MDX");
Re:Re:Re:Re:Rename columb
HXTT Support
2015-01-06 07:25:12.0
It will provide allowLowerCaseFieldName connection property, which the default value is true;
Re:Re:Re:Re:Re:Rename columb
dms
2015-01-07 02:15:50.0
Thank you
Re:Re:Re:Re:Re:Re:Rename columb
dms
2015-01-07 03:04:20.0
I have tested the new driver, but the case remains capital

The code is as follows;

Properties properties = new Properties();
properties.setProperty("versionNumber","DB2K");
properties.setProperty("DefaultExtension","DBF");
properties.setProperty("Default Index Suffix","MDX");
properties.setProperty("lockType", "DBASE4BDE");
properties.setProperty("loadIndices","true");
properties.setProperty("allowLowerCaseFieldName","true");

String jdbcConnection = "jdbc:dbf:////D/dms2000/data/dms";
conn = DriverManager.getConnection(jdbcConnection,properties);

Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String temp1 = "CREATE TABLE test (field1 CHAR(10))";
st.executeUpdate(temp1);

String temp = "ALTER TABLE test RENAME field1 TO id1";
System.out.println(temp);
st.executeUpdate(temp);
st.close();
Re:Re:Re:Re:Re:Re:Re:Rename columb
HXTT Support
2015-01-08 15:54:25.0
I haven't tested your sent sample, because the latest package is released just now. Please try it.
Re:Re:Re:Re:Re:Re:Re:Re:Rename columb
dms
2015-01-09 05:51:14.0
The CREATE TABLE works correct.

The ALTER TABLE still renameS the field to UPPER CASE.
Re:Re:Re:Re:Re:Re:Re:Re:Rename columb
HXTT Support
2015-01-11 03:31:21.0
Supported now.
Re:Re:Re:Re:Re:Re:Re:Re:Rename columb
dms
2015-01-11 22:38:51.0
Thank you.

The alter command always changes the filenaam to UPPERCASE. Is this correct?

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap