Search found 28 matches

by SkinnyKenny
Fri Nov 13, 2020 9:08 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Program Deployment
Replies: 9
Views: 4355

Re: Program Deployment

I have been playing around with some lessons tonight regarding SFPT commands and have the "upload" figured out. I can't seem to figure out how to download a file from the FTP server thus far. The lessons don't cover in full what I am trying to accomplish so if you have any sample scripts to point me...
by SkinnyKenny
Fri Nov 13, 2020 9:02 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Program Deployment
Replies: 9
Views: 4355

Re: Program Deployment

Yes. Actually it is only being used once if not maybe two times a shift.
by SkinnyKenny
Fri Nov 13, 2020 4:10 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Program Deployment
Replies: 9
Views: 4355

Re: Program Deployment

Hi Richard. So to give a little background of how the program works. I manage an EMS service with 3 other management level employees that would be using this program. Overall, the program tracks and logs narcotics used by the paramedics. We are tracking expiration dates and usages of said narcotics....
by SkinnyKenny
Thu Nov 12, 2020 1:34 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Program Deployment
Replies: 9
Views: 4355

Re: Program Deployment

Hi Paul, Thank you for your response. Overall, my program uses sqlLite to manage the databases and works nicely. I would need the database files and stack files to reside remotely and called when the user opens the program to update the datagrids. My standalone has a "splash.exe" and the main applic...
by SkinnyKenny
Thu Nov 12, 2020 4:23 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Program Deployment
Replies: 9
Views: 4355

Program Deployment

Hello all, So I have finished a small Windows program to use at work. My question is, what are my options for deploying it so that multiple users have access to it. The standalone essentially needs to be saved remotely and called from a server (I assume) so that any changes will sync when another us...
by SkinnyKenny
Fri Feb 21, 2020 1:28 pm
Forum: Windows
Topic: Save main stack SQLite
Replies: 7
Views: 5238

Re: Save main stack SQLite

That's EXACTLY what I was looking for! Phew! Thank you very much!

And yes, the users would be accessing the program one after another....I was thinking that I could maybe save the stack (.livecode) in the shared user folder but I wasn't sure if that was how it worked. I am going to try it now!
by SkinnyKenny
Fri Feb 21, 2020 1:13 pm
Forum: Windows
Topic: Save main stack SQLite
Replies: 7
Views: 5238

Re: Save main stack SQLite

Well, I would like for anyone who uses the program on a single PC to be able to have the most current updated stacks ie (fields, buttons etc). So, this is a work program that multiple users will be using. Each person has a profile set up on this PC. When user 1 opens the program and makes changes, i...
by SkinnyKenny
Fri Feb 21, 2020 12:12 pm
Forum: Windows
Topic: Save main stack SQLite
Replies: 7
Views: 5238

Re: Save main stack SQLite

Thank you for your response. I guess what I am getting at is this... I am having a hard time understanding how the .exe is shared on a PC when there are multiple user profiles on a single PC. So lets say I make a simple program that is installed on my PC under my profile. The PC has 3 other user pro...
by SkinnyKenny
Fri Feb 21, 2020 10:38 am
Forum: Windows
Topic: Save main stack SQLite
Replies: 7
Views: 5238

Save main stack SQLite

Hello all...I was wondering if it was possible to save the current state of a main stack into a "Blob" container using SQLite. What I am trying to accomplish is keeping the data up to date in my main stack when multiple users across multiple user profiles on Windows are accessing the program. I assu...
by SkinnyKenny
Thu Feb 13, 2020 11:09 am
Forum: Windows
Topic: Invalid Connection ID SQLite
Replies: 18
Views: 11180

Re: Invalid Connection ID SQLite

Great tip! I just assumed you had to include the entire if/else format....I am just used to writing it that way or I just use a switch. Old habits die hard! Thanks for all your help everyone and especially you Klaus!
by SkinnyKenny
Thu Feb 13, 2020 7:43 am
Forum: Windows
Topic: Invalid Connection ID SQLite
Replies: 18
Views: 11180

Re: Invalid Connection ID SQLite

I think I figured out what the issue is. I was adding a "," after revExecuteSQL and there should not be one. GEEEEEEZ!

"revExecuteSQL, tDatabaseID, tSQL"
by SkinnyKenny
Mon Feb 10, 2020 10:17 pm
Forum: Windows
Topic: Invalid Connection ID SQLite
Replies: 18
Views: 11180

Re: Invalid Connection ID SQLite

Yeah, I have not been able to do anything further with my 2 DB's because it continually throws this error. I am thinking of two options....1 start a completely different stack and set my DB's there then attach it to my mainstack or 2 uninstall LC and run a fresh installation. Otherwise, I am stuck. ...
by SkinnyKenny
Mon Feb 10, 2020 8:52 am
Forum: Windows
Topic: Invalid Connection ID SQLite
Replies: 18
Views: 11180

Re: Invalid Connection ID SQLite

So Klaus, I am curious about the closeDB function you helped me with. Just to be sure I wasn't getting a previous connection mixed in while trying to disconnect, I created a new stack and copied the tutorial code for connecting to a SQLite DB. I am having no issues connecting or inserting info into ...
by SkinnyKenny
Thu Feb 06, 2020 1:43 pm
Forum: Windows
Topic: Invalid Connection ID SQLite
Replies: 18
Views: 11180

Re: Invalid Connection ID SQLite

I'm going to fool with it after some rest. Iv'e been up all night looking at this and can't take anymore. Maybe I have the command for closing the DB incorrect. Honestly, there really isn't a lot of info in the lessons on how to properly close a SQLite DB. There is one on closing a MYSQL, but it doe...
by SkinnyKenny
Thu Feb 06, 2020 1:06 pm
Forum: Windows
Topic: Invalid Connection ID SQLite
Replies: 18
Views: 11180

Re: Invalid Connection ID SQLite

So what's strange is this....I changed all the functions and commands with new variables. Just to check if when I connect to the DB it has the same connection number, I put "answer tDatabaseID_med" in the connection command and "answer tDatabaseID_med" when its called in my "Delete" button to see if...

Go to advanced search