It is now bug 10940 http://quality.runrev.com/show_bug.cgi?id=10940.
I've confirmed in 6.0.1 commercial, and a 6.0.1 standalone, as well.
I've also seen that SQLite returns incorrect results.
put "BEGIN TRANSACTION;" & cr into dcmd
>put "SELECT '1', * FROM testtable WHERE ky='cat';" & cr a
On Sun, Jun 2, 2013 at 5:43 AM, Mike Bonner wrote:
>
> I've only tested this on sqlite. No clue if it works with other dbms.
>
That seems to be the issue. I may be hitting the same bug with postgres
that I've hit before.
I have a button with:
on mouseUp
--code for a button showing the bu
On Sun, Jun 2, 2013 at 3:56 AM, Björnke von Gierke wrote:
> You can't do multi line sql with livecode, you have to issue them
> separately. So for example in SQLite this works to reduce latency:
>
That is incorrect.
I am using multi-line insert/alter with both postgres & sqlite. Hundreds
of li
Just tried it on one of my databases with revdatafrom query. Did this in
the message box:
put "BEGIN TRANSACTION;" into tSql -- transaction start. Add semicolon.
put cr & "select * from clientinfo where applicantname like 'Garcia%';"
after tSql -- next line, add semicolon
put cr & "select * fro
You can't do multi line sql with livecode, you have to issue them separately.
So for example in SQLite this works to reduce latency:
revexecuteSQL theConnID, "BEGIN TRANSACTION"
repeat 20 times
revexecuteSQL theConnID, "INSERT INTO table (column) VALUES 'blah'"
end repeat
revexecuteSQL theConn
My initial forays haven't been successful.
I want to pull unrelated things, likely from different tables, from the
same database as part of a single inquiry
something like
begin transaction;
SELECT a, b, c FROM firsttable;
SELECT name,address FROM othertable WHERE ID=47;
commit;
The inquiries a
