InfoPath Dev

Hello,
I have a form that has a file attachment control and the form data is being stored in a database. What datatype do I need to use in my table to store an attached file from Infopath?

Appreciate your help.
Thanks,
Vidette

VidetteP

Look into storing your attached file as a BLOB type.

vt_asparagus

i test this using the three type of blob data field types(text,ntext or image) with sql server.
But when u drag and drop the datafield to the form infopath only give me the option to use a image control and not a file attaching control,

why?? how i could convert to use a file attaching ?

Thanks

Fred Darwin Villareal

Easy...right click the control and I believe there is a convert to option. You can then change the control to be a file attachment control.

Thank you vt_asparagus & fredarwin

I am now having the same proble as fredarwin. I can insert only the image upload control for the image datatype field. When I try to do the change to Upload file, this is not available...
-Vidette

VidetteP

For a file attachment control, I think the field in the schema will need to be a base64Binary type. I noticed that if you are bound to a string type you will get the behavior you have been describing.