Search with key usage

Asked

Viewed 33 times

0

I have a table that key is as autoIncrement, I need to search and pick up the line that identifies the code I pass. When searching for another part of the field works perfect.

The research I’m using:

var bd = db.transaction("tbl_REUNIOES").objectStore("tbl_REUNIOES");
bd.get(w_key).onsuccess = function(event) {

My table:

 var reunioes = db.createObjectStore("tbl_REUNIOES", {autoIncrement : true});

    reunioes.createIndex("DAT_IDENT_REUNI", "DAT_IDENT_REUNI", {unique: false});
    reunioes.createIndex("TXT_DESCR_REUNI", "TXT_DESCR_REUNI", {unique: false});
    reunioes.createIndex("TXT_RESPO_PALAV", "TXT_RESPO_PALAV", {unique: false});
    reunioes.createIndex("TXT_RESPO_QGELO", "TXT_RESPO_QGELO", {unique: false});
    reunioes.createIndex("TXT_RESPO_LOUVO", "TXT_RESPO_LOUVO", {unique: false});
    reunioes.createIndex("TXT_ENDER_CEPXX", "TXT_ENDER_CEPXX", {unique: false});
    reunioes.createIndex("TXT_ENDER_LOGRA", "TXT_ENDER_LOGRA", {unique: false});
    reunioes.createIndex("TXT_ENDER_BAIRR", "TXT_ENDER_BAIRR", {unique: false});
    reunioes.createIndex("TXT_ENDER_NUMER", "TXT_ENDER_NUMER", {unique: false});
    reunioes.createIndex("TXT_ENDER_COMPL", "TXT_ENDER_COMPL", {unique: false});
    reunioes.createIndex("TXT_ENDER_CIDAD", "TXT_ENDER_CIDAD", {unique: false});
    reunioes.createIndex("SGL_ENDER_ESTAD", "SGL_ENDER_ESTAD", {unique: false});
    reunioes.createIndex("LAT_ENDER_REUNI", "LAT_ENDER_REUNI", {unique: false});
    reunioes.createIndex("LON_ENDER_REUNI", "LON_ENDER_REUNI", {unique: false});
    reunioes.createIndex("COD_IDULT_ATUAL", "COD_IDULT_ATUAL", {unique: false});
    reunioes.createIndex("DAT_ULTIM_ATUAL", "DAT_ULTIM_ATUAL", {unique: false});

I need to get all the data from a certain meeting, for example the meeting 5 (Key = 5), I need to get all the details of the meeting 5.

  • Do you have a table and what information do you want from it? Which database (or storage system) is used? You perform a query, pass the Primary key and want to get what data?

  • updated my question

  • @Shura16 managed to see something ?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.