New answers tagged style
I cannot answer fully because I don't know all the intricacies of the personal Access MDB behaviour in a server environment. Perhaps this will help; the Style file is an mdb MS Access database so all the rules of the MS Access mdb apply, this includes locks, etc. Access is not a multi-user MDBMS so there will likely be issues with multiple users attempting ...
Use Rule-based styling as in the following image, click on the "plus" icon to add more items: Note the double-quotation marks for Field/Column names and single-quotation marks for strings. Although you don't need double-quotes for Field/Columns, I think it's good practice as it highlights what it is, useful for long logics but this is personal opinion :)
Just use Firebug or any other developer-tool to get the CSS-classname and existing rules that perhaps have to be overridden. Some parts of the Layerswitcher are styled with static images but they can also be set to user defined images by defining the image path or changing the rule that sets the image. see http://jsfiddle.net/expedio/9m3wv0qx/
On this page it is well explained how to define a stylemap: http://www.peterrobins.co.uk/it/olstyle.html .just use the given example for setting the default style and do it again for the select style. So you set the style for the whole layer and don't have to define it for every single feature.
Colours to be used with layers can be stored in qml or sld files. Since you are doing it programmatically, you can create the qml file and the QGIS project file as well by VBA. They are simply text-only XML files.
One option would be to load the line as one layer and the line vertices (could be a view on the line table) as a second layer which can then be labeled. You can use ST_M() to write the measure value to a view attribute. Stylingwise, we have to deal with the challenge that there is no gradient line style yet ... But there are polygon gradient fills. So we ...
Top 50 recent answers are included