Search found 64 matches

by JackieBlue1970
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...
by JackieBlue1970
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...
by JackieBlue1970
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...
by JackieBlue1970
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...
by JackieBlue1970
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.
by JackieBlue1970
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. :D
by JackieBlue1970
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...
by JackieBlue1970
Mon Feb 17, 2020 2:37 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Multiple Conditionals on if statement?
Replies: 23
Views: 10960

Re: Multiple Conditionals on if statement?

bogs wrote:
Wed Feb 12, 2020 10:13 pm
All of which are very good reasons to always quote the name, now we need to find out what is happening in poor JackieBlue1970's case :wink:
Well, it is fixed now. I will try to recreate the error when I have time and post here. Thanks again.
by JackieBlue1970
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...
by JackieBlue1970
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.
by JackieBlue1970
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.
by JackieBlue1970
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?

FourthWorld wrote:
Wed Feb 12, 2020 3:21 am
It is. What do you have that isn't working?
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...
by JackieBlue1970
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
by JackieBlue1970
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...
by JackieBlue1970
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. ...

Go to advanced search