Livecode crashes with Valentina & SQL Yoga (bind arrays)

This is the place to post technical queries about SQL Yoga

Moderators: FourthWorld, heatherlaine, Klaus, robinmiller, trevordevore

Post Reply
trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Livecode crashes with Valentina & SQL Yoga (bind arrays)

Post by trevordevore » Fri Oct 11, 2013 2:49 pm

[This post is an archive from the old SQL Yoga forums]

I've entered a bug report here: http://www.valentina-db.com/bt/view.php?id=5645

It seems to me that the bug is at the interface between Livecode and Valentina, where sql statements have parameters bound into arrays. The Valentina docs are wrong/inconsistent in specifying how such binding should be done. However, even using the Bind example stack provided by Paradigma leads to a crash.

I was thinking it was something in Sql Yoga that was causing the crash, but managed to hone in on a more precise problem area.

I don't know at what point this defect was introduced to Valentina, as from the comments here in this forum, it is clear some have had Sql Yoga working without getting this crash.

However, until it is fixed by Paradigma, then it looks to me that Sql Yoga will only work with some older versions of Valentina (or older versions of Livecode/Revolution).

Unless there is some way within Sql Yoga to set a property so that the library does not use bound sql statements, I will have to eschew Sql Yoga and interface directly with Valentina (since it has features I need not provided by sqlite).

If my bug conditions are reproducible by others, then I hope this notice will save people a few days of headaches if they are trying to use Sql Yoga with Valentina!
Trevor DeVore
ScreenSteps - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: Livecode crashes with Valentina & SQL Yoga (bind arrays)

Post by trevordevore » Fri Oct 11, 2013 2:50 pm

Thanks for the heads up Bernard. Back when I originally added Valentina support the binding worked as my unit tests run against Valentina. If you hear back from Valentina on this please let us know.
Trevor DeVore
ScreenSteps - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: Livecode crashes with Valentina & SQL Yoga (bind arrays)

Post by trevordevore » Fri Oct 11, 2013 2:50 pm

Do you know what versions of Livecode/Valentina you tested Sql Yoga against? Paradigma have tested V4REV against Rev 3.5, and the binding works. Runrev say there's been no change to the way that externals work in that timeframe. So, I was wondering if you had any info that could help clear up where this bug was introduced.
Trevor DeVore
ScreenSteps - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: Livecode crashes with Valentina & SQL Yoga (bind arrays)

Post by trevordevore » Fri Oct 11, 2013 2:50 pm

After many hours of testing, I've finally established that this bug occurs with V4REV 4.8. With a later version (e.g. 4.9.1) the sample Valentina bind.rev stack does not crash Livecode.

I seem to have a way of attracting edge cases :-/
Trevor DeVore
ScreenSteps - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: Livecode crashes with Valentina & SQL Yoga (bind arrays)

Post by trevordevore » Fri Oct 11, 2013 2:50 pm

Glad you found the solution. So is 4.9.1 the latest?
Trevor DeVore
ScreenSteps - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: Livecode crashes with Valentina & SQL Yoga (bind arrays)

Post by trevordevore » Fri Oct 11, 2013 2:51 pm

There is still a significant bug for V4REV if one uses Valentina for anything more than CRUD. http://www.valentina-db.com/bt/view.php?id=5649

I've reverted to Valentina 4.7. The bind/array issue is not present there (obviously introduced in 4.8), and neither is the bug described in the link above.
Trevor DeVore
ScreenSteps - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: Livecode crashes with Valentina & SQL Yoga (bind arrays)

Post by trevordevore » Fri Oct 11, 2013 2:51 pm

I mean, even though Valentina 4.9.1 is the latest and fixes the binding problem, it looks to me like 4.7 would be preferable because of bug 5649.
Trevor DeVore
ScreenSteps - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

Post Reply

Return to “SQL Yoga”