Christian - trying the code below and still getting the function sequence
error.
The ErrorNumber property is -1341584476
dim con as SQLConnectionMBS = new SQLConnectionMBS
>
>
> try
>
>
> dim connectionString as string _
> = "Driver={FileMaker ODBC};" _
> + "Database=energy_snapshot_data_store;" _
> + "Server=****;" _
> + "PRT=2399;" _
> + “UID=****;" _
> + “PWD=****"
>
> con.Connect(connectionString, "", "", SQLConnectionMBS.kODBCClient)
>
> catch r as SQLErrorExceptionMBS
> return
> end try
>
> if con = nil then Return
>
>
>
> dim cmd as SQLCommandMBS
> cmd = new SQLCommandMBS
> cmd.Connection = con
>
> if cmd = nil then Return
>
> dim sql as string
> sql = "SELECT GetAs(image,'JPEG') as photo FROM images " _
> + "WHERE assessment_id = '" + self.unique_id + "' and image_type_id = 5"
>
> // select images using sql above
> cmd.setCommandText(sql)
> cmd.Execute
>
> con.Scrollable = False
>
> Try
> while cmd.FetchNext
>
> dim mb as MemoryBlock = cmd.Field("photo").asBLob.CopyBinaryData
> if mb.Size > 0 then
> Try
> dim p as Picture = Picture.FromData(mb)
> self.utility_bill = p
> End Try
> end if
> wend
>
> End Try
>
> cmd.Close
> con.Disconnect
> cmd = nil
> con = nil
>
> Return
On Wed, Jan 7, 2015 at 1:58 PM, Anthony Dellos <[email protected]> wrote:
> Thank you! Will give it a try.
>
> On Tue, Jan 6, 2015 at 2:06 PM, Christian Schmitz <
> [email protected]> wrote:
>
>>
>> > On attempting to connect to a FileMaker Server (13.0.5) with the latest
>> MBS
>> > Xojo SQL Plugin.xojo_plugin version 14.4 (18444) the following error
>> occurs:
>> >
>> > S1010 [iODBC][Driver Manager]Function sequence error
>>
>> I could reproduce it. After a select, the command object is not a result
>> set, so you can't query next record.
>>
>>
>> Ah, it's scrollable:
>>
>> con.Scrollable = false
>>
>> please set to false.
>>
>>
>>
>> Greetings
>> Christian
>>
>> --
>> Read our blog about news on our plugins:
>>
>> http://www.mbsplugins.de/
>>
>> _______________________________________________
>> Mbsplugins_monkeybreadsoftware.info mailing list
>> [email protected]
>>
>> https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info
>>
>
>
_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
[email protected]
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info
