LiveCode Forums.

Is it possible to have a grid row hilite based on a time field in the data from an sqlite database. In other words as you can see there is a time that is displayed. Can the row be highlited when that time is compared to the internal time. BTW, i have now coding experience, an absolute beginner. I have managed to create the interface of the dances through lots of reading and watching. But as of yet had no luck extracting the current row data when clicked..(another post later)

Dave

Hi.

I can at least help a little with the time test. In a button script: The optionKey line is just an escape.

I do not know what you like to use to display the time, so you may have to play with the "ask" line. In the US, I would, as written, get something like "1:30 PM". Be careful of the format.

Anyway, this will trigger the answer dialog when the time passes the FUTURE moment you set. The handler will run in the background forever in the current session, including if you open another application and work there.

Craig Newman

Rereading your post, you can get the hilited row in a DG by putting this in the group script or anywhere: And you can set the hilitedLine similarly, perhaps in a button script, or anywhere at all: Craig

The times you see are not calculated. they are from the data...in this case, the time of that particular dance. What is happening is my daughters go to these dance competitions and get some program book with 60 pages of dances in it. pain in the ass to find my daughters dances out of 1200 dances. anyhow my goal is to create and app to replace the book, even if it is for me. We get the data in usually pdf format, which i convert to excel...at least for now. I will import that into sqlite then recompile with new data. I am using data from last year. I have set it up with mysql as well. and got that working but my isp gives us routers for home that I can't for the life of me open a port to test it...i have it working locally.

Sorry back to this. On progam load or data load, i ask the program to put the time in a field (not show in the above pic)

Why do all that? Why not keep it in LiveCode? Do others access that data?

Craig

By "do others access the data" do you mean via other electronic means then no! There is a pdf version of the book that each studio gets. I got a copy last year by asking the studio director. I wanted to see if the pdf could be exported to excel or excel extracted from the pdf, but either way it was. So I played with the data and developed some stats with it but that was all. What do you mean "keep it in livecode" There will be no additions after the schedule is final, they (the dance competition committee) produce the books then sell them at the event. I believe this will be very functional all events, so I am going at this slowly...card by card.

Dave

I am curious why you are going to the extra trouble of using an sqLite database.

If this is not for multi-user access, or perhaps very large files, or to use the functionality of an external SQL database, then I think that everything you want to do can easily be done in a single stack, likely on a single card.

Many users automatically assume that these fancy resources (DataGrids are another example) are used in LC as a matter of course. I never have used an SQL gadget, and hope never to have to.

So, you might well use a DG for its display prowess. But why sqLite?

Craig

Ok, i have another project that i want to do at a later time, so I am doing this for the learning aspect. Makes sense, just import a tab delimited file into the grid. now you have me thinking. Is this the approach i should be taking. I want the user to click on a row and see the current info on another screen. I guess this way there is no sql to use. just the dgDataOfIndex and the dgDataOfLine properties...correct But to do that i think i need more than one card.

Dave

Hi Dave,

tbcomputerguy wrote: ↑

Wed Mar 13, 2019 5:45 pm

But to do that i think i need more than one card.

not neccessarily, you can put the appropriate fields for the details above or below the datagrid itself. This is how many apps do this.

Best

Klaus

Dave.

My goal always is to remain inside LC at all costs. In one area, I have a handful of users that both read and write to external files on a server, that data being available to all of them. That is as far out of LC as I need to go. In that way, each instance of their local standalone is just a front end to that dataset.

Two cards is not too onerous. That is a matter of style and look and feel.

As for learning, well then, go all out. But I would build the gadget first, and then embellish, as opposed to the other way around.

Craig

Each stack contains one or more sets of information called cards. Each card can have a different appearance or all the cards in a stack can look the same. By going from card to card in a stack, you change what's being displayed in that stack's window.

that is from the how to structure you app. So i thought using cards was the way to to go..each card is a screen. the second card in my app will display more info then on the list of dances. I have chosen to to add the dancers on that screen because one dance type called production can have up 40 dancers.

Dave

tbcomputerguy wrote: ↑

Wed Mar 13, 2019 6:52 pm

I have chosen to to add the dancers on that screen because one dance type called production can have up 40 dancers.

Does your app involve Labanotation?

Nope, the app will be used by parents only and the dancers. The judging is done separately. As it is, the books as mentioned earlier, just show the dance and time etc. see pic attached. There is a date at the top of the page not printed. See the bottom act has numerous dancers.

I would use a table field and a few buttons.

We can walk you through this.

Craig

i will read up on it and i will give it a shot...can't learn if i don't try. Ill keep you posted.

Thanks for the help.

Dave