[Gambas-user] Getting data from table
rocko
sunblaster5 at ...626...
Fri Aug 10 18:33:21 CEST 2012
Oh yes, I meant quotes, These: " " NOT These: ()
apostrophes gives an error:
"Unexpected end of line"
CODE:
sResult = $hConn.Find("inventory", "id = &1 ", ID)
For Each sResult
$date1 = sResult!endDate
$date2 = sResult!startDate
Print DateDiff($date1, $date2, gb.Day)
Next
On Fri, 2012-08-10 at 18:21 +0200, Olivier Cruilles wrote:
> Sorry, in apostrophes.
>
> Cordialement,
>
> Olivier Cruilles
> Mail: linuxos at ...1896...
>
> Le 10 août 2012 à 18:18, Olivier Cruilles <linuxos at ...1896...> a écrit :
>
> > Yes, in parenthesis
> >
> >
> > Cordialement,
> >
> > Olivier Cruilles
> > Mail: linuxos at ...1896...
> >
> > Le 10 août 2012 à 18:15, rocko <sunblaster5 at ...626...> 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
> >>>> Gambas-user at lists.sourceforge.net
> >>>> 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
> >>> Gambas-user at lists.sourceforge.net
> >>> 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
> >> Gambas-user at lists.sourceforge.net
> >> 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
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
More information about the User
mailing list