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.