Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.042
  HXTT Cobol 5.0.042
  HXTT DBF 7.1.042
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel 6.1.045
  HXTT Json 1.0.014
  HXTT Paradox 7.1.042
  HXTT PDF 2.0.042
  HXTT Text(CSV) 7.1.042
  HXTT Word 1.1.042
  HXTT XML 4.0.043
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
GROUP_CONCAT
Wolfgang
2008-06-19 00:49:53.0
Hi,
we want to group rows, but have access to the different values
of the grouped column. In MySQL, this is obtained using
GOUP_CONCAT, which is not supported in HXTT dbf driver.
Any chance to have this supported or any other way of
achieving this goal?
Thanks.
Re:GROUP_CONCAT
HXTT Support
2008-06-26 05:27:12.0
According to your request, v4.0.036 supports GROUP_CONCAT function. ROUP_CONCAT([DISTINCT] expr_list [order_by_clause] [SEPARATOR str_val]): returns a string result with the concatenated non-NULL values from a group. It returns NULL if there are no non-NULL values. SEPARATOR is followed by the string value that should be inserted between values of result. The default is a comma (','). You can eliminate the separator altogether by specifying SEPARATOR ''. The result will be truncated to the maximum length of 2048 sometimes. It will be available after about 5 hours.

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 | Sitemap