LiveCode Forums

I'm working on a project and would like to incorporate automated web scraping capabilities based on certain triggers to compile information on certain topics from the web. I've not been able to find any web scraping applications that incorporate livecode. Does anyone have any suggestions? I mean can...

Thanks Craig! That helps for the progress bars. I'll just have to write an if to pass over one if it is finished and the other not. However, I have several hundred items to update at one time and I think it would be difficult to write a repeat statement that satisfies all of the objects. Could expla...

I've tried searching this topic and haven't had much luck. Perhaps I am not using the right terminology. I would like to run multiple animations at once. Example: say I have two progress bars that once the card is open begin expanding to give the user the actual status of something. I want one to st...

Currently using YYYY-MM-DD string for date format, but the strftime function when using a modifier isn't returning a value. "SELECT strftime('%W', 'Week'), Week, Sum(CRED) FROM Temp_Table GROUP BY Week;" Put revDataFromQuery(tab, return, gDatabaseID, tSQL) into field I've not been able to figure out...

Would that look like:

loop
BEGIN TRANSACTION;
INSERT;
END TRANSACTION;
end loop

or
BEGIN TRANSACTION;
loop
INSERT;
end loop
END TRANSACTION;

Does anyone have any suggestions or good links for optimizing a bulk SQLITE insert statement from a .csv? I've not really found anything overly helpful. What I have works but I want it to go faster. Currently I'm using something like the following with a loop to loop through each entry: Put "INSERT ...

Yep...that was the problem...I'm a moron. Thanks for the help Klaus. Sorry, for being the most annoying member.


Thanks
Chris

Initiatally of course, but the above would allow for me to override the wildcard variable when the user clicked on any given portion of the UI with a more specific query. I suppose I wasn't overly clear, but I'd like whenever the person clicks on a section of the UI associated with a specific depart...

I am creating a programming in which I would like the UI to be almost entirely interactive. So if you click on something it sends the ID of that item to a variable to be included in the WHERE clause of the SQL statements updating the card. For example: you might have several items in different class...

Can someone explain to me in lamen's terms what the difference is between the two different sql statements? As in what is actually going on in the background when you use the :1 in lieu of the &variable. I've been trying to find something on this for a few weeks but I haven't really understood what'...

I have an instance where I'm running a loop, but if a certain condition exists then I need the user to confirm information before the loop continues. I'd like to pause the loop and wait for a user response then either move to the next iteration or run through the current. The only thing I'm struggli...

...of course as soon as I post this I figure out the problem. Please disregard.

I'm having fits trying to create a table using a variable for its name. I have several truncated layers of storage in my app and need the program to generate unique names for each table, but I'm struggling to get it to work. I can get them to run if I define the table names, but if I set the same na...

It was really late when I was creating my profile and it fit the moment well. :P You actually end up on a LOT of my posts as the main answerer. Thank you for all the help, btw. It is definitely appreciated. So just to be clear, essentially the only difference between a standalone native application ...

So I'm about 40% complete with a project as a standalone version, which will be my initial pilot for beta testing. The pilot has a database feature that stores the information on the machine on which it is running. Eventually I need this application to store its data on an online server farm. Can I ...