FSTREAM - Get Filename?

• fjuventeny

  SSC Enthusiast

  Points: 199

  More actions

  April 7, 2017 at 5:09 am

  #401908

  I have a Documents table with FSTREAM to save the image.
  I need to know the filename of the file that is being saved, Is it possible?

  Executing this....
  

  SELECT MyImageField.PathName()
  FROM MyDocTable
  WHERE IdClient = 'd6817fc1-4bed-405d-88b9-64fe741596a2'
  
  ... I get this path

  \\SRVSQLT01\MSSQL_FSTREAM\v02-A60EC2F8-2B24-11DF-9CC3-AF2E56D89593\ADMIS_TEST\dbo\Documentos\Imagen\74A02349-D097-4AD9-97F9-19F5C0962CE5\VolumeHint-HarddiskVolume3

  But there is no filename there... and I can't understand this path.

  How do I get the filename?

  Thanks!

  Francesc
  

• Lowell

  SSC Guru

  Points: 323518

  More actions

  April 7, 2017 at 7:01 am

  #1937199

  i think you want to use a different function right?

  this page from Microsoft has a decent example:
  https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/getfilenamespacepath-transact-sql

  what does this return for you?
  SELECT
MyImageField.GetFileNamespacePath() AS FilePath,
MyImageField.PathName() As JustThePath
FROM MyDocTable
WHERE IdClient = 'd6817fc1-4bed-405d-88b9-64fe741596a2'

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• fjuventeny

  SSC Enthusiast

  Points: 199

  More actions

  April 10, 2017 at 7:10 am

  #1937416

  Hi Lowell.

  I get this error...
  "La función GetFileNamespacePath solo es válida en la columna FILESTREAM de varbinary(max) en un objeto FileTable."
  It would be "Function GetFileNamespacePath  is only valid in the FILESTREAM column in a FilteTable Object"

  Thanks...

• maudzedunjp

  Old Hand

  Points: 312

  More actions

  April 12, 2017 at 5:11 am

  #1937801

  Thx lowell, this helps me