Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
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
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT DBF
Rename columb
dms
2015-01-03 07:08:39
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
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
In my memory, DBF format will store column name in upper case.
Re:Re:Re:Rename columb
dms
2015-01-04 07:53:48
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
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
Thank you
Re:Re:Re:Re:Re:Re:Rename columb
dms
2015-01-07 03:04:20
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
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
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
Supported now.
Re:Re:Re:Re:Re:Re:Re:Re:Rename columb
dms
2015-01-11 22:38:51
Thank you.

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

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Refund | Sitemap