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: [email protected]
>
> Le 10 août 2012 à 18:18, Olivier Cruilles <[email protected]> a écrit :
>
> > 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
