Search found 64 matches
- Thu Mar 05, 2020 12:15 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Reference Combo Box
- Replies: 7
- Views: 3970
Reference Combo Box
I've set up a combobox with a simple Y/N choice. How do you reference which choice was chosen? I've tried several ways based on the limited available references in the googles, the LiveCode dictionary, and the forums. I've tried to reference it directly like: ex 1: if the label of "cboFreight" is em...
- Thu Mar 05, 2020 12:03 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Concatenation issue
- Replies: 11
- Views: 6389
Re: Concatenation issue
[*]Put your SQL strings into a simple text file that you replace/ download again at each start of your program. Like such: SimplSelect » "SELECT [[myFldList]] FROM [[myTable]] WHERE [[myWhere]] [[myFinish]]" SimplInsVal » "INSERT INTO [[myTable]] VALUES [[myValues]]" (» = tab, each statement on 1 l...
- Wed Mar 04, 2020 2:45 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Concatenation issue
- Replies: 11
- Views: 6389
Re: Concatenation issue
Thanks Ax. All my queries run fine in MySQL. It is just building the query that has issues. It works, as I mentioned, without the apostrophe. I haven’t done any more on it today. Regarding stored procedures, I just prefer them to sending SQL direct in production. Allows more flexibility for changing...
- Tue Mar 03, 2020 12:12 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Concatenation issue
- Replies: 11
- Views: 6389
Re: Concatenation issue
*****UPDATE****** Per the recommendation of those on here, I removed the parentheses on the object field references. This did not have any effect on the concatenation of the apostrophes. However, through trial and error, I ended up removing all of the apostrophe concatenations. This works for some r...
- Sun Mar 01, 2020 1:27 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Concatenation issue
- Replies: 11
- Views: 6389
Re: Concatenation issue
Thanks everyone. I did try adding the apostrophe after, as that is what I did at first. I am pretty sure I tested without the parens but I’ll try it again. I tried lots of things before I posted here. If it works I’ll let you all know.
- Sun Mar 01, 2020 1:25 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Concatenation issue
- Replies: 11
- Views: 6389
Re: Concatenation issue
Thank you. 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.
- Sat Feb 29, 2020 12:18 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Concatenation issue
- Replies: 11
- Views: 6389
Concatenation issue
Greeting and happy Friday. I have an issue where when I build a SQL statement (yes, it should be a parameterized stored proc but this is a test) in Live Code. As most know, when searching a varchar value in a database you have to have the value surrounded by apostrophes (single quotes as some call i...
- Mon Feb 17, 2020 2:37 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Multiple Conditionals on if statement?
- Replies: 23
- Views: 10960
- Sat Feb 15, 2020 4:50 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Multiple Conditionals on if statement?
- Replies: 23
- Views: 10960
Re: Multiple Conditionals on if statement?
If field "Fld1" is empty and field "Fld2" is empty then instead of if "Fld1" is empty... I don't think that is the issue, JackieBlue1970 :| Field is indeed a keyword, it identifies the object you are testing, in this case field "fld1" and field "fld2". I modified the stack I posted above to include...
- Wed Feb 12, 2020 9:21 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Multiple Conditionals on if statement?
- Replies: 23
- Views: 10960
Re: Multiple Conditionals on if statement?
I figured out the issue. I was using
If field "Fld1" is empty and field "Fld2" is empty then
instead of if "Fld1" is empty...
Field appears to be a key word of some sort. Not throwing an error but wouldn't work properly.
If field "Fld1" is empty and field "Fld2" is empty then
instead of if "Fld1" is empty...
Field appears to be a key word of some sort. Not throwing an error but wouldn't work properly.
- Wed Feb 12, 2020 9:14 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Multiple Conditionals on if statement?
- Replies: 23
- Views: 10960
Re: Multiple Conditionals on if statement?
Thanks guy (and gals). Pretty sure it was something else.
- Wed Feb 12, 2020 3:55 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Multiple Conditionals on if statement?
- Replies: 23
- Views: 10960
Re: Multiple Conditionals on if statement?
Thanks for your response. Don’t have the code here but I was checking if two fields were empty. Something like:
If field1 is empty and field2 is empty then...
- Wed Feb 12, 2020 2:43 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Multiple Conditionals on if statement?
- Replies: 23
- Views: 10960
Multiple Conditionals on if statement?
Is it possible to have multiple conditions on an if statement? Such as
If x=3 and y=5 then...
I’ve tried a couple of ways and it doesn’t appear to work. Thanks
If x=3 and y=5 then...
I’ve tried a couple of ways and it doesn’t appear to work. Thanks
- Thu Feb 06, 2020 3:18 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Save Project on Run
- Replies: 10
- Views: 5161
Re: Save Project on Run
I wrote some server stuff in Python but wanted to do some other things with a user interface. I tried Django but ran into a lot of issues running in a virtual environment. I considered .Net but the newest framework was confusing as hell and all my old code (VB 2012) was breaking. I really want simpl...
- Thu Feb 06, 2020 12:40 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Save Project on Run
- Replies: 10
- Views: 5161
Re: Save Project on Run
Thanks everyone. LiveCode is such an interesting (perhaps strange) of regular development and something I don't know how to define! It's definitely uncommon, offering equally uncommon productivity. :) I agree. As an experienced developer I’ve been pleased how fast I’ve been able to do something’s. ...