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?
– Shura16
updated my question
– Renan Rodrigues
@Shura16 managed to see something ?
– Renan Rodrigues