Back to forum list… Back to Realisable, can you please add?...

Access to table name in DBWriter (2 replies)

D Dunn
10 years ago
D Dunn 10 years ago

I'd like to be able to add to the dbWriter fields something like:

Field, Export, SQL

MyTextField, True, substring(MyTextField,1,col_length(%TableName, 'MyTextField'))

This would allow me to truncate the data values before inserting in SQL.  I know that I can do this within a script but I think it would be faster to have SQL do that work than a script.

Support
10 years ago
Support 10 years ago

Django, sure, note taken.

Possibly in a product update.

Thanks

9 years ago
Support 9 years ago

Closed due to inactivity.

Contact

    Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

    Looking to purchase IMan, please see our resellers here.

    Realisable Software
    Ph: +44 (0) 208 123 1017

    Copyright © Realisable. All rights reserved.
    Realisable is a registered trademark

    Close

    Request Demo

      Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

      Looking to purchase IMan, please see our resellers here.

      Realisable Software
      Ph: +44 (0) 208 123 1017

      Copyright © Realisable. All rights reserved.
      Realisable is a registered trademark

      Close

      Access Downloads

        Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

        Looking to purchase IMan, please see our resellers here.

        Realisable Software
        Ph: +44 (0) 208 123 1017

        Copyright © Realisable. All rights reserved.
        Realisable is a registered trademark

        Close