[Qgis-user] Add a shape within QGIS to a record already in a database layer/table (SQL SERVER)

[Bernhard Ströbl]

Hi,

not sure about MySql (I use PostgreSQL). How if you define a default 
polygon that is used upon inserting a new dataset with null polygon 
(needs a trigger maybe). You can later change that polygon in QGIS.
IMHO the better way would be to create the dataset from within QGIS by 
digitizing the new polygon, though.

Bernhard

Am 17.06.2014 08:54, schrieb Carlos da Ponte:
> Hi everyone,
> Is there a way to add a shape (eg polygon) to a record in a database table
> added to QGIS, where the record was originally created in a database form
> elsewhere.  (probably makes more sense as an example).
>
> In my SQL Server database form I create a new record for a mine site in a
> table that has a geography field.
>
> I then go into QGIS, load the layer/table via the SQL Server connection.  I
> now want to create a polygon shape associated with the new mine site record
> I created.  Typically I would just edit the existing shape associated with
> the record, but since there is no shape associated with this record, it
> doesnt appear there is a way to create a shape to associate to an existing
> record.
>
> Is this possible (all of my attempts say no).  Is there a better way for
> this workflow to happen.  I could create a child table to house the geometry
> and then use a key relationship to associate it to the record but I want as
> few tables as possible as this adds tables & increases complexity for novice
> users.
>
> Thoughts?
> C
>
>
>
> --
> View this message in context: http://osgeo-org.1560.x6.nabble.com/Add-a-shape-within-QGIS-to-a-record-already-in-a-database-layer-table-SQL-SERVER-tp5146218.html
> Sent from the Quantum GIS - User mailing list archive at Nabble.com.
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> __________ Information from ESET Mail Security, version of virus signature database 9956 (20140617) __________
>
> The message was checked by ESET Mail Security.
> http://www.eset.com
>
>



__________ Information from ESET Mail Security, version of virus signature database 9956 (20140617) __________

The message was checked by ESET Mail Security.
http://www.eset.com