[Gambas-user] Wrong variable type returning from PostgreSQL resultset

[Gianluigi]

Il giorno dom 13 mar 2022 alle ore 15:33 Gianluigi <bagonergi at gmail.com> ha
scritto:

>
>
> Il giorno dom 13 mar 2022 alle ore 13:49 Gianluigi <bagonergi at gmail.com>
> ha scritto:
>
>>
>>
>> Il giorno dom 13 mar 2022 alle ore 13:46 Gianluigi <bagonergi at gmail.com>
>> ha scritto:
>>
>>>
>>> Hi,
>>>
>>> You get the same error even if you write If rst2!id <= someInteger
>>> Then... or rst2[id]... or If rst2["id"] <= cstr(someInteger) Then... ?
>>>
>>> Regards
>>> Gianluigi
>>>
>>
>> I forgot, comparing two strings is not the same as comparing two integers
>>
>
> Sorry Constantin,
>
> my brain is now useless. The Ukrainian events don't help either....
>

Maybe written like that it makes more sense ;-D

Public Sub Button1_Click()

  Dim rData As Result
  Dim hForm As FRequest

  rData = $hConn.Exec("SELECT * FROM test WHERE id = 12")
  If rData["id"] >= 6 Then
    Print "EUREKA"
    hForm = New FRequest($hConn, rData)
    hForm.Show
  Else
    Print "BOOOH"
  Endif

End


> Regards
> Gianluigi
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20220313/c688580d/attachment-0001.htm>