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.

DataTypes of Kapow


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

DataTypes of Kapow

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

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?

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

Re: DataTypes of Kapow

Post by pavel.vraj on 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,

    Current date/time is Thu Mar 21, 2019 9:52 pm