KAPOW

Would you like to react to this message? Create an account in a few clicks or log in to continue.
KAPOW

Welcome to the Kapow forum. Here you can get help, use your skills to help others and enjoy hanging out in the company of other Kapow Robot Developers.


2 posters

    DataTypes of Kapow

    avatar
    Torxz


    Posts : 7
    Points : 2262
    Join date : 2018-03-05

    DataTypes of Kapow Empty DataTypes of Kapow

    Post by Torxz Thu Mar 15, 2018 8:45 pm

    Hi,
    I use MS SQL to store robot data and some of datatypes can not be read by some of reporting tools over MS SQL (Like Long Text (become ntext in SQL), image, html (ntext in SQL). I need to use Varchar(max) or Nvarchar(max) instead of long text but there is no dataytpe in Kapow like this. Do you know a way to create these datatypes in kapow?
    pavel.vraj
    pavel.vraj


    Posts : 86
    Points : 2825
    Join date : 2016-11-04
    Location : Prague, Czech Republic

    DataTypes of Kapow Empty Re: DataTypes of Kapow

    Post by pavel.vraj Tue Apr 10, 2018 4:11 am

    Hi, create your database structure, as you need, and then instead of using "Store in Database" use step "Execute SQL", where you prepare INSERT command with any variable, you need. Then it's up to your control, what you'll save to where. This will not work for every situation, but it's much simpler, than to do it your way.
    Best regards,
    Pavel

      Current date/time is Mon Apr 29, 2024 5:52 pm