Re: 7.1.3 installer failure

Hi Robert, I got the same message and have reported it to support@runrev Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/7-1-3-installer-failure-tp4702798p4703043.html Sent from the Revolution - User mailing list archive at Nabble.com.

Re: 7.1.3 installer failure

Robert, advice was to download it directly from http://downloads.livecode.com/ It worked on my second try. Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/7-1-3-installer-failure-tp4702798p4703104.html Sent from the Revolution - User mailing list archive a

Re: Volunteer github guru for documentation submissions?

Does anyone have a documentation bug they would like to see fixed? I'd like to give Ali's guide a try but don't have any documentation bugs top of mind. Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Volunteer-github-guru-for-documentation-submissions-tp47

Re: Volunteer github guru for documentation submissions?

Thanks Jackie. That one is now submitted. Have any others (send me your list if you'd like)? Once I've done this a few times I'd like to abbreviate the instructions (but I need to understand the process a bit better). -- View this message in context: http://runtime-revolution.278305.n4.nabble.

Re: Volunteer github guru for documentation submissions?

J. Landman Gay wrote > Like Devin said, almost everything I look at needs at least a minor > tweak. I was just reading the encrypt entry. It's missing examples, but > I don't know enough about encryption to add meaningful ones. If you do, > that'd be great. > > Another thing to do would be to g

Re: Volunteer github guru for documentation submissions?

J. Landman Gay wrote >textShift is not tagged as "text processing" BTW, are tags something new in the LC 8 dictionary? I can't see any in the LC 7 version (or don't know how to make them appear). Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Voluntee

Re: Volunteer github guru for documentation submissions?

Thanks... I will take a look. I am grappling with another problem at the moment (and I need to download and install 8 so I can see what all the comments are about :) But Peter had me editing an entry for "sessionSavePath (property)" and then Ali said I should change it to " property" so it would l

Re: Anyone have any LiveCode hooks to WordPress? And, are you following these Word Camp events

Great job. Thank you for being so generous Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Anyone-have-any-LiveCode-hooks-to-WordPress-And-are-you-following-these-Word-Camp-events-tp4703439p4703572.html Sent from the Revolution - User mailing list archive

Re: Volunteer github guru for documentation submissions?

Thanks Ali. I think I am making progress. I changed the reference to " property" but from your text it looks like maybe " (property)" is the correct format? Is there somewhere where these formats are documented? Cheers!! Mark -- View this message in context: http://runtime-revolution.278305.n4

Re: Volunteer github guru for documentation submissions?

Peter TB Brett wrote > Go to the Dictionary stack, to the Guides tab, and you'll find the > documentation format reference in the drop down. Thanks Peter. I think the drop-down menu might need a scroll option. When I first looked at it I could not see the Documentation Format Guide (it's near the

Re: Volunteer github guru for documentation submissions?

Mark Smith wrote > " > > (property)" is the correct format? After looking at the documentation guide now I think it should be . I'll go make the change... Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Volunteer-githu

Re: Volunteer github guru for documentation submissions?

J. Landman Gay wrote > Like Devin said, almost everything I look at needs at least a minor > tweak. I was just reading the encrypt entry. It's missing examples, but > I don't know enough about encryption to add meaningful ones. If you do, > that'd be great. Thanks Jackie, sorry it took so long

Re: Volunteer github guru for documentation submissions?

Kay C Lan wrote >> That would be incorrect. The only time you need to use > (referenceType)> > format is if the link is ambiguous. 'sessionSavePath' is > only a property so it can never be ambiguous so it appears in the > Description: as > > and then in the References: as > sessionSavePath (p

Re: Volunteer github guru for documentation submissions?

Devin Asay wrote > Mark, I think you’re right on track with this “fleshed-out” example. In > the document on Contributing to LiveCode Documentation > ;. > They emphasize Completeness, Correctness, and Instructive

Re: [OT] Atkinson Interview, Pt 2

Very cool interview. Thanks for posting a link Richard. Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/OT-Atkinson-Interview-Pt-2-tp4704013p4704022.html Sent from the Revolution - User mailing list archive at Nabble.com. __

Re: Volunteer github guru for documentation submissions?

J. Landman Gay wrote > It's a markdown issue I was thinking Mark Smith might want to tackle, > since it's part of the community docs we're trying to edit. If he > doesn't, then I'll try it. It's next on my list to look at (I think I've finally got &qu

Re: Webinar

Richard Gaskin wrote > I'm surprised and impressed that you took the time to transcribe the Q&A > portion. Well done! Very nice to be able to read all those answers. Indeed, I'll second that. -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Webinar-tp4704476p

Widgets v2

This new initiative from LiveCode is, I believe, a perfect follow on to 8. Exactly what we need to allow the community to grow and develop the ability to exploit the incredible power and potential of widgets. The training alone is worth several hundred dollars... so I hope everyone will consider su

Re: Widgets v2

Sannyasin Brahmanathaswami wrote > I just pledged… ignore my "downer" on the other thread. > > BR Way to go Sannyasin!! We still have a ways to go so please help spread the word. And many, many thanks. M -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Widget

A Personal Challenge

Apologies for cross posting... In the last couple of days, 173 backers (excluding Livecode) have contributed $22,833 towards the Infinite Livecode campaign (or about $130 dollars each). So first a huge THANK YOU to everyone who has contributed because I know times are tough. But I also know this i

Re: A Personal Challenge

Mike Bonner wrote > I feel like i'm in that movie.. "Help me, help you..." Pledge increased. Brilliant! Thanks Now, any suggestions on how to reach the "community" base to encourage them to contribute? Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/A-P

Re: A Personal Challenge

Peter Bogdanoff wrote > After Todd’s offer I went ahead and multiplied my pledge by 10. > > Peter NICE. And thanks! I wish I could say we are almost there but it looks like we still have a long way to go. Any suggestions? -- View this message in context: http://runtime-revolution.278305.n4

Re: Suspense

Heather Laine-2 wrote > Guys, I'm sitting here hitting refresh compulsively on the pledge page. > Are we there yet... We are so close to 40k. Who is going to push us over? Hahaha I know the feeling. But more seriously, you need $1,000 an hour for the next 19 hours to make the final goal. May the

Re: Suspense

A big congratulations to all of us. It was hard fought, and we did not go over the top but we still made huge gains. I am most definitely looking forward to all the new goodies, not least of which are the documented and "worked" examples we can all learn from. Very grateful for all who contributed

Re: [OT-ish] WWDC things of interest

Colin Holgate-3 wrote > The most interesting thing that was shown overlaps somewhat with what > LiveCode is good for. Apple have a new app coming, called Swift > Playgrounds. It’s free, and it’s meant for people learning programming. > Here’s the info page on it: > > http://www.apple.com/swift/pla

Re: [ANN] homemade slider

Excellent! Nice job Bernd. Thanks for doing this. Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/ANN-homemade-slider-tp4686566p4686747.html Sent from the Revolution - User mailing list archive at Nabble.com. __

Re: Livecode on Raspberry Pi 2

What OS are you running it with? -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Livecode-on-Raspberry-Pi-2-tp4694398p4694552.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-livecode ma

Re: OT: Announce -- Himalayan Academy's First LiveCode Mobile App is Up

Looking forward to viewing this once it comes out in the appStore. Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/OT-Announce-Himalayan-Academy-s-First-LiveCode-Mobile-App-is-Up-tp4698518p4698693.html Sent from the Revolution - User mailing list archive at

Re: 'Quit' mystery

I am just coming back to LC after a few months off (18 perhaps?) so I am a bit rusty but is it not the case that the message path goes from substacks to the main stack? If so, should not a "shutdownRequest" message not handled in a sub stack be passed up the message path to the main stack? In which

Re: Book on Programming by Example

Alejandro Tejada wrote > Hi All, > > Bookmark this webpage: > http://web.media.mit.edu/~lieber/Your-Wish/ > > to read this mind opening book: I dunno about that Alejandro, I think I still prefer main() { printf("hello world"); } or, if using LC on mouseUp put "hello world" after

SQL Join question

I have two tables A and B, both with the same structure (about 50 columns each). I would like to combine them into a single table (ie. rows from Table A followed by rows from Table B). Does anyone know of an SQL statement that will do that? Thanks -- View this message in context: http://runti

Re: SQL Join question

John Craig-4 wrote > I really should have started with '0, field2' in the example below - > assuming field 1 is the primary key.. >> If you have an auto incrementing primary key 'id' as the first field >> in both tables... >> INSERT INTO tableA SELECT 0, field1, field2, field3, etc... FROM table

Re: SQL Join question

Peter Haworth wrote > SELECT tableA.*,tableB.* FROM tableA JOIN tableB ON > tableB.keycolumn=tableA.keycolumn Hi Peter. So, do I understand correctly that if table A has fields first, last and table B has fields age, sex and they both have an id column (key column) then this code would produce a f

Re: SQL Join question

Hi Peter, thanks for that. I definitely prefer your option 1. Would it still be possible to have an auto incrementing field that combines with the device id to make the primary key (ie. could recno in your example be auto incrementing)? Also, I wonder if there is a device ID that could be grabbed f

Re: SQL Join question

Perfect, thank you. Peter Haworth wrote > but if there are three tables, the SELECT becomes: > > SELECT tableA.*, tableB.*, tableC.* FROM tableA JOIN tableB ON > tableB. > > =tableA. > > JOIN tableC ON > tableC. > > =tableA. > > But the keycolumn must have the same value for all three table

Re: SQL Join question

Thanks Peter. Good discussion. I'll check on the developer list to see if anyone knows if there is an iPad device ID I can grab. Perhaps another widget for Monte to work on :) -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/SQL-Join-question-tp4680574p4680600.htm

Calculating age

Hi, does anyone know how to calculate someones age in years from two dates? Currently I am doing something kludgy like: convert dateone from date to seconds convert datetwo from date to seconds put datetwo - dateone into age -- calculate the age in seconds -- divide by the number of seconds per y

Re: Calculating age

Many thanks to Mike and Hlowe, I suspect the algorithms you suggested are doing very similar things and are an improvement over my approximation. Mike, I don't think you can calculate the seconds of a date prior to 1/1/1970 since the seconds are calculated as 'from that point'. An astute observatio

Re: Calculating age

Sorry that was rude of me… I meant to thank everyone but particularly Mike and Hlowe for the algorithms they suggested, but I appreciated all of your comments. Cheers, Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Calculating-age-tp4680687p4680713.html S

Re: Code Signing Error

Nakia Brewer wrote > On 6.6.2 I get no errors Nakia, I am about to upgrade. What is your setup (OS, iOS, SDK, Xcode, am I forgetting anything?) Thanks -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Code-Signing-Error-tp4680698p4680714.html Sent from the Revo

Re: [ANN] HTML 5 Campaign Monitor

Your eye for detail is amazing. Heather will be pleased -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/ANN-HTML-5-Campaign-Monitor-tp4680812p4680820.html Sent from the Revolution - User mailing list archive at Nabble.com. __

Re: OS X Mavericks

Mike, thanks for mentioning that. I am about to upgrade to Mavericks myself and will make sure I check that LC is pointing to the right Xcode. What about the SDK? Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/OS-X-Mavericks-tp4671455p4683735.html Sent fro

Xcode, which one?

Hi there, Was running LC 5.5.5 on iOS 10.7.5 (Lion), Xcode 4.5.1, SDK 6.1 and iOS 6 on the phone and tablet - everything worked well. Wasn't able to run the latest MobGUI so thought, h, maybe I should upgrade (this IS always an adventure, isn't it ) First, upgraded the mobiles to iOS 7. Next

Re: Xcode, which one?

Ok thanks, reassuring to know what's been working. Just wanted to make sure I wasn't missing anything (the possible combinations and permutations are pretty huge). Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Xcode-which-one-tp4683786p4683795.html Sent f

Documentation

I've just upgraded from 5.5.5 to 6.6.3. Surely there have been a few changes between then and now? But reading the Release Notes provides no hint. Is there one document I can read that tracks all of the additions, updates and changes from 5.5.5 to 6.6.3? Here's hoping! Mark -- View this messag

Re: Documentation

Richard Gaskin wrote > There's no single document outlining the changes between that specific > range of versions, but the release notes for each version will bring you > up to speed: > > ; Thanks for the link Richard. Very useful -- View this message

Re: Documentation

skiplondon wrote > Just a thought: One of pieces of software that we use in our office > environment, we can go online and put in the version of the software you > are using and the version that you have upgraded to and it will compile a > complete feature / bug fix document for you on the fly bas

Re: Documentation

One more thing I forgot to ask. Now that I've upgraded from 5.5.5 to 6.3.3 is there any stack format issues that I need to be aware of? All compatible? Thanks Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Documentation-tp4683797p4683859.html Sent from th

Stack format concerns

Now that I have upgraded from 5.5.5 to 6.3.3 are there any stack format issues I need to be aware of? All compatible? I've been thinking Since I have 51 release notes to read between these 2 versions what this calls for is some sort of release note reader/stack that helps organize everything.

Re: Stack format concerns

Thanks Jacque. On the release notes - I could just open and read all 51, or maybe the "stable" release notes summarize all the rc's and dp's (have asked) - I am going to try acrobat 11 to see how well it "saves as" a word document, and try converting to rtf from there. It would be nice to preserve

RTF or TXT

Possibly very dumb question here. What I want to do: using code 'cut and paste' (i.e. parse) text from an RTF document into a LC field, preserving the text formatting. What I don't want to do: deal with all of the RTF formatting codes. Is this doable? If its not easily doable I can downgrade the

RE: Live LiveCode event #16 (Wrapup)

Hi Jim, great video. Are there more of these sessions archived online? Thanks -- Mark From: use-livecode-boun...@lists.runrev.com [use-livecode-boun...@lists.runrev.com] On Behalf Of Jim Ault [jimaultw...@yahoo.com] Sent: Tuesday, March 29, 2011 6:56 P

RE: LC Summer Academy

The Summer Academy was incredibly useful (and hats off to Elanor for being such a great presenter). A ton of information was presented in the 7 weeks, so much so that I had trouble keeping track of it all and definitely wanted a way to be able to go back and review it later. So I created the S

Getting Android going

As anyone gotten to the point of installing the Android SDK on the Mac, testing it to make sure you have a functional simulator, all using the Android SDK and AVD manager and then, when asked by LC to specify in preferences where the root of your Android SDK is not have a clue? I'm there... I don't

RE: Getting Android going

Thanks Jacqueline... I think I'll repeat the process and do what you did: drop it into the /developer folder and try again. I'll let you know if it works. -- Mark Mark Smith Associate Director, Repository Manitoba Centre for Health Policy University of Manitoba 727 McDermot Av

Re: Getting Android going

J. Landman Gay wrote: > > On 8/2/11 10:15 PM, Mark Smith wrote: > > I didn't know what I was doing when I set up, so I just followed those > instructions and used the Android 2.2 API 8 package to set up my virtual > machine. Do you have a VM configured? > Hi

RE: Drag and Drop Between Stacks?

Why not put it in the User Samples in revOnline? It's available from the IDE menu bar - Mark From: use-livecode-boun...@lists.runrev.com [use-livecode-boun...@lists.runrev.com] On Behalf Of Pete [p...@mollysrevenge.com] Sent: Friday, October 14, 2011 9

Re: I Killed The Site

Mike Kerner wrote: > > I just want to apologize for killing runrev.com. I was just trying to buy > something in the store when kaboom, the whole site went #epicfail. So > since it must be MY fault, sorries! > Too funny!! -- View this message in context: http://runtime-revolution.278305.n4.n

auto-rotation in 5.0.1/.02

Hi I just upgraded to 5.0.1 (and then .2 thinking that might solve the following problem but it didn't). Gone from the standalone settings pane are the options to set the "supported orientations" and in there place are new options to set the initial orientation for iPad. A program that previously r

Re: auto-rotation in 5.0.1/.02

Further to this I just wanted to add the following: "To configure which orientations your application supports use: iphoneSetAllowedOrientations orientations Here orientations must be a comma-delimited list consisting of at least one of portrait, portrait upside down, landscape left and landscape

Re: auto-rotation in 5.0.1/.02

Randy Hengst wrote > > Looking at your script, you added spaces after the commas…. in your > comma-delimited list…. you can't do > Randy, thanks. I knew there was something I was probably doing wrong. -- Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/

Re: auto-rotation in 5.0.1/.02

Yes sir, that fixed it. Thanks. -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/auto-rotation-in-5-0-1-02-tp4111266p4112014.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-livecode maili

startup handler

Hi, just wondering if there is something special about the startup handler. The following code (executed in the IDE) does nothing: on startup if the cpassword of this stack is empty then ask password "Please enter a new password:" put it into temp1 ask password "Please re-ente

Re: startup handler

J. Landman Gay wrote > > Startup is sent only once when the engine is first launched. In the IDE, > that happens long before any user stacks open (I think the IDE Home > stack catches it.) Startup will never occur in a stack open in the IDE, > only in a standalone. > Thanks Jacque, I more or

Re: startup handler

J. Landman Gay wrote > > On 11/28/11 10:15 PM, Mark Smith wrote: > >> Now, before I begin, both the stack in the IDE and tested on the iPhone >> simulator report the encrypted pw as \VUw|1,A so, no difference there. > > I get a difference. > Thank you (once

window decorations?

Not sure if that is the right term, but I think so. Does anyone know how to enable, disable the window "resize" decoration in the lower right corner of the window? Thanks -- Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/window-decorations-tp4121455p412145

Re: Have you made an iOS or Android app with LiveCode and published it in an app store?

Hi Ben, you might want to post this on the runrev livecode forums in the iOS section. Or, I could post it there for you. -- Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Have-you-made-an-iOS-or-Android-app-with-LiveCode-and-published-it-in-an-app-store-tp

Re: window decorations?

Super, thanks for all the comments and suggestions here. I'll give them all a try. -- Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/window-decorations-tp4121455p4125874.html Sent from the Revolution - User mailing list archive at Nabble.com. _

Re: Have you made an iOS or Android app with LiveCode and published it in an app store?

Ben Rubinstein wrote > > If you would post it in the iOS (and Android, if there is one) forum that > would be really kind. And anywhere else that you think would be useful. > Hi Ben, your message has been cross-posted. -- Mark -- View this message in context: http://runtime-revolution.27830

Re: Datagrid - GetDataForLine

Marty Knapp wrote > > In my scenario, how do I use the "GetDataForLine" command? > > Am I wasting time by converting my tab-delimited file to an array? > Hi Marty, I am no datagrid expert (more or less just stumble onto solutions that work for me) and I am not familiar with the technique you a

Re: Datagrid - GetDataForLine

Marty Knapp wrote > > In my scenario, how do I use the "GetDataForLine" command? > > Am I wasting time by converting my tab-delimited file to an array? > Hi Marty, I am no datagrid expert (more or less just stumble onto solutions that work for me) and I am not familiar with the technique you a

Re: Datagrid - GetDataForLine

slylabs13 wrote > > Prior to this we were discussing how unwieldy this can be with a lot of > data. If he has a ton of data, like in the hundreds of thousands or even > millions of records, this can take an extraordinary amount of time, hence, > the need to bite off a little at a time. > > Bob

matchChunk question

Hi, shouldn't the following place the start position and end position of the regular expression found in the input field into the output field? on mouseUp local startpos, endpos put fld"input" into tinput put "\" & quote & "v" & "\" & quote & ":" into tregularexpression put matchchun

Re: matchChunk question

Thanks, worked perfectly. changing the expression to "(\" & quote & "v" & "\" & quote & ":)" resulted in true, 422, 425 in the output. What I am attempting to do is define a rather complicated item delimiter, in this case made up of the 4 char sequence "v": If I can define where this occurs I can

Re: matchChunk question

Peter M. Brigham, MD wrote > > Any reason not to just use > > put numtochar(8) into tempDelim > replace <4-char-sequence> with tempDelim in tString > set the itemdelimiter to tempDelim > > Thanks Peter, none that I can see although I would probably write: put quote & "v" & quote & ":" into t

database write error

Hi, I have some code that works fine until I put an apostrophe into a field and then it errors out on storing the data. Any suggestions on dealing with this problem? The code I am using looks like this: put "INSERT INTO master (delivery_date, mothers_name, mothers_phin, mothers_mhsc, mothers_dob,

Re: OT: Walking

Mike, thanks for sharing... a very inspiring journey that makes many of our day-to-day irritations and struggles in living pale in comparison. I wish you MUCH SUCCESS!! -- Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/OT-Walking-tp4343357p4345637.html Sent

Re: database write error

Thank you all... you have left me with a number of great suggestions to look into. It does seem like using "variable lists" as in the substitution approach would be the more/most generic solution to this problem... since I'm on a deadline I'll probably do a quick and dirty escape on apostrophe (tha

Re: database write error

Peter Haworth-2 wrote > > If you use single quotes, double quotes don't need to be escaped in the > literal, and vice versa. So, if you're sure that your data won't contain > double quotes, then you can use double quotes to enclose the literals and > single quotes won't cause a problem. > >

Re: database write error

Peter Haworth-2 wrote > > so I just have to: > > put buildValuesClause(globaldate,tmaternalname,tmaternalphin,) after > tSQL > > I put that together before I knew revexecuteSQL substitution deals with > all that and more but it kinda works for me. > Smart. Sounds like the direction I will be

Re: [ANN] sQuiRt V1.1.0 update

John Craig-4 wrote > > The sQuiRt library for generating QR codes can now be used with LiveCode > server. > You can view an online demo at; > Now that is cool! -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/ANN-sQuiRt-V1-1-0-update-tp4359702p4360384.html Sent

Re: How alive is LiveCode?

Hi Michael, I can only add to this by saying I am doing very similar work with livecode, and so far have run into few problems with it, and most of those are fixed by enhancing my learning curve. I do feel like Livecode has provided only the basic tools and I am required to construct libraries to s

Re: Drag and Drop in a locked field

slylabs13 wrote > > Any easy way to implement this? I could use a datagrid I suppose (grumble > grumble) but it would be nice if I could just do this with a simple list > field. I want to reorder entire lines by dragging and dropping them. > Hi Bob, I wrote something to do that awhile back and

Re: Drag and Drop in a locked field

Sorry, its been awhile since I worked on it and so I should clarify: the 7766 bug only rears its head after using the pop-up menu. If you disable the pop-up menu option the drag drop works fine on x86. -- Mark -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Drag-a

Re: Architecture of downloadable content for iOS?

Ken Corey wrote > > Do I grasp the general idea here or can modules indeed be downloaded > from the app store, and called from my main stack? > I've downloaded apps that handle tons of multi-media, pictures, video recordings. They seem to dload the content from a server. Check the Winnipeg Fol

Re: Architecture of downloadable content for iOS?

Ken Corey wrote > > My question is meant more as a producer of one of those apps in a > LiveCode environment. > > I'd rather learn from someone else's wisdom, but if I can't I'll do it > on my own. > > -Ken > Ok, then in response to your previous question "Once the new version is running, t

Re: RevOnline upload (bis)

Did not work for me either earlier this week. Did not try today though. You might try sending a msg to support as they may not be aware of the problem. -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/RevOnline-upload-bis-tp4387783p4393018.html Sent from the Revolut

Anomoly when storing empty values into SQLite integer fields

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: Anomoly when storing empty values into SQLite integer fields

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

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: Anomoly when storing empty values into SQLite integer fields

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

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: Anomoly when storing empty values into SQLite integer fields

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: Anomoly when storing empty values into SQLite integer fields

Peter, very cool. I'm going to have fun with that one. LC is very powerful at times. Oh, and thanks for posting to the bug list. While it is possible that RR will say this behavior conforms to a particular standard and you just have to code for it (as you have below) its still way, way to much work

Looping over all buttons

Hi, I have 38 buttons on a form that I need to copy their hilite value to a temporary variable. Is it possible in LC to do something like for x = 1 to the number of buttons on card y put the hilite of btn"x" into tButtonx end instead of writing out manually, 38 times: put the hilite of btn

Re: Anomoly when storing empty values into SQLite integer fields

Robert Brenstein wrote > > > Have you tested that you get the same behavior with not-null setting > for that integer field on and off? You should get different results. > HI Robert, while I was hoping it would unfortunately no, it didn't make a difference. -- Mark -- View this message in co

Re: Anomoly when storing empty values into SQLite integer fields

slylabs13 wrote > > It may be a small distinction, but NULL is ASCII 0. An empty string is > nothing at all, so far as I know. To a human this is splitting hairs, but > to a computer all hairs must be split. > > The scenario seems to be (1) if you create a new empty record all the undefined v

Re: Anomoly when storing empty values into SQLite integer fields

slylabs13 wrote > > It seems that if you use an empty string "" on a numeric column, SQL > interprets that as zero 0. > Hi Bob, that basically is the problem right there. slylabs13 wrote > > It begs the question however, why in the world you would pass a string > value to a numeric column?

Re: Looping over all buttons

Ken Ray wrote > > > repeat with x = 1 to 12 > put "Hello" into field ("MyField" & x) > end repeat > > What if you want to put fld fieldname into myvar as in the original that Bob suggested: "put fld myfield into tvar" & x Myfield holds the name of a field that is being copied to a temp var

Re: Anomoly when storing empty values into SQLite integer fields

Peter Haworth-2 wrote > > put 1 into x > put "UPDATE test SET " into mySQL > repeat for each item myField in "One,Two,Three" >if field myField is not empty then > put myField & "=:" & x & comma after mySQL > put field myField into myArray[x] > add 1 to x >end if > end re

  1   2   3   4   5   >