Re: mySQL 8

[matthias rebbe via use-livecode]

Tiemo,

if i remember right this should be solving your issue.

Before you write to or read from the db execute the following command

revExecuteSQL  databaseID, "SET NAMES 'utf8'"
After that try to fetch data.

The retrieved data has then to be decoded with

textDecode(tRetrievedData,”UTF8”) 

e.g.
put textDecode(tRetrievedData,"UTF8") into fld "Name"


Regards,

Matthias

> Am 07.07.2021 um 12:02 schrieb Tiemo via use-livecode 
> :
> 
> Hello folks,
> 
> 
> 
> I have a DB hosted on AWS and need to move it from mySQL 5.6 to 5.7 because
> of AWS restrictions.
> 
> In this context I am doing tests and also tried to see what my programs
> (LiveCode > PHP > mySQL) say about mySQL 8.
> 
> For this I imported a current 5.6 dump into a mySQL 5.7 and into a 8.0 test
> DB.
> 
> 
> 
> With mySQL 5.7 everything looks so far well.
> 
> With mySQL 8 all umlauts come back destroyed in DB queries in my LiveCode
> program.
> 
> 
> 
> When I look into the DB with mySQL Workbench, the umlauts are ok with 5.7 as
> well as with 8.0. Only as soon as I get them into my LC program, they break.
> 
> 
> 
> Is here anybody, who has read about changes of handling the charset or
> collations in mySQL databases with mySQL 8?
> 
> And any idea, where I should try to look for a fix? DB-collations/charsets?
> PHP? LiveCode?
> 
> 
> 
> We are writing year 2021! and this is the third break of existing functions
> handling umlauts within months after LC, macOS and now mySQL
> 
> 
> 
> Thanks for any ideas
> 
> 
> 
> Tiemo
> 
> 
> 
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

That didn't hurt much . . .

[Richmond via use-livecode]

No, not the dentist (although, mind you, I have visited the dentist 12 
times in the last 3 months),


but just lobbed a small donation to LiveCode Community from my PayPal 
account . . .


Why don't you do that as well?

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Stuck on native database functions

[Mark Smith via use-livecode]

Yes, using the numeric placeholders will do that for you. 

> On Jul 7, 2021, at 4:43 PM, Terence Heaford via use-livecode 
>  wrote:
> 
> It also seems to do the escaping for you as it handled text containing commas 
> in the description

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Groups appear as buttons in Project Browser

[Andrew at MidWest Coast Media via use-livecode]

Ordered by layer is active. Even dataGrid groups show up as buttons. 

Example @ https://www.dropbox.com/s/d9xbcstp1nwld8d/project_browser.png?dl=0 


The “input fields” on these 2 cards are both groups of controls in sub-groups, 
but appear as buttons on the viking card.

--Andrew Bell

> 
> Date: Wed, 7 Jul 2021 18:45:59 +0300
> From: panagiotis m 
> Subject: Re: Groups appear as buttons in Project Browser
> 
> Hello Andrew,
> 
> Could it be the case you have chosen to order controls by name, instead of
> layer?
> 
> (Click on the cog icon at the top right of the Project Browser, then choose
> "Order Controls By" -> ... )
> 
> Kind regards,
> Panos
> --
> 
> On Wed, 7 Jul 2021 at 15:53, Andrew at MidWest Coast Media via use-livecode
>  wrote:
> 
>> I have a stack that seems to have lost ?groups? on several cards (but not
>> all of them). They are still part of the structure but not recognized in
>> the Tree View of the Project Browser. Rather than expandable groups in the
>> PB, they show up as buttons. I can hover over and the tooltip calls them
>> groups, and I can open the PI which shows them as a group, but I can?t
>> twirl down the group to see it?s contents. I can still right-click to edit
>> the group (and subsequent child groups) like normal.
>> 
>> This behavior displays across several machines and LC versions and the
>> groups are properly recognized in Geoff Canyon?s revNavigator. My research
>> led me to https://forums.livecode.com/viewtopic.php?t=27324 <
>> https://forums.livecode.com/viewtopic.php?t=27324> but
>> selectGroupedControls wasn?t the problem and ungrouping/regrouping didn?t
>> fix the issue (but DID cause some weird layering issues when regrouping).
>> 
>> Has anyone else experienced something like this? I feel like I?m
>> overlooking something simple.
>> 
>> --Andrew Bell
>> _
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Groups appear as buttons in Project Browser

[panagiotis m via use-livecode]

Hello Andrew,

Could it be the case you have chosen to order controls by name, instead of
layer?

(Click on the cog icon at the top right of the Project Browser, then choose
"Order Controls By" -> ... )

Kind regards,
Panos
--

On Wed, 7 Jul 2021 at 15:53, Andrew at MidWest Coast Media via use-livecode
 wrote:

> I have a stack that seems to have lost “groups” on several cards (but not
> all of them). They are still part of the structure but not recognized in
> the Tree View of the Project Browser. Rather than expandable groups in the
> PB, they show up as buttons. I can hover over and the tooltip calls them
> groups, and I can open the PI which shows them as a group, but I can’t
> twirl down the group to see it’s contents. I can still right-click to edit
> the group (and subsequent child groups) like normal.
>
> This behavior displays across several machines and LC versions and the
> groups are properly recognized in Geoff Canyon’s revNavigator. My research
> led me to https://forums.livecode.com/viewtopic.php?t=27324 <
> https://forums.livecode.com/viewtopic.php?t=27324> but
> selectGroupedControls wasn’t the problem and ungrouping/regrouping didn’t
> fix the issue (but DID cause some weird layering issues when regrouping).
>
> Has anyone else experienced something like this? I feel like I’m
> overlooking something simple.
>
> --Andrew Bell
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Stuck on native database functions

[Terence Heaford via use-livecode]

It also seems to do the escaping for you as it handled text containing commas 
in the description

All the best

Terry


> On 7 Jul 2021, at 16:40, Terence Heaford via use-livecode 
>  wrote:
> 
> The routine I have working is
> 
> put "uniqueID,date,type,description,amount,balance,category" into tFields
> 
> put merge("INSERT INTO [[tAccountName]] ([[tFields]]) 
> VALUES(:1,:2,:3,:4,:5,:6,:7)") into tSQL
> 
> revExecuteSQL dbGetID(), tSQL, "tValues[uniqueID]", "tValues[date]", 
> "tValues[type]", "tValues[description]", "tValues[amount]", 
> "tValues[balance]","tValues[category]"
> 
> put the result into tErr
> 
> return tErr
> 
> 
> It resolves the error I was getting relating to autoincrement.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Stuck on native database functions

[Terence Heaford via use-livecode]

Mark, it certainly helps me.

The routine I have working is

put "uniqueID,date,type,description,amount,balance,category" into tFields

put merge("INSERT INTO [[tAccountName]] ([[tFields]]) 
VALUES(:1,:2,:3,:4,:5,:6,:7)") into tSQL

revExecuteSQL dbGetID(), tSQL, "tValues[uniqueID]", "tValues[date]", 
"tValues[type]", "tValues[description]", "tValues[amount]", 
"tValues[balance]","tValues[category]"

put the result into tErr

return tErr


It resolves the error I was getting relating to autoincrement.

Thanks

Terry


> On 7 Jul 2021, at 11:29, Mark Smith via use-livecode 
>  wrote:
> 
> Currently I have this working
> 
> (Content of tSQL :)
> INSERT into TABLE1 ("complete", "todo", "itemDate", "category", "purgeDate", 
> "dgOrder") values(:1, :2, :3, :4, :5, :6)
> 
> 
> revExecuteSQL gConnectID, tSQL, "ptheRowA[complete]", "ptheRowA[todo]", 
> "ptheRowA[itemDate]", "ptheRowA[category]", "ptheRowA[purgeDate]", 
> "ptheRowA[dgOrder]”
> 
> I am not passing the entire array because there are some array elements that 
> I am not saving. If I did want to save/insert the whole array then I would 
> write something like:
> 
> revExecuteSQL gConnectID, tSQL, “ptheRowA”
> 
> Hope that helps,
> Mark

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Groups appear as buttons in Project Browser

[Andrew at MidWest Coast Media via use-livecode]

I have a stack that seems to have lost “groups” on several cards (but not all 
of them). They are still part of the structure but not recognized in the Tree 
View of the Project Browser. Rather than expandable groups in the PB, they show 
up as buttons. I can hover over and the tooltip calls them groups, and I can 
open the PI which shows them as a group, but I can’t twirl down the group to 
see it’s contents. I can still right-click to edit the group (and subsequent 
child groups) like normal.

This behavior displays across several machines and LC versions and the groups 
are properly recognized in Geoff Canyon’s revNavigator. My research led me to 
https://forums.livecode.com/viewtopic.php?t=27324 
 but selectGroupedControls 
wasn’t the problem and ungrouping/regrouping didn’t fix the issue (but DID 
cause some weird layering issues when regrouping).

Has anyone else experienced something like this? I feel like I’m overlooking 
something simple.

--Andrew Bell
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Stuck on native database functions

[Mark Smith via use-livecode]

Currently I have this working

(Content of tSQL :)
INSERT into TABLE1 ("complete", "todo", "itemDate", "category", "purgeDate", 
"dgOrder") values(:1, :2, :3, :4, :5, :6)


revExecuteSQL gConnectID, tSQL, "ptheRowA[complete]", "ptheRowA[todo]", 
"ptheRowA[itemDate]", "ptheRowA[category]", "ptheRowA[purgeDate]", 
"ptheRowA[dgOrder]”

I am not passing the entire array because there are some array elements that I 
am not saving. If I did want to save/insert the whole array then I would write 
something like:

revExecuteSQL gConnectID, tSQL, “ptheRowA”

Hope that helps,
Mark



> On Jul 7, 2021, at 12:06 AM, Bob Sneidar via use-livecode 
>  wrote:
> 
> Hi all. 
> 
> I assemble an SQL statement that looks like this: 
> 
> insert into ObjectProperties (recordid,rect,controlname,owner,visible) VALUES 
> (:1,:2,:3,:4,:5)
> 
> I then execute this statement: 
> 
> revExecuteSQL tDBID, tInsertSQL, aRecordData
> 
> I get records but with no data in them. I checked aRecordData and it has all 
> 5 columns as keys and data in each of them. 
> 
> I am at a complete loss. I was sure this was working before, now it is not. 
> 
> Bob S
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

mySQL 8

[Tiemo via use-livecode]

Hello folks,

 

I have a DB hosted on AWS and need to move it from mySQL 5.6 to 5.7 because
of AWS restrictions.

In this context I am doing tests and also tried to see what my programs
(LiveCode > PHP > mySQL) say about mySQL 8.

For this I imported a current 5.6 dump into a mySQL 5.7 and into a 8.0 test
DB.

 

With mySQL 5.7 everything looks so far well.

With mySQL 8 all umlauts come back destroyed in DB queries in my LiveCode
program.

 

When I look into the DB with mySQL Workbench, the umlauts are ok with 5.7 as
well as with 8.0. Only as soon as I get them into my LC program, they break.

 

Is here anybody, who has read about changes of handling the charset or
collations in mySQL databases with mySQL 8?

And any idea, where I should try to look for a fix? DB-collations/charsets?
PHP? LiveCode?

 

We are writing year 2021! and this is the third break of existing functions
handling umlauts within months after LC, macOS and now mySQL

 

Thanks for any ideas

 

Tiemo

 

 

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Stuck on native database functions

[Terence Heaford via use-livecode]

Out of interest and not sure if it is relevant but I have received this error:

"table myTable has 8 columns but 7 values were supplied"

Yes the table has 8 columns in total but the first column is

recID integer primary key autoincrement

Surely it should not give this error because I do not provide the value as this 
is autoincrement

All the best

Terry



> On 7 Jul 2021, at 08:50, Terence Heaford via use-livecode 
>  wrote:
> 
> Not sure what to try next

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Stuck on native database functions

[Terence Heaford via use-livecode]

Just tried this method

revExecuteSQL myID, "insert into mytable values(:1,:2,:1)", "valueX",”valueY"

It did not work

put 
merge("[[quote]][[tUniqueID]][[quote]],[[quote]][[tDate]][[quote]],[[quote]][[tType]][[quote]],[[quote]][[tDescription]][[quote]],[[quote]][[tAmount]][[quote]],[[quote]][[tBalance]][[quote]],[[quote]][[tCategory]][[quote]]")into
 tValues

put ":1,:2,:3,:4,:5,:6,:7" into tPlaceHolders

put merge("INSERT INTO [[tAccountName]] VALUES([[tPlaceHolders]])") into tSQL

put tSQL & " " & tValues

revExecuteSQL dbGetID(),tSQL,tValues


Not sure what to try next


All the best

Terry

> On 7 Jul 2021, at 08:28, Terence Heaford  wrote:
> 
> I have now tried your method with the tValues array directly and by 
> deconstructing the array as below and it does not work. I have a recollection 
> of not being able to get this to work with an array which is why I did the 
> way I did.
> 
> 
> All the best
> 
> Terry
> 
> put q(tAccountName) into tAccountName
> 
> put q(tValues["uniqueID"]) into tUniqueID
> 
> put q(tValues["date"]) into tDate
> 
> put q(tValues["type"]) into tType
> 
> put q(tValues["description"]) into tDescription
> 
> put q(tValues["amount"]) into tAmount
> 
> put q(tValues["balance"]) into tBalance
> 
> put q(tValues["category"]) into tCategory
> 
> put 
> merge("[[tUniqueID]],[[tDate]],[[tType]],[[tDescription]],[[tAmount]],[[tBalance]],[[tCategory]]”)
>  into tValues
> 
> 
> put ":1,:2,:3,:4,:5,:6,:7" into tPlaceHolders
> 
> put merge("INSERT INTO [[tAccountName]] VALUES([[tPlaceHolders]])") into tSQL
> 
> put tSQL & " " & tValues
> 
> revExecuteSQL dbGetID(),tSQL,tValues
> 
> 
> 
> 
> 
>> On 7 Jul 2021, at 07:52, Terence Heaford via use-livecode 
>> mailto:use-livecode@lists.runrev.com>> wrote:
>> 
>> Here’s an example I have been using, not sure whether it will help:
>> 
>> function dbAddTransaction tAccountName,tValues
>> 
>> put q(tAccountName) into tAccountName
>> 
>> put q(tValues["uniqueID"]) into tUniqueID
>> 
>> put q(tValues["date"]) into tDate
>> 
>> put q(tValues["type"]) into tType
>> 
>> put q(tValues["description"]) into tDescription
>> 
>> put q(tValues["amount"]) into tAmount
>> 
>> put q(tValues["balance"]) into tBalance
>> 
>> put q(tValues["category"]) into tCategory
>> 
>> put "uniqueID,date,type,description,amount,balance,category" into tFields
>> 
>> put 
>> merge("[[tUniqueID]],[[tDate]],[[tType]],[[tDescription]],[[tAmount]],[[tBalance]],[[tCategory]]")into
>>  tValues
>> 
>> put merge("INSERT INTO [[tAccountName]] ([[tFields]]) VALUES([[tValues]])") 
>> into tSQL
>> 
>> revExecuteSQL dbGetID(), tSQL
>> 
>> put the result into tErr
>> 
>> return tErr
>> 
>> end dbAddTransaction
>> 
>> -
>> 
>> function dbEscapeSqlite tText
>> 
>> replace "'" with "''" in tText
>> 
>> return tText
>> 
>> end dbEscapeSqlite
>> 
>> ---
>> 
>> function q tText
>> 
>> return "'" & dbEscapeSqlite(tText) & "'"
>> 
>> end q
>> 
>> ---
>> 
>> 
>> 
>> 
>>> On 7 Jul 2021, at 00:06, Bob Sneidar via use-livecode 
>>> mailto:use-livecode@lists.runrev.com>> 
>>> wrote:
>>> 
>>> Hi all. 
>>> 
>>> I assemble an SQL statement that looks like this: 
>>> 
>>> insert into ObjectProperties (recordid,rect,controlname,owner,visible) 
>>> VALUES (:1,:2,:3,:4,:5)
>>> 
>>> I then execute this statement: 
>>> 
>>> revExecuteSQL tDBID, tInsertSQL, aRecordData
>>> 
>>> I get records but with no data in them. I checked aRecordData and it has 
>>> all 5 columns as keys and data in each of them. 
>>> 
>>> I am at a complete loss. I was sure this was working before, now it is not. 
>>> 
>>> Bob S
>>> 
>>> 
>>> ___
>>> use-livecode mailing list
>>> use-livecode@lists.runrev.com 
>>> Please visit this url to subscribe, unsubscribe and manage your 
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com 
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Stuck on native database functions

[Terence Heaford via use-livecode]

I have now tried your method with the tValues array directly and by 
deconstructing the array as below and it does not work. I have a recollection 
of not being able to get this to work with an array which is why I did the way 
I did.


All the best

Terry

put q(tAccountName) into tAccountName

put q(tValues["uniqueID"]) into tUniqueID

put q(tValues["date"]) into tDate

put q(tValues["type"]) into tType

put q(tValues["description"]) into tDescription

put q(tValues["amount"]) into tAmount

put q(tValues["balance"]) into tBalance

put q(tValues["category"]) into tCategory

put 
merge("[[tUniqueID]],[[tDate]],[[tType]],[[tDescription]],[[tAmount]],[[tBalance]],[[tCategory]]”)
 into tValues


put ":1,:2,:3,:4,:5,:6,:7" into tPlaceHolders

put merge("INSERT INTO [[tAccountName]] VALUES([[tPlaceHolders]])") into tSQL

put tSQL & " " & tValues

revExecuteSQL dbGetID(),tSQL,tValues





> On 7 Jul 2021, at 07:52, Terence Heaford via use-livecode 
>  wrote:
> 
> Here’s an example I have been using, not sure whether it will help:
> 
> function dbAddTransaction tAccountName,tValues
> 
> put q(tAccountName) into tAccountName
> 
> put q(tValues["uniqueID"]) into tUniqueID
> 
> put q(tValues["date"]) into tDate
> 
> put q(tValues["type"]) into tType
> 
> put q(tValues["description"]) into tDescription
> 
> put q(tValues["amount"]) into tAmount
> 
> put q(tValues["balance"]) into tBalance
> 
> put q(tValues["category"]) into tCategory
> 
> put "uniqueID,date,type,description,amount,balance,category" into tFields
> 
> put 
> merge("[[tUniqueID]],[[tDate]],[[tType]],[[tDescription]],[[tAmount]],[[tBalance]],[[tCategory]]")into
>  tValues
> 
> put merge("INSERT INTO [[tAccountName]] ([[tFields]]) VALUES([[tValues]])") 
> into tSQL
> 
> revExecuteSQL dbGetID(), tSQL
> 
> put the result into tErr
> 
> return tErr
> 
> end dbAddTransaction
> 
> -
> 
> function dbEscapeSqlite tText
> 
> replace "'" with "''" in tText
> 
> return tText
> 
> end dbEscapeSqlite
> 
> ---
> 
> function q tText
> 
> return "'" & dbEscapeSqlite(tText) & "'"
> 
> end q
> 
> ---
> 
> 
> 
> 
>> On 7 Jul 2021, at 00:06, Bob Sneidar via use-livecode 
>>  wrote:
>> 
>> Hi all. 
>> 
>> I assemble an SQL statement that looks like this: 
>> 
>> insert into ObjectProperties (recordid,rect,controlname,owner,visible) 
>> VALUES (:1,:2,:3,:4,:5)
>> 
>> I then execute this statement: 
>> 
>> revExecuteSQL tDBID, tInsertSQL, aRecordData
>> 
>> I get records but with no data in them. I checked aRecordData and it has all 
>> 5 columns as keys and data in each of them. 
>> 
>> I am at a complete loss. I was sure this was working before, now it is not. 
>> 
>> Bob S
>> 
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Stuck on native database functions

[Terence Heaford via use-livecode]

Here’s an example I have been using, not sure whether it will help:

function dbAddTransaction tAccountName,tValues

put q(tAccountName) into tAccountName

put q(tValues["uniqueID"]) into tUniqueID

put q(tValues["date"]) into tDate

put q(tValues["type"]) into tType

put q(tValues["description"]) into tDescription

put q(tValues["amount"]) into tAmount

put q(tValues["balance"]) into tBalance

put q(tValues["category"]) into tCategory

put "uniqueID,date,type,description,amount,balance,category" into tFields

put 
merge("[[tUniqueID]],[[tDate]],[[tType]],[[tDescription]],[[tAmount]],[[tBalance]],[[tCategory]]")into
 tValues

put merge("INSERT INTO [[tAccountName]] ([[tFields]]) VALUES([[tValues]])") 
into tSQL

revExecuteSQL dbGetID(), tSQL

put the result into tErr

return tErr

end dbAddTransaction

-

function dbEscapeSqlite tText

replace "'" with "''" in tText

return tText

end dbEscapeSqlite

---

function q tText

return "'" & dbEscapeSqlite(tText) & "'"

end q

---




> On 7 Jul 2021, at 00:06, Bob Sneidar via use-livecode 
>  wrote:
> 
> Hi all. 
> 
> I assemble an SQL statement that looks like this: 
> 
> insert into ObjectProperties (recordid,rect,controlname,owner,visible) VALUES 
> (:1,:2,:3,:4,:5)
> 
> I then execute this statement: 
> 
> revExecuteSQL tDBID, tInsertSQL, aRecordData
> 
> I get records but with no data in them. I checked aRecordData and it has all 
> 5 columns as keys and data in each of them. 
> 
> I am at a complete loss. I was sure this was working before, now it is not. 
> 
> Bob S
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode