Search found 404 matches

by AxWald
Tue Mar 31, 2020 2:19 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Check available connection with tsNet?
Replies: 29
Views: 925

Re: Check available connection with tsNet?

Hi,
bogs wrote:
Tue Mar 31, 2020 12:47 pm
[...] I think your definition of "easy" and mine are very much different [...]
Don't let my verbosity bedazzle you - basically it's:

Code: Select all

   if URL aKnownGoodURL is empty then youAreOffLine
Have fun! ;-)
by AxWald
Tue Mar 31, 2020 12:33 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Check available connection with tsNet?
Replies: 29
Views: 925

Re: Check available connection with tsNet?

Hi, This is more of a curiousity question than an answer to your post, but to check whether a connection is available or not, why would you use tsNet at all, instead of say, shell() ? it's even more easy: function INTest withTime -- put "myDomain.org/myip.php" into gName_IPURL (if you don't have it ...
by AxWald
Thu Mar 19, 2020 2:07 pm
Forum: Databases
Topic: converting an sql query into an array
Replies: 17
Views: 1117

Re: converting an sql query into an array

Hi, assuming you have the Array as I showed above (Mainkey = ID, Sub-Entries are named), and the selected IDs are in a comma-del list "mySelectedList ", and your itemdel is still "comma", try this: repeat for each key K in myArr if K is among the items of mySelectedList then put myArr[K]["pushNum"] ...
by AxWald
Wed Mar 18, 2020 7:19 pm
Forum: Databases
Topic: converting an sql query into an array
Replies: 17
Views: 1117

Re: converting an sql query into an array

Well, the OP asked for arrays ... In my work, I'm using table-like data all day long. And since I've finally understood arrays (took me quite some time ...) I use them quite often, too. But not exclusively! In my humble opinion, arrays are good when: You want data saved in a stack (or a file) that c...
by AxWald
Wed Mar 18, 2020 2:51 pm
Forum: Databases
Topic: converting an sql query into an array
Replies: 17
Views: 1117

Re: converting an sql query into an array

Hi, at first, when you fetch partial data from a DB it's usually just a matter of time until you want to retrieve some of the corresponding data. So you'll want to have always a unique designator for each record. If you haven't slept in DB school, you'll have a primary key for each of your tables, u...
by AxWald
Thu Mar 12, 2020 1:56 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Quitting LiveCode
Replies: 9
Views: 675

Re: Quitting LiveCode

Eeekk!

This is nasty.
Dunno if it helps, but on Win10 Waterfox 2020.02.1 (64-bit) doesn't change the way LC 6.7.10 comm. or LC 9.5.1 comm. are saving.
(at least not for what I do on a daily basis)

Have fun!
by AxWald
Thu Mar 05, 2020 4:22 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Concatenation issue
Replies: 11
Views: 824

Re: Concatenation issue

Hi, Not sure what you mean by a more limited db manager. Meaning was that: In the db managers I know you typically work on a single statement, and have comparable limited editing options. Using a good text editor and my approach above, you have much more power at your hands - selection-hiliting ever...
by AxWald
Wed Mar 04, 2020 4:39 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Concatenation issue
Replies: 11
Views: 824

Re: Concatenation issue

Hi, [...] Allows more flexibility for changing things without releasing a new client [...] Valid argument. But it can be overcome quite easily - two methods as example: Put your SQL strings into a simple text file that you replace/ download again at each start of your program. Like such: SimplSelect...
by AxWald
Tue Mar 03, 2020 6:50 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Best way to include stack1 in another stack
Replies: 12
Views: 920

Re: Best way to include stack1 in another stack

Hi, Still a good example how to do it: Sarah Reichelt's Calendar Basically, your calendar is a separate stack. You call it: go to stack Calendar as modal Now you're in the Calendar stack, and when you're done selecting, do there: set the dialogdata to "whatEverYouWantToReturn" close this window Back...
by AxWald
Tue Mar 03, 2020 4:05 pm
Forum: Converting to LiveCode
Topic: Moving a CRM project from FileMaker to LC?
Replies: 19
Views: 1105

Re: Moving a CRM project from FileMaker to LC?

Hi, just stepped through, this should it be: put URL "ftp://[...]/myStack.rev" into myFile ... put specialfolderpath("documents") & "/myStack.rev" into theTarget ... put myFile into URL ("binfile:" & theTarget) ... go stack (theTarget) in new window This is distributed over quite some handlers (and ...
by AxWald
Tue Mar 03, 2020 2:57 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Concatenation issue
Replies: 11
Views: 824

Re: Concatenation issue

Hi, Done plenty of “real database” work with stored procedures, triggers, views, etc., in both MySQL, SQL Server, Oracle as well as other experience in Access, Paradox, DBase 2, DBase 4. :D Plz don't get me wrong - this was in no way meant as doubting your qualification! Maybe I just mistook your me...
by AxWald
Tue Mar 03, 2020 1:08 pm
Forum: Converting to LiveCode
Topic: Moving a CRM project from FileMaker to LC?
Replies: 19
Views: 1105

Re: Moving a CRM project from FileMaker to LC?

Hi, Personally, I use the launcher method.... but with a local file. It's only when there is an update available [...], that the launcher will fetch the updated stack (from a FTP server [...]) and then write it into the directory, on the user's PC. That's what I do, too. I fetch the stack files ("mo...
by AxWald
Tue Mar 03, 2020 12:28 pm
Forum: Feature Proposals
Topic: Permanent ID function (same as FileMaker Pro)
Replies: 56
Views: 4557

Re: Permanent ID function (same as FileMaker Pro)

Hi, if it is sooooooo easy to get, why is it soooooooo hard to just include it in the language? Lemme guess: It's not in the language 'cause every OS provides a way to obtain this information quite easily (or not at all). But these ways are different, 'cause every OS cooks it's own soup. Each provid...
by AxWald
Sat Feb 29, 2020 9:56 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Concatenation issue
Replies: 11
Views: 824

Re: Concatenation issue

Hi JackieBlue, The parentheses might be forcing some strange evaluation of the field name [...] This ( field("fieldUPC") ) definitively looks fishy, but in a short test gives the correct result. I'd rather not do it, you'll never know. But it's quite easy to mess up the concatenation, especially wit...
by AxWald
Thu Feb 27, 2020 3:32 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: How to deal with database files for an app?
Replies: 32
Views: 1855

Re: How to deal with database files for an app?

Hi, Would you use Windows Scheduler to automate it, or is it something you write a script for? I'm trying to use as much "standard procedures" of the OS as possible. They usually cause the least problems, on Win anyways :) Yes, for running automated tasks I use the scheduler ("taskschd.msc"). It wor...

Go to advanced search