Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v2.1
  HXTT DBF v5.2
  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 ACCESS
bug report
Lutz
2006-03-03 00:00:00.0
Dear customer-service,

I ordered HXTT Access almost one hour ago and maybe I found the first bug?

Do you have a special email account for bug reports?

I would like to send you the SQL-Statement and the MDB (it's a small one)

Best regards
Markus Lutz


Re:bug report
Lutz
2006-03-03 00:00:00.0
I forgot the sql-statement:

Select [AuthRole].Name AS Role, 'Roles' AS Expr1 , au.Username from AuthRole, AuthUser as au
where
(
(
[AuthRole].ID_AuthRole in
(
SELECT [AuthGroupRole].REF_AuthRole
FROM AuthUser
INNER JOIN
(
(
AuthGroup INNER JOIN AuthGroupRole ON [AuthGroup].ID_AuthGroup = [AuthGroupRole].REF_AuthGroup
)
INNER JOIN AuthUserGroup ON [AuthGroup].ID_AuthGroup = [AuthUserGroup].REF_AuthGroup
)
ON [AuthUser].ID_AuthUser = [AuthUserGroup].REF_AuthUser
WHERE [AuthUser].Username=au.Username
)
)
or
(
[AuthRole].ID_AuthRole in
(
SELECT [AuthUserRole].REF_AuthRole
FROM AuthUser
INNER JOIN AuthUserRole ON [AuthUser].ID_AuthUser = [AuthUserRole].REF_AuthUser
WHERE [AuthUser].Username=au.Username
)
)
)
and
(
au.Username=?
)


Re:Re:bug report
HXTT Support
2006-03-04 00:00:00.0
You can zip and email it to webmaster@hxtt.com .
Re:Re:Re:bug report
HXTT Support
2006-03-04 00:00:00.0
Tried your sql. Your sql is correct. But if 'Roles' is a column name, you should use "Roles" AS Expr1 or AuthRole.Roles as Expr1.
bug report
Lutz
2006-03-06 00:00:00.0
>Supported now. Fixed a bug in sql optimization. Please download the latest >package. Thanks for your response.

Now it works.
Thanks for your quick response - and keep up the good work.
Best Regards
Markus Lutz


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