Page 1 of 1

File name from SQL views

Posted: Thu Feb 16, 2023 5:29 am
by crash

I have a field for file upload, this draws from a view in my sql file.
When the field is drawn from a view in ssms aspm gives me the file name field automatically

When I do the same from a view in ssms there is no file name field.
I update my tables from the views.

The file name field also does not show on the dropdowns for the filename field

How do I get aspm to see the filename field from a view, it seems the only way to create a file upload folder.

Thanks


Re: File name from sql views

Posted: Thu Feb 16, 2023 6:22 am
by MichaelG

Do you mean ASP.NET Maker cannot detect File Upload Field from your database view? Show your database schema for the view and also the underlying tables.


Re: File name from SQL views

Posted: Sat Feb 18, 2023 4:58 am
by crash

Yes, when you look at a table it sees it and automatically assigns it the file.. in view the warning is file name field must be the file upload field itself.
But this is then not in the dropdown

In table it works


Re: File name from SQL views

Posted: Sat Feb 18, 2023 6:44 am
by MichaelG

Show the schema of the View and the underlying tables.


Re: File name from SQL views

Posted: Fri Mar 17, 2023 5:00 am
by crash

I have managed to get the file to show when I set the field to varchar(MAX), this then loads my images to that folder.... but now the image won't show.
What is the correct format for images to show but also load to a folder ?

Thanks


Re: File name from SQL views

Posted: Fri Mar 17, 2023 9:46 pm
by MichaelG

What did you mean by "won't show"? You need to describe in more detail. Make sure you have the View Tag of the field as IMAGE.