Search found 268 matches

by DavJans
Thu Feb 27, 2014 5:09 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: if or i don't get it
Replies: 6
Views: 2990

if or i don't get it

if fld "user" <> "254" or fld "user" <> "244" then answer "Invalid user" else to to card 2 I know its wrong because it only answers with Invalid user i cant seem to find the correct way to wright this alternatively how do I check for a user in a user database? was really only trying to use if/or tem...
by DavJans
Fri Feb 14, 2014 10:11 pm
Forum: Databases
Topic: Using AND and OR
Replies: 2
Views: 2342

Re: Using AND and OR

After extensive googeling I've come to the conclusion that the only way if to wright it like i rewrote it basically case1 and case2 or case1 and case3 or case1 and case4 and so on, And it works fine but I found a bug with livecode/windows 8.1 x64 The horizontal slider isn't working or I don't have i...
by DavJans
Fri Feb 14, 2014 8:00 pm
Forum: Databases
Topic: Using AND and OR
Replies: 2
Views: 2342

Using AND and OR

I think I know you are doing to tell me to do this the long way but I thought Id ask anyway here is my code and it doesn't do what I want put revQueryDatabase( theConnectionID, "SELECT * FROM tracker WHERE trackerjob='" & tJob & "' and trackerfinalqcdate IS NULL or trackercoating IS NULL") into theC...
by DavJans
Fri Feb 14, 2014 4:45 pm
Forum: Databases
Topic: Update mysql from datagrid
Replies: 3
Views: 3373

Re: Update mysql from datagrid

As always, you guys are the best, works perfectly.
Cant thank you enough
by DavJans
Thu Feb 13, 2014 9:03 pm
Forum: Databases
Topic: Update mysql from datagrid
Replies: 3
Views: 3373

Update mysql from datagrid

If there is a guide on this or lesson that would be great. If not, this is how my brain is trying to get at it and maybe someone can help me. #1 does the openField and closeField handlers work in a datagrid? #2 I know how to get data in in a specific row based on what column it is in, what I need no...
by DavJans
Wed Feb 12, 2014 1:11 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: script on timer?
Replies: 3
Views: 2058

Re: script on timer?

Thank you so much
by DavJans
Wed Feb 12, 2014 12:30 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: script on timer?
Replies: 3
Views: 2058

script on timer?

is there a way to run a set of code every minute without any user interaction when on a specific card?

like onMouseup but on5minuteinterval
by DavJans
Fri Jan 31, 2014 12:53 am
Forum: Databases
Topic: Adding multiple records
Replies: 3
Views: 3006

Re: Adding multiple records

Code: Select all

SELECT employee, SUM(weldqt) FROM cjp GROUP BY employee
I got this to work thank you :)
by DavJans
Fri Jan 31, 2014 12:21 am
Forum: Databases
Topic: Adding multiple records
Replies: 3
Views: 3006

Re: Adding multiple records

the forum omits multiple spaces in a row, I hope the table I tried to show is understandable.
by DavJans
Fri Jan 31, 2014 12:19 am
Forum: Databases
Topic: Adding multiple records
Replies: 3
Views: 3006

Adding multiple records

I was hoping someone could point me in the right direction. What I have is a MySQL database that looks like this: ID Employee Welds Fail Repair 1 10 5 0 0 2 53 10 0 0 3 10 0 3 0 4 22 0 0 3 5 53 3 0 0 6 244 0 0 8 my list at this point goes on and on, basically we check the welds that our employees do...
by DavJans
Tue Jan 28, 2014 12:14 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Changing Properties with script
Replies: 9
Views: 4630

Re: Changing Properties with script

that was a typo sorry, and the code is not in the script of the field I just set to traversalon to false, that would be silly. I would post my project but its my first ever, and very messy. I got around that issue by putting it in the "3rd" fields closeField Handle
by DavJans
Mon Jan 27, 2014 11:57 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Changing Properties with script
Replies: 9
Views: 4630

Re: Changing Properties with script

Code: Select all

 set the traversalon of fld "cats" to false
end if
worked great thank you.

this however

Code: Select all

on openField
set the traversalon to fld "cats" to true
end openField
does not work, or at the very least its not working for me
by DavJans
Mon Jan 27, 2014 10:18 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Changing Properties with script
Replies: 9
Views: 4630

Re: Changing Properties with script

Thank you, I was just coming back here to I found the lesson on this.
I would post the url as reply to my own question for others if they have the same question, but not allowed unless a moderator does it.
by DavJans
Mon Jan 27, 2014 9:52 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Changing Properties with script
Replies: 9
Views: 4630

Changing Properties with script

Im trying to make a field Un-Focusable if a previous field has No in it is

Code: Select all

if fld "cats" = "No" then
set fld "#ofcats" unfocusable
I hope my question makes sense.

even better if you can point me at a lesson on manipulating properties
by DavJans
Tue Jan 21, 2014 12:36 am
Forum: Talking LiveCode
Topic: Tab with button
Replies: 5
Views: 2934

Re: Tab with button

I must admit, it took me a while to fix tab order after I had moved about 20 fields around. but I found it in the property inspector under size and position. lucky for me I found that last week so this worked out great. Since I brought it up and am not 100% sure I guess I could ask. Layer number is ...

Go to advanced search