2 issues SQL module

Support
  • I'm currently experiencing 2 issues with the SQL module:

    1. when inserting a new record, i have to insert as ID a zero padded number (ex: 0000001740 ) but the "Data field" has a built in feature that auto converts strings to numbers.
      so it trasform the value from 0000001740 to 1740
      alt text

    2. when using "update single record" or "update multiple records" nothing happens (while "delete single record", "insert records" and "select single record" works )
      alt text

    anyone has any idea/suggestions?

  • @MegAdan,

    1. Install the latest version of the module SQL.zip and disable the Convert data option located in the additional settings.
      32feed81-4962-4b70-bded-6d52cb6e1a84-image.png

    2. Do not add extra quotes for strings, any value other than variables and resources is treated like a string.
      38d64ec8-2df5-4fe5-94e8-da422c348384-image.png

  • 0 Votes
    3 Posts
    670 Views
  • BAS Crashing afyer 2 3 hours.

    Support
    1 Votes
    7 Posts
    1268 Views
  • Mail Module

    Support
    0 Votes
    3 Posts
    1045 Views
  • PROCESS MANAGER MODULE

    Support
    -1 Votes
    1 Posts
    565 Views
  • BAS FingerprintSwitcher issue

    Support
    0 Votes
    3 Posts
    1080 Views