I am trying to use FILESTREAM for saving documents in the database. I have a table containing these columns:
The domains are defined as folows:
When I insert a document using T-SQL in SQL Mangement Studio in the GUI I see the documents as expected and can also open them using the lookup button. When I try to upload a new document I get the folowing error message:
This makes sense because the filestream_id is inserted with a null value, running the same command in SQL management studio without the field filestream_id and the null value works because the field has a default value (newsequentialid()).
What should I change to make the GUI surpress the filestream_id field?
Solved
Error message using FILESTREAM to save documents
Best answer by Jasper
Hi John,
Can you check the definition of the FILESTREAM_ID data type? I believe it has been updated (and renamed) in more recent versions. It should look something like this (note the 'Calculated' property):
View originalCan you check the definition of the FILESTREAM_ID data type? I believe it has been updated (and renamed) in more recent versions. It should look something like this (note the 'Calculated' property):
This topic has been closed for comments
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.