Search found 63 matches

by lemodizon
Thu Sep 12, 2019 5:13 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Data Grid - how to count the data per column
Replies: 13
Views: 684

Re: Data Grid - how to count the data per column

SqliteDb.PNG Hi everyone, I'm still exploring the data grid of livecode. i created a sqlite database see picture above. where i click the button check age it will automatic update the age. my problem is how can i put the updated age to my sqlite database per column. excuse me in my coding if you fi...
by lemodizon
Thu Sep 12, 2019 5:10 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Data Grid - how to check per column
Replies: 3
Views: 272

Re: Data Grid - how to check per column

SqliteDb.PNG Hi everyone, I'm still exploring the data grid of livecode. i created a sqlite database see picture above. where i click the button check age it will automatic update the age. my problem is how can i put the updated age to my sqlite database per column. excuse me in my coding if you fi...
by lemodizon
Thu Sep 12, 2019 4:40 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Data Grid - how to check per column
Replies: 3
Views: 272

Re: Data Grid - how to check per column

Hi Craig,

Thanks for the information. i was having a hard time in exploring data grid of livecode. Thanks for the support of this forum.
by lemodizon
Wed Sep 11, 2019 9:49 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Data Grid - how to count the data per column
Replies: 13
Views: 684

Re: Data Grid - how to count the data per column

Hi Klaus, Sorry my mistake.... I thought i have to create a custom function in my button so that it will display the color in a particular cell of the datagrid and I was not able to checked the link and sample datagrid given by bangkok now i know there is called "default column behaviour" that's why...
by lemodizon
Wed Sep 11, 2019 6:11 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Data Grid - how to count the data per column
Replies: 13
Views: 684

Re: Data Grid - how to count the data per column

Hi Klaus,

I tried this script code it doesn't work.
Klaus wrote:
Sun Sep 08, 2019 1:28 pm
Hi Lemuel,

just like in that link you can only do this -> on FillInData:

Code: Select all

on FillInData pData
   if pData["gender"] = "Male" then
     set the backgroundcolor of fld "gender" of me to 0,0,0
   end if  
  ## etc...
end FillInData
Best

Klaus
by lemodizon
Wed Sep 11, 2019 5:25 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Data Grid - how to count the data per column
Replies: 13
Views: 684

Re: Data Grid - how to count the data per column

Hi Klaus, Thank you very much i tried to input my age function it works by changing the date in my computer My only concern is the leap year it doesn't work in my age function Hi Lemuel, Hi Klaus, i tried it but it doesn't work.. how come there is a field in the data grid control? yep, sorry, I had ...
by lemodizon
Wed Sep 11, 2019 5:15 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Data Grid - how to count the data per column
Replies: 13
Views: 684

Re: Data Grid - how to count the data per column

Hi bangkok, Thanks for the examples regarding datagrid. its a big help to us. This lesson explains how to do it : http://lessons.livecode.com/m/datagrid/l/7327-how-do-i-override-the-default-behavior-for-rendering-data-to-a-cell or the stack here (card "colors and drag drop") : DG_EXAMPLES 1.4 http:/...
by lemodizon
Mon Sep 09, 2019 5:31 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Data Grid - how to count the data per column
Replies: 13
Views: 684

Re: Data Grid - how to count the data per column

Hi Klaus,

i tried it but it doesn't work.. how come there is a field in the data grid control?
by lemodizon
Sun Sep 08, 2019 6:40 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Data Grid - how to count the data per column
Replies: 13
Views: 684

Re: Data Grid - how to count the data per column

Hi Klaus, Thank you for the information and for the script. i was able to understand how to fetch the data in data grid thru your script and through the guide of script editor (debug: breakpoint). I want to put a background color in each cell for ex.if female is color Pink then Male is Blue. i tried...
by lemodizon
Sat Sep 07, 2019 12:07 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Data Grid - how to check per column
Replies: 3
Views: 272

Data Grid - how to check per column

Hi Everyone,

How can i check in the column of data grid the (Birthdate) and update (Age). see the below example.

Thanks in advance.
by lemodizon
Sat Sep 07, 2019 11:46 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Data Grid - how to count the data per column
Replies: 13
Views: 684

Data Grid - how to count the data per column

Hi Everyone,

Please teach me on how to count the data per column in datagrid. i was able to get on how to count the number of lines per row. on my example below i want to know the total number of male and female under the column of gender in data grid..

Thank you in advance.
by lemodizon
Sun Aug 18, 2019 1:34 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Age Monitoring
Replies: 14
Views: 802

Re: Age Monitoring

Hello Hermann,

Thank you very much it works :) Thanks for the walk-through in livecode(Dates).

Long live Team LiveCode!
by lemodizon
Sat Aug 17, 2019 3:29 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Age Monitoring
Replies: 14
Views: 802

Re: Age Monitoring

Hello Hermann, It works :D First of all Thank you for the walk-through and for guiding me on how to deal dates in livecode. I already tested and study your script code via debug mode so that i can see how it works. i added some script code on mouseUp put ageAndDays(fld "birthdate") into x put item 1...
by lemodizon
Sat Aug 17, 2019 2:41 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Age Monitoring
Replies: 14
Views: 802

Re: Age Monitoring

Hi Lemuel, ... add dy to item 3 of tBirthDate ... "item 3 of tBirthDate" = the day of the month! See dictionary -> dateitems Best Klaus Hello Klaus, Sorry for the wrong script. i'm having a hard time in studying Dates & Time in livecode. i will check the dictionary thanks for the support. Regards, ...
by lemodizon
Fri Aug 16, 2019 4:51 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Age Monitoring
Replies: 14
Views: 802

Re: Age Monitoring

Hello, Thanks to Hermman and Criag for teaching me on how to get the current age using livecode. i created a function daysbetween that will determine the remaining days before his/her birthday but i'm stuck. I want display if he/she reached its birthday it will answer Happy Birthday and it will add ...

Go to advanced search