Search found 180 matches

by MichaelBluejay
Tue May 26, 2020 8:55 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Oauth2
Replies: 2
Views: 168

Re: Oauth2

I'm very sorry to ask this, but you did replace "KEY HERE" with the actual key, right?

Also, some of your fields are empty, are you sure you don't have to pass all the fields in your call?
by MichaelBluejay
Tue Mar 17, 2020 7:37 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Copy & paste Data Grid data?!
Replies: 7
Views: 582

Copy & paste Data Grid data?!

Since I'm no fan of the Data Grid, I wasn't surprised when I selected some rows and found that the "Copy" command is grayed out, making it impossible for a user to copy data out of the Data Grid and paste into, say, a spreadsheet. Am I missing something, or is the Data Grid truly this crippled? If t...
by MichaelBluejay
Tue Mar 17, 2020 6:56 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Easy way to add commas to a number
Replies: 6
Views: 479

Easy way to add commas to a number

All the algos I could find for adding commas to numbers were either long, or complicated, or both. I hate long and/or complicated code. So here's a short and simple way to add commas to a number. put 1234567.89 into val put floor(val) into floored // Get the number w/o the decimals put val - floored...
by MichaelBluejay
Tue Feb 25, 2020 10:04 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: How to deal with database files for an app?
Replies: 32
Views: 2614

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

Another idea: The export options for the last app I used were pretty weak. I'll have my app have pretty robust exporting options. For a given date range (including any whole year): * CSV * Human-readable * SQLite, openable by my app as an independent document. So, users can save a known-good year if...
by MichaelBluejay
Mon Feb 24, 2020 5:30 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: How to deal with database files for an app?
Replies: 32
Views: 2614

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

The file was never synced anywhere. Incidentally, I do know that it was physical file corruption (rather than a logic error, where the program recorded data wrong and then didn't know how to deal with it), because when I opened the file in an SQLite browser, I remember getting some weird symptoms, I...
by MichaelBluejay
Mon Feb 24, 2020 1:58 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: How to deal with database files for an app?
Replies: 32
Views: 2614

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

Thank you, LCMark. Despite everyone's assurances that data corruption is rare to impossible, and that backups solve everything, I did actually suffer data corruption, and my backups were not helpful for reasons I've already stated. (Yes, the failure might have been the physical disk rather than the ...
by MichaelBluejay
Sun Feb 23, 2020 7:45 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: How to deal with database files for an app?
Replies: 32
Views: 2614

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

Okay, I'm almost talked into keeping all the data in one file, and doing integrity checks, auto backups, along with golden backups, but rather than asking what programmers would do, I realize I should ask what users would prefer. After all, they're the potential customers. So I'm gonna ask around on...
by MichaelBluejay
Sun Feb 23, 2020 7:17 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: How to deal with database files for an app?
Replies: 32
Views: 2614

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

I'm pretty sure the original app wasn't written in LC. Unless the file is prohibitively large, with storage < $50/TB one could automate snapshotting and have confidence that you can go back and retrieve what you need when you need it. I'm not sure that having literally thousands of backup files (365...
by MichaelBluejay
Sun Feb 23, 2020 12:47 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: How to deal with database files for an app?
Replies: 32
Views: 2614

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

I have no idea what caused the data corruption while using someone else's app, and frankly, nor do I care. We all know that data corruption can be caused by forces beyond our control, such as power outages during saves, and disk failures. There is no way I can prevent a disk failure and I'm not goin...
by MichaelBluejay
Sun Feb 23, 2020 10:23 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: How to deal with database files for an app?
Replies: 32
Views: 2614

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

That's an interesting idea, but I don't know enough about disk storage to attempt repairs, but even an expert can't fix a problem where data on a disk is missing or contains different values from the originally-saved values. I have to assume that those things can happen to my data files, and segrega...
by MichaelBluejay
Sun Feb 23, 2020 9:36 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: How to deal with database files for an app?
Replies: 32
Views: 2614

How to deal with database files for an app?

As some of you know, I've been intermittently working on developing a bookkeeping app. Now I'm stuck on how I should deal with the (SQLite) data files. The last app I used steered users to keep all years' data in the same data file. That's dangerous, as I realized when I started using the app in 201...
by MichaelBluejay
Sat Feb 08, 2020 3:32 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Datagrid: changing cell style
Replies: 25
Views: 3035

Re: Datagrid: changing cell style

guylouis, please don't hijack existing threads for new topics. Please start a new thread for your new question.
by MichaelBluejay
Fri Dec 20, 2019 6:30 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: LC loses I/O ability about once a day
Replies: 21
Views: 2382

Re: LC loses I/O ability about once a day

I'm using Community. I'll buy an Indy license if I ever get my project ready to market. I wouldn't think that the license type would matter, though. My personal stack of notes with an SQLite database saved on my iCloud Drive has functioned for a year with no problems. And no new news to report, sinc...
by MichaelBluejay
Tue Nov 26, 2019 5:40 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Datagrid: changing cell style
Replies: 25
Views: 3035

Re: Datagrid: changing cell style

Zax, here's a script that kind of does what you ask, but there are lots of caveats. This script goes in the COLUMN BEHAVIOR for the column that has the checkbox. You'd think that you'd be attaching the script to the checkbox, because that's logical. You'd be wrong. on mouseup put the dgHilitedLines ...

Go to advanced search