Search found 5 matches

by manofarms
Tue Apr 10, 2012 4:52 am
Forum: Databases
Topic: SQLite Syntax Error Only in Livecode
Replies: 4
Views: 1621

Re: SQLite Syntax Error Only in Livecode

I figured it out.

I replaced

Code: Select all

revExecuteSQL(dbID, tSQL)
with the command

Code: Select all

revdb_execute(dbID, tSQL)
and it works now. Strange, but the older syntax works better.
by manofarms
Tue Apr 10, 2012 2:39 am
Forum: Databases
Topic: SQLite Syntax Error Only in Livecode
Replies: 4
Views: 1621

Re: SQLite Syntax Error Only in Livecode

Perhaps Rev does not like the quotes in here: '"auapDmnea4KYDCjlbHK2Hbx6X-Q/Q09EUG9zRFBKaEVBQUFBQUFBQUFBQT09"' I looked into that and got rid of the quotes, but it still gives the same error. I honestly have no idea what to do now. The syntax is fine according to SQL. Why does livecode hate me so? :x
by manofarms
Fri Apr 06, 2012 10:03 am
Forum: Databases
Topic: SQLite Syntax Error Only in Livecode
Replies: 4
Views: 1621

SQLite Syntax Error Only in Livecode

Hi all, I've searched the forum and haven't found a relevant thread. I feel the question is important. I've got an SQLite statement that will execute in multiple database editors but it won't execute in livecode. This is the code that generates the SQLite Statment on updateDatabase local queryFields...
by manofarms
Tue Feb 07, 2012 2:11 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Oiling the Gears in an App with Lots of Moving Parts
Replies: 3
Views: 575

Re: Oiling the Gears in an App with Lots of Moving Parts

Alright, I've changed a lot of the inner workings. I am only using an intersect once to check and see if the planet is over the right orbit when the mouse is let go. I got rid of the move commands and am using set locations in a nifty little "send with messages" loop. I still am having some lag thou...
by manofarms
Thu Feb 02, 2012 3:36 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Oiling the Gears in an App with Lots of Moving Parts
Replies: 3
Views: 575

Oiling the Gears in an App with Lots of Moving Parts

I've got a relatively simple graphical drag and drop game that I'm building for practice. It consists of dragging the planets to the correct orbits around the sun. Currently, when the user drags a planet to the correct orbit, the planet (which is a button object) moves along a circular path determin...

Go to advanced search