[Qgis-user] show record from table in ms-access using python

Suryo Miles suryomiles666 at gmail.com
Fri Jun 20 04:01:51 PDT 2014


I have a ms-access database and i try to make QGIS plugin that take record
from table and show it in Qt, database have format like this :

NO  Skala 1     Skala2      Rekomendasi
================================================
1.  1000        1000        Skala Sama
2.  1000        5000        Skala Bisa digunakan
3.  5000        10000       Skala Tidak Cocok
4.  5000        50000       Skala Terlalu Besar

what i try to make is, when i input skala1 (ex:1000) and skala2 (ex:5000)
it automatic take "Skala Bisa Digunakan" from database and put it in Qt, i
try to use code like :

 def Compskala(self):
        skal1 = self.ui.lineSkl_1.text() #(input)
        skal2 = self.ui.lineSkl_2.text() #(input)
        bandskal = ''                    #(from table)
        if skal1 and skal2:
            bandskal = ' How to direct this to table?'

but i really didn't know what i must do next to direct my code to take
record from table

Can someone help me?

Sorry for my bad english
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20140620/aeca4ad3/attachment.html>


More information about the Qgis-user mailing list