Instant sql formatter web service server url:
http://www.wangz.net/cgi-bin/ppserver_saas

xml data post to instant sql formatter web service

<sqlpp_request>
	<clientid>officical client</clientid>
	<dbvendor>oracle</dbvendor>
	<outputfmt>html</outputfmt>
	<inputsql>select empno,empname
	from emp
	where salary > 1000 -- salary
	and deptid = 10
	</inputsql>
	<formatoptions>
		<keywordcs>uppercase</keywordcs>
		<identifiercs>uppercase</identifiercs>
		<functioncs>uppercase</functioncs>
		<lnbrwithcomma>after</lnbrwithcomma>
		<liststyle>stack</liststyle>
		<salign>sleft</salign>
		<andorunderwhere>no</andorunderwhere>
		<removelnbr>no</removelnbr>
		<quotechar>'</quotechar>
		<trimquotechar>no</trimquotechar>
		<compactmode>no</compactmode>
		<maxlenincm>80</maxlenincm>
	</formatoptions>
</sqlpp_request>


name			datatype		description
----			--------		----				
clientid		character		unique id of requested client
dbvendor		character		sql dialect, available value: oracle,mssql,db2,mysql,access,generic
outputfmt		character		output type, available value: sql, C#,C# String Builder,delphi,java,java String Buffer,php,vb/asp,vbnet,vc,proc,procobol,html,html2,htmlkeeplayout,htmlkeeplayout2,htmlkeeplayoutmodifycase,htmlkeeplayout2modifycase,txtmodifycase,xml,dbobject
inputsql		character		sql need to be formatted

format options:

keywordcs				character		keyword case, available value: uppercase,lowercase,initcap,initcapeachword,unchaged
identifiercs		character		identifier case, available value: uppercase,lowercase,initcap,unchaged,initcapeachword
functioncs			character		function case, available value: uppercase,lowercase,initcap,unchaged
lnbrwithcomma		character		linebreak and comma, available value: after,before,beforewithspace
liststyle				character		list style, available value: stack,notstack
salign					character		align style, available value: sleft,sright
andorunderwhere	character		available value: yes,no
removelnbr			character		available value: yes,no
trimquotechar		character		available value: yes,no
quotechar				character		single letter	
compactmode			character		available value: yes,no
maxlenincm			character		maximum line width, valid only compactmode is set to yes





xml data send back from instant sql formatter server:

<sqlpp_result>
	<retvalue>0</retvalue>
	<retmessage>success</retmessage>
	</formattedsql>formatted sql here</formattedsql>
</sqlpp_result>


name			datatype		description
----			--------		----				
retvalue			character		0£ºsuccess£¬ <>0£º failed
retmessage		character		return message
formattedsql	character		when retvalue = 0 , this is formatted sql



website:
http://www.dpriver.com/pp/sqlformat.htm