Search in
Sort by:

Question Status:

Search help

  • Simple searches use one or more words. Separate the words with spaces (cat dog) to search cat,dog or both. Separate the words with plus signs (cat +dog) to search for items that may contain cat but must contain dog.
  • You can further refine your search on the search results page, where you can search by keywords, author, topic. These can be combined with each other. Examples
    • cat dog --matches anything with cat,dog or both
    • cat +dog --searches for cat +dog where dog is a mandatory term
    • cat -dog -- searches for cat excluding any result containing dog
    • [cats] —will restrict your search to results with topic named "cats"
    • [cats] [dogs] —will restrict your search to results with both topics, "cats", and "dogs"

How to Change Material of an Object through SQL database , How to Convert String to Material Interface

Please provide any Suggestion or Screen shot or any Code .

Product Version: UE 4.16
more ▼

asked Aug 10 '17 at 07:07 AM in Blueprint Scripting

avatar image

1 1 3 3

(comments are locked)
10|2000 characters needed characters left
Viewable by all users

1 answer: sort voted first

If you are avoiding C++ yourself then you will need a plugin like:


To handle http requests/etc. (Note, I found this with a cursory google so i don't know anything about it other than people saying it worked and seeing it was recently updated to 4.16)

Once you have that you will need some identifier on the database to compare to a list of materials in Unreal.

There's nothing built in to Blueprints to convert string->className that i know of. Essentially you need an Unreal datatable or array of sets that is essentially {id:String, materialToUse:MaterialInterface}. Compare id to database id and choose that material.

Alternatively if you just want to change material PARAMETERS then you can just pass strings from the database directly into the parameter name of a set material parameter node.

more ▼

answered Aug 12 '17 at 06:51 PM

avatar image

2.6k 98 16 97

(comments are locked)
10|2000 characters needed characters left
Viewable by all users
Your answer
toggle preview:

Up to 5 attachments (including images) can be used with a maximum of 5.2 MB each and 5.2 MB total.

Follow this question

Once you sign in you will be able to subscribe for any updates here

Answers to this question