Should the 'ID' at the end be As Integer or Result?? I have it As Integer ATM, but nothing gets printed.
On Fri, 2012-08-10 at 18:18 +0200, Olivier Cruilles wrote: > Yes, in parenthesis > > > Cordialement, > > Olivier Cruilles > Mail: [email protected] > > Le 10 août 2012 à 18:15, rocko <[email protected]> a écrit : > > > Should the table name be in parenthesis?? > > I'm getting an error: > > "Unknown Identifier: inventory" > > > > sResult = $hConn.Find(inventory, "id = &1 ", ID) > > For Each sResult > > $date1 = sResult!endDate > > $date2 = sResult!startDate > > Print DateDiff($date1, $date2, gb.Day) > > > > On Fri, 2012-08-10 at 16:27 +1000, Shane wrote: > >> On 10/08/12 15:13, rocko wrote: > >>> I've read the help files and seen a lot of examples on how > >>> to add data to a table but I can' find any examples on how > >>> to get data from a table. > >>> > >>> I need to get total number of fields from a table. I've looked at: > >>> 'Property Read Count As Integer' in the Help file. > >>> Can i simply put this at the top of my class and then do a > >>> Print Count ?? > >>> > >>> I need the Count so i can iterate thru the fields and extract data, > >>> something like: > >>> For Each Count > >>> get specific field > >>> do something with field > >>> Next > >>> I suppose I could use the primary key ID as the For Each loop > >>> But not sure about that. > >>> > >>> > >> Try this > >> > >> myResult = dbcon.find(myTable, "id = &1",ID) > >> for each myResult > >> TextBox1.text = myResult!myField1 > >> TextBox2.text = myResult!myField2 > >> next > >> > >>> > >>> > >>> ------------------------------------------------------------------------------ > >>> Live Security Virtual Conference > >>> Exclusive live event will cover all the ways today's security and > >>> threat landscape has changed and how IT managers can respond. Discussions > >>> will include endpoint security, mobile security and the latest in malware > >>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > >>> _______________________________________________ > >>> Gambas-user mailing list > >>> [email protected] > >>> https://lists.sourceforge.net/lists/listinfo/gambas-user > >>> > >>> > >>> > >> > >> > >> ------------------------------------------------------------------------------ > >> Live Security Virtual Conference > >> Exclusive live event will cover all the ways today's security and > >> threat landscape has changed and how IT managers can respond. Discussions > >> will include endpoint security, mobile security and the latest in malware > >> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > >> _______________________________________________ > >> Gambas-user mailing list > >> [email protected] > >> https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > > > > > ------------------------------------------------------------------------------ > > Live Security Virtual Conference > > Exclusive live event will cover all the ways today's security and > > threat landscape has changed and how IT managers can respond. Discussions > > will include endpoint security, mobile security and the latest in malware > > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > > _______________________________________________ > > Gambas-user mailing list > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Gambas-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/gambas-user ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
