On 16/06/17 14:48, PICCORO McKAY Lenz wrote: > its there some code to get BEFORE send the query the fields of the table? > > i mean, in the following code example i already know the column name, but i > need firts detect column name to send amount of filters > > sCriteria *=* "id = &1"iParameter *=* *1012*$hConn*.*Begin' Same as > "SELECT * FROM tblDEFAULT WHERE id = 1012"hResult *=* > $hConn*.*Edit*(*"tblDEFAULT"*,* sCriteria*,* iParameter*)* > > > in this case, the column "id" was previously knowed! but in my case i need > to detect all the column names firts before send the filters/parameters > criteria > > please any help? > > Lenz McKAY Gerardo (PICCORO) > http://qgqlochekone.blogspot.com Piccoro,
Does this help? Dim fld as Field For Each fld In Result.Fields ... do whatever with field names Next zxMarce ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user