{}

Welcome to the Schneider Electric corporate Website

Search FAQs
How to send a SQL statement longer than 1024 characters with EcoStruxure Machine SCADA Expert?
In EcoStruxure Machine SCADA Expert, the function DBExecute can be used to write some data in SQL Database.
There is a limitation with this function. The maximum length of an SQL statement 1024 characters.
The goal of this article is to explain how to send more than 1024 characters in the SQL Databse, with the function DBExecute

This article is applicable for EcoStruxure Machine SCADA Expert, all version

To execute SQL commands longer than 1024 characters with DBExecute() or DBCursorOpenSQL(), need to break the SQL statement into fragments, storing those fragments in string tags, and then using tag pointers to reference those tags.
For example:
$SQL1 = "first 1000 chars"
$SQL2 = "second 1000 chars"
$DBExecute("ConnName", "{SQL1}{SQL2}")

Schneider Electric Global

How to send a SQL statement longer than 1024 characters with EcoStruxure Machine SCADA Expert?
In EcoStruxure Machine SCADA Expert, the function DBExecute can be used to write some data in SQL Database. 
There is a limitation with this function. The maximum length of an SQL statement 1024 characters.
The goal of this article is to explain how to send more than 1024 characters in the SQL Databse, with the function DBExecute

This article is applicable for EcoStruxure Machine SCADA Expert, all version

To execute SQL commands longer than 1024 characters with DBExecute() or DBCursorOpenSQL(), need to break the SQL statement into fragments, storing those fragments in string tags, and then using tag pointers to reference those tags.
For example:
$SQL1 = "first 1000 chars"
$SQL2 = "second 1000 chars"
$DBExecute("ConnName", "{SQL1}{SQL2}")

Schneider Electric Global

Explore more
Range:
Explore more
Range:
Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Users group

Discuss this topic with experts

Visit our community and get advice from experts and peers on this topic and more
Explore more
Range:
Explore more
Range:
move-arrow-top
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.