{"id":157,"date":"2009-06-21T17:22:00","date_gmt":"2009-06-21T17:22:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=157"},"modified":"2009-06-21T17:22:00","modified_gmt":"2009-06-21T17:22:00","slug":"some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/06\/21\/some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts\/","title":{"rendered":"Some guidelines to avoide Time out errors caused by Table Level Scripts"},"content":{"rendered":"

For handeling any of your Post Recod insert <\/strong>activity the very first option that comes to your mind is the Table Level Script<\/strong>. You can make use of PostInsertRecord<\/strong> function in order to handle the Post Insert Record<\/strong> activities. It is quites simple to make use of this standard functionality provided by Sage CRM<\/strong>, but still it has some limitations. Suppose you want to query <\/strong>a table data <\/strong>from PostInsertRecord function<\/strong>. Now, for querying the data in this section you cannot make use of SELECT <\/strong>statement as it causes the Time Out errors <\/strong>many times. So instead of this you can get the values by Values()<\/strong> collection method and use them as shown in below example.<\/p>\n

function PostInsertRecord()
{
\/\/ Handle post insert record actions here
leadId = Values(‘lead_leadid’);<\/p>\n

StrSql = “UPDATE Lead SET lead_assigneduserid = 3, lead_channelid = 3 where lead_leadid = ” + leadId;<\/p>\n

eWare.ExecSql(StrSql);
}<\/em><\/p>\n

Well, this is just the case of PostInsertRecord function<\/strong>, while in case of UpdateRecord function <\/strong>you can query table data <\/strong>by using SELECT <\/strong>statement. Here also you can avoid the possibilities of the crashing Errors by making use of the WhereClause<\/strong> to get the current record ID <\/strong>instead of Values <\/strong>or GetContextInfo <\/strong>methods(see the example below).<\/p>\n

function UpdateRecord()
{
\/\/ Handle update record actions here
StrSql = “SELECT lead_source from lead where “+ WhereClause;
LeadRec = eWare.CreateQueryObj(StrSql);
LeadRec.SelectSql();<\/p>\n

StrSql = “UPDATE Lead SET lead_source = ‘Email’ where “+ WhereClause;
eWare.ExecSql(StrSql);
}<\/em><\/p>\n

If you find this useful, Please drop us a mail on crm@greytrix.com<\/a>. <\/b><\/marquee><\/p>\n","protected":false},"excerpt":{"rendered":"

For handeling any of your Post Recod insert activity the very first option that comes to your mind is the Table Level Script. You can make use of PostInsertRecord function in order to handle the Post Insert Record activities. It is quites simple to make use of this standard functionality provided by Sage CRM, but\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[2403],"class_list":["post-157","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-table-level-script"],"yoast_head":"\nSome guidelines to avoide Time out errors caused by Table Level Scripts - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/06\/21\/some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Some guidelines to avoide Time out errors caused by Table Level Scripts - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"For handeling any of your Post Recod insert activity the very first option that comes to your mind is the Table Level Script. You can make use of PostInsertRecord function in order to handle the Post Insert Record activities. It is quites simple to make use of this standard functionality provided by Sage CRM, but\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/06\/21\/some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2009-06-21T17:22:00+00:00\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/06\/21\/some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/06\/21\/some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts\/\",\"name\":\"Some guidelines to avoide Time out errors caused by Table Level Scripts - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2009-06-21T17:22:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/06\/21\/some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/06\/21\/some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/06\/21\/some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Some guidelines to avoide Time out errors caused by Table Level Scripts\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Some guidelines to avoide Time out errors caused by Table Level Scripts - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/06\/21\/some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts\/","og_locale":"en_US","og_type":"article","og_title":"Some guidelines to avoide Time out errors caused by Table Level Scripts - Sage CRM \u2013 Tips, Tricks and Components","og_description":"For handeling any of your Post Recod insert activity the very first option that comes to your mind is the Table Level Script. You can make use of PostInsertRecord function in order to handle the Post Insert Record activities. It is quites simple to make use of this standard functionality provided by Sage CRM, but\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/06\/21\/some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2009-06-21T17:22:00+00:00","author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/06\/21\/some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/06\/21\/some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts\/","name":"Some guidelines to avoide Time out errors caused by Table Level Scripts - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2009-06-21T17:22:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/06\/21\/some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/06\/21\/some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/06\/21\/some-guidelines-to-avoide-time-out-errors-caused-by-table-level-scripts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Some guidelines to avoide Time out errors caused by Table Level Scripts"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/157","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=157"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/157\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}