Re: Sounds in iOS

2012-02-21 Thread Ken Corey
On 20/02/2012 21:28, Graham Samuel wrote: I haven't had much luck on my iOS iPad app with waiting until a sound is done (RR have just said I found a bug), but ignoring this issue I can't get a really simple 'play' statement to work. I have a button play "Xylo.AIF" Hi Graham, I found it a bi

Re: How to use an array to solve the following...

2012-02-21 Thread Glen Bojsza
Sorry got caught up on an issue... So far things look very fast and seem to give the results I need (will confirm as I use larger data sets that have a known answer). But this does bring up a question and doing more than planned with the final lists... If the final list is kept in sequential ord

Re: How to use an array to solve the following...

2012-02-21 Thread Geoff Canyon Rev
Depends on how big the list is. Unless there's a faster method than the one I used (or you're using slower hardware than I am), you should be okay up to about 100,000 rows using something like: repeat for each line L in the keys of yourArray if L > 20 and L < 60 then put L & cr after R

Re: How to use an array to solve the following...

2012-02-21 Thread Kay C Lan
On Tue, Feb 21, 2012 at 2:09 PM, Dick Kriesel wrote: > On Feb 20, 2012, at 9:37 PM, Kay C Lan wrote: > > > Anyone want to test the speed of finding data in a 100 line variable > > using char -1 of word -1 of item -1 of line -1? > > Hi, Kay. Sure. How do I get the script? > > I'd guess that

Re: How to use an array to solve the following...

2012-02-21 Thread Kay C Lan
On Tue, Feb 21, 2012 at 4:29 PM, Glen Bojsza wrote: > Or will Kay prove it to be faster > with just lists :-) > > Already proven. I agree with Geoff. For the data example you have provided and the queries you are suggesting, LC can easily handle it using repeat for each line and an if statement a

Re: How to use an array to solve the following...

2012-02-21 Thread Glen Bojsza
I was thinking more along the lines (no pun intended) of - find line number of starting value (for example line 578 ) - find line line number of ending value (for example 12125) put lines 578 to 12125 into results Can this be done verses looping through each line since we know the xs column is

Re: How to use an array to solve the following...

2012-02-21 Thread Kay C Lan
Glen, Look at my test results more closely: Finding the 1st item of the 1st line using direct reference = 3ms Finding the last item of the last line using direct reference = 440294ms Finding the -1 item of the 1st line using direct reference = 5ms Finding the -1 item of the -1 line using direct r

Re: How to use an array to solve the following...

2012-02-21 Thread Glen Bojsza
Then repeat for is King in Livecode! thanks for everyone's feedback . On Tue, Feb 21, 2012 at 2:52 AM, Kay C Lan wrote: > Glen, > > Look at my test results more closely: > > Finding the 1st item of the 1st line using direct reference = 3ms > Finding the last item of the last line using direct r

Re: iOS And XML Image Results Download in the Background?

2012-02-21 Thread Gerry Orkin
Yep, this is do-able. Have a look at this post on the forums: http://forums.runrev.com/viewtopic.php?f=49&t=8934&start=15#p43063 . That's an example of an iOS app that downloads another stack from the internet and then goes to that stack. You have a different use case but the method of download

iPhone audio calls

2012-02-21 Thread Richard MacLemale
In our latest app (which is for iOS) we use a lot of iphone audio calls to set volume channels and play sounds, like: iPhoneSetSoundChannelVolume "Ch_1","80" and so on. The annoying thing is that since the Mac doesn't understand those commands, you get nonstop errors in the development environ

Re: iPhone audio calls

2012-02-21 Thread Gerry Orkin
I can't think of a better method... g On 21/02/2012, at 10:49 PM, Richard MacLemale wrote: > Is that the best method, or would there be a better way? ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsu

Re: iOS And XML Image Results Download in the Background?

2012-02-21 Thread Ken Corey
Sure, why not? Let's assume that this is all kicked off from a button press: -- I assume you have your URLs in a list on mouseUp -- send in 0 milliseconds means call downloadImage as soon -- as this handler is done -- I'd create placeholder graphics where the images might -- go onc

Re: How to use an array to solve the following...

2012-02-21 Thread Kay C Lan
On Tue, Feb 21, 2012 at 4:29 PM, Glen Bojsza wrote: > > For example a user wants an starting xs value of 10 and an ending xs value > of 40 I think that if the keys are sequential (the keys being the first > column - xs) then it would be a fast solution using arrays since you should > be able to d

Re: iPhone audio calls

2012-02-21 Thread Paul Hibbert
As with most things in LiveCode there are many ways to tackle most problems, I haven't done any mobile development yet, but I assume the custom properties work the same, if so a quick fix for this could be to use a custom property that is set to true on preOpenStack and then check that custom pr

Re: How to use an array to solve the following...

2012-02-21 Thread Glen Bojsza
Once the final list has been made it could have up to 10 ?t columns but the query is only for the lines identified as start and end based on the first column which is xs. There would be no other queries involving the data in the ?t columns the whole line that meets the xs query is moved to a new l

RE: Omegabundle for LiveCode 2012 Released: Get the Top DeveloperAdd-ons for LiveCode

2012-02-21 Thread Lynn Fredricks
> Does tm tools get mentioned twice because it's twice as good > as the rest? Scott's beard makes its own demands, separate from Scott. tm|tools gets an addition this year, too - tm|control basic. It's a worthy new addition. This is also the first year for Ah Software among us, and Mark's very f

Re: How to use an array to solve the following...

2012-02-21 Thread Geoff Canyon Rev
On Tue, Feb 21, 2012 at 3:52 AM, Kay C Lan wrote: > repeat for each line L in the keys of yourArray > if L > 20 then > put L & cr after R > if L > 60 then >exit repeat > end if > end if > end repeat > > Don't waste cyling through lines you do

Re: How to use an array to solve the following...

2012-02-21 Thread Geoff Canyon Rev
On Tue, Feb 21, 2012 at 8:36 AM, Glen Bojsza wrote: > The good news is that the lists may grow as high as 1,000,000 lines and are > as little as 30,000. > 1,000,000 lines is pretty big. If you're guaranteed to be working on a recent machine, then perhaps it would be okay. But that's certainly pu

Re: Using DropBox for Faster Mobile Development

2012-02-21 Thread Ben Rubinstein
On 21/02/2012 00:11, Bob Sneidar wrote: That is possible. The craziness is that the trailing cr affects the result even if the filtered text does not include the last line of the list. If there is a trailing cr, then the result will end with a cr no matter WHICH lines end up in the filtered te

Re: Visual effect problems in iOS

2012-02-21 Thread Chris Sheffield
Graham, Not sure if you've ever found a solution for this problem, but I've got a couple other suggestions that may help. First, if you're simply issuing a command like: visual effect "whatever" go cd "someCard" then this should work just fine. I've found that if something like

Re: How to use an array to solve the following...

2012-02-21 Thread Richard Gaskin
Pete wrote: Interesting, and it kinda makes sense. For elements, there's no positioning required like with lines/words/item, just a case of cycling through the keys - which is what "repeat for each line in the keys of does I suppose. As with most things in computing, the truly optimal soluti

Re: Omegabundle for LiveCode 2012 Released: Get the Top DeveloperAdd-ons for LiveCode

2012-02-21 Thread Matthias Rebbe
Hm, does this mean you need to have a beard to get your products included in the Omega bundle? Or are developers w/o beards also welcome? ;) Matthias Am 21.02.2012 um 15:54 schrieb Lynn Fredricks: >> Does tm tools get mentioned twice because it's twice as good >> as the rest? > > Scott's b

Re: Omegabundle for LiveCode 2012 Released: Get the Top DeveloperAdd-ons for LiveCode

2012-02-21 Thread Klaus on-rev
Hi Matthias, Am 21.02.2012 um 17:52 schrieb Matthias Rebbe: > Hm, > > does this mean you need to have a beard to get your products > included in the Omega bundle? Or are developers w/o beards also welcome? ;) I think it is completely sufficient if you just don't shave for at least a day to

Re: Recreating a binary stack from xml text

2012-02-21 Thread Bob Sneidar
Well I have made good use of the find dialog. I tried to do a search using all other to find something in a property (not sure if that would do it) and LC locked up most of the way through the search. I waited a minute or two and it didn't move so I was forced to force quit. A search specificall

Re: Omegabundle for LiveCode 2012 Released: Get the Top DeveloperAdd-ons for LiveCode

2012-02-21 Thread Ken Corey
On 21/02/2012 16:52, Matthias Rebbe wrote: does this mean you need to have a beard to get your products included in the Omega bundle? Or are developers w/o beards also welcome? ;) Sure, you're welcome, but apparently you must leave your spell checker at home: "tmGuage" *cheeky grin* Serio

Re: Visual effect problems in iOS

2012-02-21 Thread Ken Ray
On Feb 20, 2012, at 2:26 PM, Graham Samuel wrote: > Having finally reviewed that page (12) I notice that the description doesn't > apply to my case. I have not locked the screen, and am just doing a > card-to-card transition. As I said, my very simple example works (set up a > "flip left" visu

Re: Omegabundle for LiveCode 2012 Released: Get the Top DeveloperAdd-ons for LiveCode

2012-02-21 Thread Ken Corey
On 21/02/2012 17:09, Ken Corey wrote: Seriously though, there's a *lot* of stuff here. What're the licensing terms? Is it a per-year fee, or is it a buy-it-once kind of affair? Also, it'd be *real* handy to know what platforms those items (or their outputs) run on. Franklin is for Windows/Mac

Re: Visual effect problems in iOS

2012-02-21 Thread Michael Doub
Let me join you on the soapbox. I agree with you that support for all platforms should be the same. I am less of an language purest, but I am happy to support you. -= Mike On 02/21/2012, at 12:12 PM, Ken Ray wrote: > > On Feb 20, 2012, at 2:26 PM, Graham Samuel wrote: > >> Having finall

Re: Sounds in iOS

2012-02-21 Thread Graham Samuel
Thanks to Mark and Ken for interesting insights. I am beginning to think that embedded sounds within stacks don't work in iOS, even if one does respect case sensitivity. I am going to do some more tests, but basically I found that Ken's method (using an external file) works for me, but despite b

Re: Sounds in iOS

2012-02-21 Thread Mark Schonewille
Graham, I think that's what both Ken and I tried to make clear to you. A _path_ means: a path to an external file. That is the _only_ way to make it work. Also, this external file _must_ be a sound file and not a stack with an embedded sound. Embedded sounds don't work in iOS. This is explicitl

Re: Recreating a binary stack from xml text

2012-02-21 Thread Bob Sneidar
On Feb 20, 2012, at 8:45 PM, Pete wrote: > As for datagrids, the controls that are permanent fixtures of a datagrid > are easily identifiable, the rest should not be considered in this scheme > since they change dynamically every time data is loaded into a datagrid, > not when the datagird struct

Re: Visual effect problems in iOS

2012-02-21 Thread Graham Samuel
Thanks Chris I am embarrassed to say that my card-to-card effects are now working! I had a completely repeatable recipe to show they won't working yesterday, but a restart of my machine and a test immediately afterwards (both on the simulator and the iPad itself) showed the effects working fine

Re: Recreating a binary stack from xml text

2012-02-21 Thread Bob Sneidar
As I have said before, they are the blocks in the "constructor set" or "prefab building kit" if you will. They are a part of the IDE, and I think LC was written in Objective C (If I am not totally mistaken). Bob On Feb 20, 2012, at 9:30 PM, Michael Chean wrote: > Thanks this conversation has

Re: Recreating a binary stack from xml text

2012-02-21 Thread Bob Sneidar
One of the things that frustrated me with Filemaker is that references to tables were constants. You could not by script save the name of a table in a variable, and then reference the table by name. At the time it was essential to me to be able to do that, so I could set some environment variabl

Re: iPhone audio calls

2012-02-21 Thread Bob Sneidar
Yes create a command that does the same thing. have it check the environment first. Now you have a one liner you can call in your code. The principle applies to ALL programming: If you use a bit of code repeatedly, create a command or function for it. Bob On Feb 21, 2012, at 3:49 AM, Richard

Re: Using DropBox for Faster Mobile Development

2012-02-21 Thread Bob Sneidar
I see it differently. The same command with essentially the same data (except for the one trailing cr) returns different results. The FILTER command works with lines. It doesn't know from squat whether or not the developer meant to "terminate" or "delimit" and simply forgot to "terminate" the la

Re: Visual effect problems in iOS

2012-02-21 Thread Peter M. Brigham, MD
Ah, another grammarhead! I love it! I've always found it interesting that the obsessive focus on syntax and grammar needed by programmers/coders to use the coding language well is rarely associated with equal attention to grammatical English. -- Peter Peter M. Brigham pmb...@gmail.com http://h

Re: How to use an array to solve the following...

2012-02-21 Thread Bob Sneidar
Even with repeat for each line, the chunk has to be parsed in memory for returns before proceeding. An array is by nature already parsed. As has been discussed before, the repeat for each command is so fast because it parses the memory used by the chunk, creating a list of pointers (forgive me i

dereference a string as a custom property...

2012-02-21 Thread Ken Corey
Hi All, I'm making a silly little animate function for my app. Let's say I have a grc "new". I'd like to be able to animate it like this: animate (the long name of grc "new", "loc 100,50;width 40%;height 50%;foregroundColor 255,0,0",200) How do I pass the name of a custom property, and then

Re: How to use an array to solve the following...

2012-02-21 Thread Bob Sneidar
Take for example retrieving a large data set from an SQL db. You can retrieve it as a cursor, and array or a string. Cursors are read only and I don't see the advantage of working with them. That leaves only arrays and strings. So if you *can* get the data as an array, and sorting is not an issu

RE: Omegabundle for LiveCode 2012 Released: Get the TopDeveloperAdd-ons for LiveCode

2012-02-21 Thread Lynn Fredricks
> does this mean you need to have a beard to get your products > included in the Omega bundle? Or are developers w/o beards > also welcome? ;) Non-beards on a probationary basis, though Gandalf-class eyebrows or moustaches will cut weeks off of probation :-)> Best regards, Lynn Fredricks Pre

RE: Omegabundle for LiveCode 2012 Released: Get the TopDeveloperAdd-ons for LiveCode

2012-02-21 Thread Lynn Fredricks
> Seriously though, there's a *lot* of stuff here. What're the > licensing terms? Is it a per-year fee, or is it a > buy-it-once kind of affair? Everything is under its own license. Valentina products + Franklin 3D all come with 12 months of updates. I can't speak for the other vendors but this

Re: dereference a string as a custom property...

2012-02-21 Thread Ken Corey
On 21/02/2012 18:10, Ken Corey wrote: How do I pass the name of a custom property, and then use it in a statement? *sigh* open mouth, switch feet put "testing" into tP new grc set the tP of it to "blue cheese" answer "the testing of it is "&the testing of it Note to self: at least try things

RE: Omegabundle for LiveCode 2012 Released: Get the TopDeveloperAdd-ons for LiveCode

2012-02-21 Thread Lynn Fredricks
> Also, it'd be *real* handy to know what platforms those items > (or their > outputs) run on. Franklin is for Windows/Mac only, how about > Valentina? > The ChartMaker would be useful on an iOS app I'm building, > as would the TM Tools, if they work there. For Valentina ADK+, you get Linux

Re: Recreating a binary stack from xml text

2012-02-21 Thread Pete
Hi Bob, As mentioned in my original email, I don't consider detecting changes in data part of this project. It would be kinda like asking the tool to check the contents of two snapshots of an SQL database that is somehow linked to a stack. That's not to say it's not important, just beyond the sco

Re: Sounds in iOS

2012-02-21 Thread Graham Samuel
Hi Mark Sorry, it wasn't clear to me that embedded sounds are outlawed, only that if one chooses to use an external sound file, one has to be more careful than in playing sounds on other platforms. The documentation is not very clear on this IMHO. For example, the LC Dictionary's section on "pl

Re: Sounds in iOS

2012-02-21 Thread Ken Corey
On 21/02/2012 19:57, Graham Samuel wrote: If you can point me at an explicit statement about this in the LC documentation, I'd be grateful. Well, you could argue the point about the documentation, or you could look at the code that I put on my web server. And the relevant code is just a few

Re: How to use an array to solve the following...

2012-02-21 Thread Richard Gaskin
Bob Sneidar wrote: > Repeat for each line x in the keys of array y would seem at a glance > to have to reevaluate the keys of each time through the loop, > wouldn't it? You must mean you get the keys first in a variable and > then use that. If I understand how the engine treats that, it seems t

RFC: Silly little Animate function...

2012-02-21 Thread Ken Corey
Hi All, I now have that silly little animate function I was threatening earlier. I post it here for comments. Is this done in a Livecode-style? Are there CPU hogs I'm hiding in here? Can anyone spot any errors? Any improvements/speed-ups you can suggest? I noticed that the regular expressi

Re: How to use an array to solve the following...

2012-02-21 Thread Bob Sneidar
You are probably right, I imagined in my mind that when the engine parses the chunk, it had to already be in memory, as in a variable or array. Since the thing being parsed was a statement that evaluated to something, it seemed that the engine would have nothing in existence to parse to begin wi

Re: How to use an array to solve the following...

2012-02-21 Thread Geoff Canyon Rev
As Richard said, the engine is smart enough to avoid this pitfall. So no, it's perfectly fine to say repeat for each line x in the keys of array y even if the list of keys is large. On Tue, Feb 21, 2012 at 12:03 PM, Bob Sneidar wrote: > Repeat for each line x in the keys of array y would seem

Re: Recreating a binary stack from xml text

2012-02-21 Thread Geoff Canyon Rev
Yeah, I'm not by any means saying FileMaker is perfect. It has limitations I can't stand as well. Every environment I know does. I wish LC also had J's unlimited ability to handle arrays, and reversible functions, and several other features. I also wish -- desperately -- that LC had LISP's macros.

Re: Recreating a binary stack from xml text

2012-02-21 Thread Mark Wieder
Geoff Canyon Rev writes: > I'm looking at the docs for Eclipse and I see "safe rename." Is that what > you're talking about? Out of curiosity does it mean that when you rename > something, it goes through all your source files looking for references to > that thing, and changes them? Yes on both

Re: Visual effect problems in iOS

2012-02-21 Thread Pete
Interesting. There's an example in the dictionary that specifically uses "slowly" but sounds like you can't use that any longer. At the risk of giving Ken apoplexy, you could argue that "slow" is being used as an adjective to describe the speed property of the visual effect command, not as an adv

Standalone blocked by "software restriction policy"

2012-02-21 Thread AcidJazz
We're running a large study with Canadian physicians. They must download a standalone file to their computer. The other day one of the lab assistants was checking the program and got the following message on her windows machine: "Windows cannot open this program because it has been prevented by

Re: Standalone blocked by "software restriction policy"

2012-02-21 Thread Mark Schonewille
Hi Mark, This happens all the time, particularly in large companies, research institutes and schools. As the message says: you should contact an administrator and have the app installed by him or her. Frankly, I think this isn't your problem. If the lab assistant wants to use your app, then th

Re: Standalone blocked by "software restriction policy"

2012-02-21 Thread Terry Judd
Mark S is right - we run into this stuff all the time in our libraries and clinical schools/hospitals. Ask the physicians to ask their local IT support guys/gals to install/allow the app. If the IT types have any concerns then ask them to contact you directly - hopefully you'll be able to placat

Re: Standalone blocked by "software restriction policy"

2012-02-21 Thread Mark Wieder
Mark (yikes - this is getting a bit incestuous)- Tuesday, February 21, 2012, 4:07:36 PM, you wrote: > "Windows cannot open this program because it has been prevented by a > software restriction policy contact your administrator" As Mark pointed out, this is a typical IT reaction to users ins

Re: Standalone blocked by "software restriction policy"

2012-02-21 Thread Bob Sneidar
She needs to contact the IT department of her company and have it "unblocked". This is actually quite common in places where confidentiality is required. A rogue app can be installed by a user that compromises the security of the system. IT administrators will very often block unknown apps, or u

Anomoly when storing empty values into SQLite integer fields

2012-02-21 Thread Mark Smith
Hi, I've encountered a bit of an anomaly when storing empty values into integer fields in SQLite, and wonder if others have observed the same behavior. If I store an empty value from a LC field into an integer field in a database, and then subsequently read it back LC displays it as a 0. Where this

RE: Standalone blocked by "software restriction policy"

2012-02-21 Thread Mark Powell
Quadruply incestuous yikes...this post seems to attract the Marks all right. In addition to what the other Marks have said, I have recently encountered similar blocking here. However, it was not a Windows-triggered problem, but rather a quarantine that Symantec Endpoint Protection and Norton pr

RE: Standalone blocked by "software restriction policy"

2012-02-21 Thread AcidJazz
To All Marks (and others) Thanks for the quick, if somewhat discouraging, response!Can anyone (perhaps Mr. Powell) tell me what code-signing is? Mark (#1, in this case) -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Standalone-blocked-by-software-restric

Re: Anomoly when storing empty values into SQLite integer fields

2012-02-21 Thread Bob Sneidar
What is the field type? What is the default? If numeric and not null then it may be that the value defaults to 0 Bob Sneidar IT Manager Calvary Chapel CM Sent from iPhone On Feb 21, 2012, at 17:35, Mark Smith wrote: > Hi, I've encountered a bit of an anomaly when storing empty values into > in

Re: Anomoly when storing empty values into SQLite integer fields

2012-02-21 Thread Pete
Hi Mark, I tested this out after emailing you earlier today. It's definitely Livecode that is doing this and it's a serious problem for more reasons than you've found. Long story short, the only way I could find to make this work correctly is to not include the integer column in the UPDATE statem

Re: Anomoly when storing empty values into SQLite integer fields

2012-02-21 Thread Mark Smith
slylabs13 wrote > > What is the field type? What is the default? If numeric and not null then > it may be that the value defaults to 0 > Thanks Bob, field type is integer, no default is defined. Firefox plugin has a zero in the Not Null column,(which means?) and a zero in the Primary Key column

Re: Anomoly when storing empty values into SQLite integer fields

2012-02-21 Thread Mark Smith
Peter Haworth-2 wrote > > Long story short, the only way I could find to make this work correctly is > to not include the integer column in the UPDATE statement. Not sure if > your update was just a test with that one column or if there;d normally be > more columns to update, but you'd have to t

Re: RFC: Silly little Animate function...

2012-02-21 Thread kdjanz
Ken Any chance that you could post a demo stack of this little item in action? Thanks Kelly -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/RFC-Silly-little-Animate-function-tp4408356p4409112.html Sent from the Revolution - User mailing list archive at Nabble.co

Re: Anomoly when storing empty values into SQLite integer fields

2012-02-21 Thread Bob Sneidar
Right. So in a column defined as integer not null, there must then be a default value when you pass empty otherwise there would be an inconsistency. What I do ( and how I do it is too much to go into on an iPhone) is I preload all the values I intend to insert/update with default values, then ge

Re: Anomoly when storing empty values into SQLite integer fields

2012-02-21 Thread Pete
Bob, The field type is integer as Mark said. Since he doesn't have a default specified, the default value is NULL and that should not come back as zero and doesn't in any tool except LC - tried it with sqlite3 and the Firefox plugin. Nor should an empty value he's supplying (which is entirely dif

Re: Anomoly when storing empty values into SQLite integer fields

2012-02-21 Thread Bob Sneidar
Is it important to discern between null and a value? If so, uncheck the not null in the table definition and don't include the column in inserts/updates Bob Sneidar IT Manager Calvary Chapel CM Sent from iPhone On Feb 21, 2012, at 18:58, Mark Smith wrote: > > Peter Haworth-2 wrote >> >> Lon

Re: Anomoly when storing empty values into SQLite integer fields

2012-02-21 Thread Pete
Yes, it causes a headache, you're right. You would have to build the UPDATE command in a variable by examining each field for empty and adding it to the variable list if not empty. Don't have time to give some example code right now, but will try to do something tomorrow. Pete On Tue, Feb 21

Re: Anomoly when storing empty values into SQLite integer fields

2012-02-21 Thread Pete
I absolutely agree that default values should be defined in the database but it wouldn't help in this case since he wants the default to be either NULL or empty and LC has taken it upon itself to decide it knows better than the database and interpret that as zero. Pete On Tue, Feb 21, 2012 at 7:01

Re: Anomoly when storing empty values into SQLite integer fields

2012-02-21 Thread Mark Smith
Peter Haworth-2 wrote > > Yes, it causes a headache, you're right. You would have to build the > UPDATE command in a variable by examining each field for empty and adding > it to the variable list if not empty. Don't have time to give some > example > code right now, but will try to do somethi

Re: Anomoly when storing empty values into SQLite integer fields

2012-02-21 Thread Bob Sneidar
Ah ic. I think that in a situation where you are passing an empty string to a numerical field with no default, either SQL must throw an error, or else insert what amounts to nothing in a numeric column. I think the nature of sqLite is that Instead of tossing an error it puts 0 in the column. Y

Re: Anomoly when storing empty values into SQLite integer fields

2012-02-21 Thread Mark Smith
slylabs13 wrote > > Is it important to discern between null and a value? If so, uncheck the > not null in the table definition and don't include the column in > inserts/updates > Awkward but yes, that seems to be the solution. -- mark -- View this message in context: http://runtime-revoluti

Re: Standalone blocked by "software restriction policy"

2012-02-21 Thread Mark Wieder
AcidJazz- Tuesday, February 21, 2012, 6:01:26 PM, you wrote: > To All Marks (and others) > Thanks for the quick, if somewhat discouraging, response!Can anyone > (perhaps Mr. Powell) tell me what code-signing is? I'll take a stab at this, although you probably want to wait for Mark Powel

Re: Anomoly when storing empty values into SQLite integer fields

2012-02-21 Thread Mark Smith
Peter Haworth-2 wrote > > The only way round this that I've found as in my earlier email is to not > include the integer column in any INSERT or UPDATE statements if you want > it to come back as empty instead of zero. > Which sort of works, until you consider the case of wanting to back out a

RE: Standalone blocked by "software restriction policy"

2012-02-21 Thread Mark Powell
> Thanks for the quick, if somewhat discouraging, response!Can anyone > (perhaps Mr. Powell) tell me what code-signing is? Mark W. explained it much better that I could. Good luck and don't be discouraged. Anxiety is the dizziness of freedom...it is just that some times are dizzier tha

Re: Anomoly when storing empty values into SQLite integer fields

2012-02-21 Thread Pete
Hi Mark, I think this may not be difficult. Turns out you can use an array with numbered keys instead of a list of variables with revExecuteSQL, so here's some code ( completely untested) put 1 into x put "UPDATE test SET " into mySQL repeat for each item myField in "One,Two,Three" if field my

Re: RFC: Silly little Animate function...

2012-02-21 Thread Ken Corey
On 22/02/2012 02:59, kdjanz wrote: Any chance that you could post a demo stack of this little item in action? Hi Kelly, How silly of me, I should have done that already. http://its.ec/static/animate.livecode.zip (2.5Kb file) -Ken ___ use-livecod

Re: RFC: Silly little Animate function...

2012-02-21 Thread Malte Brill
CALL THE SPANISH INQUISITION! HE USED REGEX GET THE COMPFY CHAIR. Jokes aside... Well done! Cheers, Malte ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription pre

Re: Sounds in iOS

2012-02-21 Thread Graham Samuel
Ken I AM using your code, and very grateful I am for it; but that doesn't stop me being worried by RunRev apparently altering the engine to be slightly less cross-platform than one might hope, and then not being very clear about it. IMHO this is bad news for old dogs like me, and worse for peopl