Rameshbabu
Apprentice

How to create table in SQL db using text file upload

I have text file with data like column name and values.

6424i0CC51D8739D447BD.jpg

I am going to upload the text file in the K2 Five smartform.

Afterthat text file upload i have create that Files columns and values as a table in SQL server.

Kindly help how to achieve above requirement.

 

0 Kudos
Reply
1 Reply
K2Steve
Apprentice

Re: How to create table in SQL db using text file upload

I assume you are using the fileupload control on the smart form and that you have a smart object that was generated from the table where you want to store this information?

 

 

We will store the attached file in SQL as a base64 string, our file attachment control does this conversion when create/update/read methods are executed so you shouldnt have to worry about doing this manually in smart forms.

 

When you create the table where you want to store the attachmetns I would recommend using the type ntext/memo so that we have a field big enogh to store the poteintially long base 64 string representation of the file attachment.

 

0 Kudos
Reply