Support forum

sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Search Search
Go to Bottom
sp_TopicIcon
SQL connector
sp_NewPost Add Reply sp_NewTopic Add Topic
November 10, 2021
10:34 am
Henk Helmantel
Admin
Forum Posts: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
4sp_Permalink sp_Print sp_QuotePost Quote

I am sorry but we do not have any plans to add this option to the SQL Connector.

Regards, Henk

November 9, 2021
2:15 am
Chung Pham
Guest
Guests
Go to Top
3sp_Permalink sp_Print sp_QuotePost Quote

Thank you. This should be a new feature in the next version 😉

November 8, 2021
11:31 am
Henk Helmantel
Admin
Forum Posts: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
2sp_Permalink sp_Print sp_QuotePost Quote

Hello Chung Pham,

The SQL statements of the SQL Connector are fixed and cannot be changed.

If you want to use a specific SQL statement to poll new messages from the database, you can use a Scripting Connector with a custom script in C# or Visual Basic.NET.

Regards, Henk

November 7, 2021
8:19 am
Chung Pham
Guest
Guests
Go to Top
1sp_Permalink sp_Print sp_QuotePost Quote

Can I edit the SQL SELECT statement used for polling messages from database?
For example, I only want to get only records with status="send"

sp_NewPost Add Reply sp_NewTopic Add Topic
Go to top
Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 672

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1141

Posts: 3899

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1488