Trying to optimize building SQL insert and update strings, the following VO code:<\/p>\n
cTable + ‘”‘ + cFieldName + ‘”‘<\/p><\/blockquote>\n
in Vulcan.NET works as follows<\/p>\n
cTable + “.” + chr( 34 ) + cFieldName + chr( 34 )<\/p><\/blockquote>\n
But of course is not very performant. Better is the following code:<\/p>\n
string.Format( e”{0}.\\”{1}\\””, cTable, aValues[nI,1] )<\/p><\/blockquote>\n
Please note the “e” character before the string – it enables escaping the double quotes with the backslash.<\/p>\n
The entire method for building an append statement ist the following:<\/p>\n
\n static method CreateInsertString( cTable as string, oFieldValues as List<BaseField> ) as string
\n local oField as BaseField
\n local oStatement as StringBuilder
\n local oValues as StringBuilder
\n local cStatement as string
\n local cValues as string
\n local nLen as int
\n local nI as int
\n local cField as string
\n local uValue as usual
\n local cValue as string<\/p>\ncStatement := string.Format( “insert into {0} ( “, cTable )
\n oStatement := StringBuilder{ cStatement, 512 }
\n oStatement:Append( ” values ( ” )
\n oValues := StringBuilder{ 512 }
\n nLen\t\t\t\t:= oFieldValues:Count – 1
\n\t for nI := 0 upto nLen
\n oField := oFieldValues:Item[nI]
\n \t cValue := FirebirdHelper.ConvertValueToStatement( oField:Value )
\n \t if nI < nLen
\n oStatement:AppendFormat( “{0}, “, oField:Name )
\n oValues:AppendFormat( “{0}, “, cValue )
\n \t else
\n oStatement:AppendFormat( “{0}) “, oField:Name )
\n oValues:AppendFormat( “{0}) “, cValue )
\n \t endif
\n next
\n oStatement:Append( oValues )
\n\t cStatement\t\t:= oStatement:ToString()<\/p>\nreturn cStatement\n<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"
Trying to optimize building SQL insert and update strings, the following VO code: cTable + ‘”‘ + cFieldName + ‘”‘ in Vulcan.NET works as follows cTable + “.” + chr( 34 ) + cFieldName + chr( 34 ) But of course is not very performant. Better is the following code: string.Format( e”{0}.\\”{1}\\””, cTable, aValues[nI,1] ) […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-206","post","type-post","status-publish","format-standard","hentry","category-vulcan-net-programming"],"_links":{"self":[{"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=\/wp\/v2\/posts\/206","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=206"}],"version-history":[{"count":4,"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=\/wp\/v2\/posts\/206\/revisions"}],"predecessor-version":[{"id":210,"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=\/wp\/v2\/posts\/206\/revisions\/210"}],"wp:attachment":[{"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=206"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=206"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.riedmann.it\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}