LiveCode Forums

revExecuteSQL databaseID,SQLStatement [,{variablesList | arrayName}]

You are providing a 'fully qualified' SQL statement so all you need is

put revExeuteSQL myID, theQuery into tResult

Check the Dictionary for more info on the variableList | arrayName format.

a) If the key is autoincrement you can leave it out of the INSERT statement. b) You are not running a query so you don't use revDataFromQuery. You are executing an SQL statement so you need to use revExecuteSQL. If you are retrieving data from a DB you use revDataFromQuery, or one of its 'sisters'. ...

INSERT INTO UserValidation (UserName,Password,UserEmail,UserActive,UserStatus,GroupID) VALUES (<<whatever the values are>>)

Assuming 'UserValidation' is the name of your table.

FYI, the 'see what's new' button takes one to the following URL:

http://droptools.sonsothunder.com/dtvershist.irev

Which doesn't show the version history.

BvG wrote: the main reason it works with the same date is inherent behaviour. The data is assembled with repeat loops, and those can only go one direction, down the list, if you switch the lines around, you'll get the weird behaviour that you feared might happen

Ah.

Thanks!

So that's two data lines with the same time value? Interesting.

Thanks!

Can you explain why that works? I've been avoiding adding lines with duplicate time values.

The subject of this message is horrible, but I don't know how else to phrase it. The following data generates the chart shown below: 1293868800,50,0 1293955200,50,0 1305874800,50,40 1305961200,50,40 1325404800,50,40 1325491200,0,40 1329379200,0,40 1329465600,0,40 LiveCodeScreenSnapz029.jpg Which is ...

Card 1 can only move to Card 2, right? Card 3 can only move to Card 2, right? Card 2 can move to Card 1 or Card 3, right? If that is the case, I can't see how you'll be able to have a single button handle the navigation on Card 2. How would it know which card you wanted to go to? So Card 2 will need...

Oh, and the breakpoint command did the job.

Looks like I'll be using that from now on since it is more reliable.

Thanks!

We stayed away from these in glx2 because there are other problems associated with breakpoints tied to a particular line number while you're editing text. I was using glx2 for a while, but the IDE is so unstable for me I disabled it to try to narrow down the cause, and haven't put it back yet (most...

As proof that the stuff you might think is not relevant probably is, I did some work to fix the X-axis grid label calculations, and the chart now scrolls properly*. * - for the most part. Still have some graphic anomalies off the left edge after scrolling a bunch, but I'll see if I can work those ou...

I'm using the 'click the margin' method to set the breakpoint. I can try the breakpoint command, although I would have expected them to be equivalent.

Built in script editor.

Don't know what 'breakpoint trigger expressions' means, so hopefully I don't have any defined.

It is entirely possible I'm doing stuff with CE that should not be done, but here we go.... I've linked (too big to attach) a QuickTime Movie of the behavior I'm seeing, because I think it's probably too convoluted to explain clearly in a written post. http://www.graymattercomputing.com/files/screen...

It appears that a breakpoint is only triggered once per 'run' or debugging session, is this correct? If it is correct, is it really the intended behavior? I put a breakpoint in a handler that is called more than once. On the first visit to the handler, the breakpoint is reached, and I am kicked to t...