Search found 99 matches

by nicoloose
Tue Nov 04, 2014 7:37 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Unexpected error with revdb_query
Replies: 16
Views: 5359

Re: Unexpected error with revdb_query

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.
by nicoloose
Tue Nov 04, 2014 7:19 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Unexpected error with revdb_query
Replies: 16
Views: 5359

Re: Unexpected error with revdb_query

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...
by nicoloose
Mon Nov 03, 2014 11:27 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Unexpected error with revdb_query
Replies: 16
Views: 5359

Re: Unexpected error with revdb_query

Ok so the output is the same in both LC6 & LC7 so nothing wrong with the Data.
by nicoloose
Mon Nov 03, 2014 8:36 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Unexpected error with revdb_query
Replies: 16
Views: 5359

Re: Unexpected error with revdb_query

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?
by nicoloose
Fri Oct 31, 2014 9:03 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Unexpected error with revdb_query
Replies: 16
Views: 5359

Re: Unexpected error with revdb_query

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?
by nicoloose
Thu Oct 30, 2014 2:06 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Unexpected error with revdb_query
Replies: 16
Views: 5359

Re: Unexpected error with revdb_query

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.
by nicoloose
Thu Oct 30, 2014 9:39 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Unexpected error with revdb_query
Replies: 16
Views: 5359

Re: Unexpected error with revdb_query

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 ...
by nicoloose
Wed Oct 29, 2014 2:37 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Designing IOS apps
Replies: 0
Views: 745

Designing IOS apps

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...
by nicoloose
Wed Oct 29, 2014 10:09 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Unexpected error with revdb_query
Replies: 16
Views: 5359

Re: Unexpected error with revdb_query

Having done further debugging, it always fails where there is a
Where
clause using ":1" ...
by nicoloose
Wed Oct 29, 2014 9:49 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Unexpected error with revdb_query
Replies: 16
Views: 5359

Unexpected error with revdb_query

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...
by nicoloose
Thu Oct 02, 2014 7:36 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Unusual code behavior between 6.6.2 and 7.0
Replies: 0
Views: 968

Unusual code behavior between 6.6.2 and 7.0

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 ...
by nicoloose
Fri Aug 08, 2014 10:25 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Using Livecode to dump backup mySql database
Replies: 5
Views: 1415

Re: Using Livecode to dump backup mySql database

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.
by nicoloose
Tue Aug 05, 2014 7:57 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Using Livecode to dump backup mySql database
Replies: 5
Views: 1415

Re: Using Livecode to dump backup mySql database

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...
by nicoloose
Mon Aug 04, 2014 3:23 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Using Livecode to dump backup mySql database
Replies: 5
Views: 1415

Using Livecode to dump backup mySql database

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...
by nicoloose
Tue Jun 24, 2014 8:34 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: List of files on server for download
Replies: 7
Views: 1941

Re: List of files on server for download

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...

Go to advanced search