LiveCode Forums

I have just downloaded the update V7.0.1-RC-1 and this has fixed the problem. It must have been a bug.

Thanks all for your comments.

When I contacted support, I was told to log it as a bug but it is very difficult to reproduce the error without including all my code so I thought perhaps the community would see something I am missing. I can't accept it's a code problem. If it works seamlessly in LC6 then there should be no problem...

Ok so the output is the same in both LC6 & LC7 so nothing wrong with the Data.

I suspect that the database has wrong data or the query is wrong.

Does LC6 treat data and queries differently than LC7? I'm sorry to keep going back to this but if the data was wrong or the query was incorrect, surely when I run the code in LC6 I would also get an error?

I am using a mySQL database. It doesn't explain why there is no issues with LC6.6 but the same code will not run using LC7?

The result is blank.

I have multiple libraries which utilise the same code to return results and the puzzling thing is, there is no problem at all with earlier versions of LC. I have based my application of Jan's Tea Lib http://www.quartam.com/downloads/tea.zip example.

After trying your suggestion of: put revDataFromQuery(TAB, return, conID,tSQL,pSqlParamsA[1],pSqlParamsA[2] ) into tResults I got the following error still: revdberr,You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ...

I have recently completed a full manufacturing and sales application written with MySQL as the backend. I now want to translate this app into an IOS app and I have a couple of questions: How do externals work? Since DLL files need to be included, how is this achieved? My app is made up of many sub-s...

Having done further debugging, it always fails where there is a

Where

clause using ":1" ...

Good day, When I run my app using 6.6.2 I have no errors but when I run it using livecode 7, I get an error at the following line of code saying that there is a syntax error in my select statement: put revdb_query(sDBConnectionId, pQuery, "pSqlParamsA") into tCursorId The pQuery looks like this : SE...

Good day... I have created a large database driven application using Andre Garzia's DBLib. The app stores and accesses data from mySQL running off an XAMPP server. All works beautifully in ver 6.6.2. After upgrading to ver 7.0 and all subsequent versions of 7, I cannot build a data grid as I get an ...

Many thanks for those two suggestions. I will be testing them both but I think a cron task is actually best. No user input is more reliable.

It seems a bit long winded so I thought that I could embed some PHP scripts to do the work for me.. I will look into it. Unfortunately, my users would not be able to use PhpMyadmin tools which is why I would need them to use LC. Click a button, choose a folder and press go and the script does the re...

Hi all, I would like my users to be able to backup data from my mySql database and store the backup in a specific location. The location is the easy part but I am wondering what the best way is to backup every table, each with it's own filename. I guess this would require iterating through all the t...

So I have done the following: //Get a list of files on the server    -- Get server list:    put "http://10.0.0.101/mfgproupdate/MyFileList.txt" into tUrl    put url tUrl into tServerList set the itemdelimiter to comma repeat for each line tFile in tServerList put tFilePath & "/" & item 1 of tFile in...