On Thu, Feb 8, 2018 at 8:20 AM, Ludovic THEBAULT via use-livecode <
use-livecode@lists.runrev.com> wrote:
>
>
> Just for infos, multiple statements works with SQLite but not with Mysql.
They also work with postgreSQL.
This was a major factor in my switching.
I think mySQL now has rollback, but
NP. From the dictionary statement about *some* database systems supporting
multiple SQL statements, I gather that *some* do not, so they have to take the
lowest common denominator approach.
Bob S
> On Feb 8, 2018, at 08:07 , Ludovic THEBAULT via use-livecode
> wrote:
>
>> Le 8 févr. 2018 à
> Le 8 févr. 2018 à 16:48, Bob Sneidar via use-livecode
> a écrit :
>
> I know where! The Dictionary:
>
>
> SQLStatement string
> A string in Structured Query Language. (Do not include a semicolon at the end
> of the SQLStatement.) >Note: Some database systems, such as Oracle, are
> capa
> Le 8 févr. 2018 à 16:34, Bob Sneidar via use-livecode
> a écrit :
>
> I thought I read somewhere that the LC API does not support multiple
> statements?
>
> Bob S
Ok, thanks !
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please v
>> I’ve an « syntax error » as result if i want to execute multiple MySQL
>> commands, even with transactions.
>>
>> It is normal ? If i execute one command at time, it’s work.
>>
>> Thanks !
>>
>>
>>
>> Here a sample script :
&g
I thought I read somewhere that the LC API does not support multiple
statements?
Bob S
> On Feb 8, 2018, at 02:24 , Ludovic THEBAULT via use-livecode
> wrote:
>
> Hello,
>
> I’ve an « syntax error » as result if i want to execute multiple MySQL
> commands, even with
Hello,
I’ve an « syntax error » as result if i want to execute multiple MySQL
commands, even with transactions.
It is normal ? If i execute one command at time, it’s work.
Thanks !
Here a sample script :
revExecuteSQL tDatabaseID,"BEGIN TRANSACTION »
put "INSERT INTO savemyTabl
