ID is same type of the id field
Cordialement,
Olivier Cruilles
Mail: linu...@club-internet.fr
Le 10 août 2012 à 18:26, rocko a écrit :
> 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, Oliv
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
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: linu...@club-internet.fr
>
> Le 10 août 2012 à 18:15, ro
Sorry, in apostrophes.
Cordialement,
Olivier Cruilles
Mail: linu...@club-internet.fr
Le 10 août 2012 à 18:18, Olivier Cruilles a écrit :
> Yes, in parenthesis
>
>
> Cordialement,
>
> Olivier Cruilles
> Mail: linu...@club-internet.fr
>
> Le 10 août 2012 à 18:15, rocko a écrit :
>
>> Shoul
Yes, in parenthesis
Cordialement,
Olivier Cruilles
Mail: linu...@club-internet.fr
Le 10 août 2012 à 18:15, rocko 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
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
In java you'd use ResultSetMetaData, but in Gambas I adopted a slightly
different approach using the describe function...of course it's not as
portable...but it will give a list of columns for a given table in MySQL
(which I think was your original question)...
Private Function getColumns(table
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
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 o
