search

leeonsoft / txquery

Automatically exported from code.google.com/p/txquery
Other
0 stars 0 forks source link

Some issues Solved and Corrected #15

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Hi I have been working a little bit on TxQuery from the latest sources on this 
repository and applying some changes and fixes already posted here in this 
issue section.

I have reworked the Managment and transition from pansiChar and PChar (Ansi to 
unicod versions). and fixes some unsolved issues like the Issue #9 (TlargeInt 
field work field value) this is related to PChar management and memory 
operations. I have made some test and at leats in my place all is working 
perfectly, 

Some issues solved:
1) Previously the length of each source string field has the double of length + 
2 as a txquery field, now it uses the same length as the original Source Field
2) fixed Issue #9 when combining string fields, integer fields and float 
fields, it display strange values.
3) Change some ANSIXX function to unicode Functions like AnsiCompareXX to 
CompareXX, AnsiPos to Pos.
4) All clases in XQuery.pas including TFileReusltset works now with Unicode and 
Pchar

Some patches are based on CY's and applied to ther classes, all the changes are 
marked by my nickname 'fduenas'

There still some work to do like converting all code in XqBase,pas from 
managing PansiChar to PChar (unicode versions).

Hope this fixes can be applied to the main trunk, I will email CY with the full 
changed files so he can review them.

The sources are based on Latest Release 2.1 r16 and applied some fixes posted 
here after that update.

Any other issue please contact me at fduenas@gmail.com.
Regards and happy programming

Original issue reported on code.google.com by fdue...@gmail.com on 12 Jul 2011 at 4:07

Attachments:

GoogleCodeExporter commented 9 years ago 
Thanks man Great Job...

Original comment by Nenukes...@gmail.com on 28 Jul 2011 at 3:03

GoogleCodeExporter commented 9 years ago 
Hi, i have an issue usinf string functions like UPPER o TRIM with fields float 
or int fields shows some extrange values, id tried to track the fail and found 
at line 3898 in xquery.pas the value of n always is 2 but with string fields 
the value is diferent, can you can help me to fix this issue?

Original comment by Nenukes...@gmail.com on 28 Jul 2011 at 8:09

GoogleCodeExporter commented 9 years ago 
Please atatch here a demo to test the issue you are having.  Have you tried to 
cast first the values to string and then pass them to the string functions?

Original comment by fdue...@gmail.com on 29 Jul 2011 at 2:51

GoogleCodeExporter commented 9 years ago 
Ok. I managed to resolve the problem. download updated_sources.rar, update the 
units and recompile both packages.

TXQuery_update_full contains all sources updated and extra some files.

*Fixed: when using a Float or integer field with a string function like UPPER, 
it returns strange values.

*Workarround: added LeftStr and RightStr lias functions for LEFT and RIGHT, 
because this functions can't be used in the field list of a select clause, etc 
can only be used in WHERE conditions.

*added some Alias functions as SubStr and MidStr.
*Small additions and fixes

All changes are marked with my alias 'fduenas'

Regards

Original comment by fdue...@gmail.com on 29 Jul 2011 at 8:54

Attachments: