File name from SQL views

This public forum is for user-to-user discussions of ASP.NET Maker. Note that this is not support forum.
Post Reply
crash
User
Posts: 148

File name from SQL views

Post 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


MichaelG
User
Posts: 1095

Post 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.


crash
User
Posts: 148

Post 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


MichaelG
User
Posts: 1095

Post by MichaelG »

Show the schema of the View and the underlying tables.


crash
User
Posts: 148

Post 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


MichaelG
User
Posts: 1095

Post 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.


Post Reply