Guest:
Register
|
Login
|
Member List
|
Search
|
Statistics
|
FAQ
Language
----------
Simplifed Chinese
Traditional Chinese
English
CnPack Forum
»
CnWizards IDE Wizards
» Convert to string change request
‹‹ Last Thread
|
Next Thread ››
Poll
Trade
Reward
Activity
Printable Version
|
Email to Friend
|
Subscription
|
Favorites
Subject: Convert to string change request
Edelcom
普通灌水员
UID 37197
Digest Posts 0
Credits 51
Posts 18
点点分 51
Reading Access 10
Registered 2008-2-8
Location Belgium
Status Offline
#1
Post at 2008-8-25 17:54
Profile
|
Site
|
Blog
|
P.M.
Convert to string change request
I frquently use the convert to string option to change a pasted sql query into something like :
Result :=
'SELECT' +
'A_FIELD,' +
'ANOTHER_FIELD,' +
'A_THIRDFIELD' +
'FROM A_TABLE '
'WHERE ...
You get the picture.
I therefore had to delete the standard #10#13 (for Delphi). I Replaced it with a blank.
Howerver at that time two + -signs are present (which is wrong):
'ANOTHER_FIELD,' + +
'A_THIRDFIELD ' + +
'FROM A_TABLE '
The second + should be deleted.
Also it would be very helpfull to be able to specify that an extra space should be inserted before the closing '-sign.
'SELECT ' +
'A_FIELD, ' +
'ANOTHER_FIELD, ' +
'A_THIRDFIELD ' +
'FROM A_TABLE '
'WHERE ...
because the string is an sql syntax extra spaces are necessary before any keyword (as FROM and WHERE).
Programmer by choice and profession!
Passion
(LiuXiao)
管理员
UID 359
Digest Posts
19
Credits 6838
Posts 3591
点点分 6838
Reading Access 102
Registered 2004-3-28
Status Offline
#2
Post at 2008-8-28 10:44
Profile
|
Blog
|
P.M.
In first step of replacing, why not replace "#13#10 +" with a blank?
Edelcom
普通灌水员
UID 37197
Digest Posts 0
Credits 51
Posts 18
点点分 51
Reading Access 10
Registered 2008-2-8
Location Belgium
Status Offline
#3
Post at 2008-9-8 17:57
Profile
|
Site
|
Blog
|
P.M.
Yes, Passion, I found that out too (look at the middle of my post).
But than I have two + signs.
I is so easy for you developers to change this behavious ... I'm sure you will do it ,somehere in one of the next builds, no ?
Programmer by choice and profession!
Passion
(LiuXiao)
管理员
UID 359
Digest Posts
19
Credits 6838
Posts 3591
点点分 6838
Reading Access 102
Registered 2004-3-28
Status Offline
#4
Post at 2008-9-9 21:49
Profile
|
Blog
|
P.M.
In the 'Code to String' tool in Editor wizard, if you set the Delphi linebreak from #13#10 to a blank string, the conversion result will contain 2 + sign, which should be only one, is it correct?
If yes, I think I got it and will do the adjustment.
Passion
(LiuXiao)
管理员
UID 359
Digest Posts
19
Credits 6838
Posts 3591
点点分 6838
Reading Access 102
Registered 2004-3-28
Status Offline
#5
Post at 2008-9-10 09:57
Profile
|
Blog
|
P.M.
Done. Please try try 442?
Poll
Trade
Reward
Activity
CnPack Forum
CnPack English Forum
> CnWizards IDE Wizards
> CVSTracNT
> Announcements & Others
All times are GMT++8, the time now is 2024-11-22 01:36
Powered by
Discuz!
5.0.0
© 2001-2006
Comsenz Inc.
Processed in 0.012532 second(s), 8 queries , Gzip enabled
TOP
Clear Cookies
-
Contact Us
-
CnPack Website
-
Archiver
-
WAP
Member's CP Home
Edit Profile
Credits Transaction
Public User Groups
Buddy List
Main
Page Views
User Agents
Posts History
Top Forums
Top Threads
Post Ranking
Credit Ranking
Online Time
Team
Moderation Stats