LiveCode Forums

AxWald - nice handlers. Might need to take account of single digit day and month numbers unless you always force them to have leading zeros internally.

Definitely in favor of using strftime in your SELECT statements, make SQLite do the work for you instead of writing LC code to do it.

Pete

You'll have to be careful when SELECTing your data since the default separator for the columns in revDataFromQuery is a comma so your 12,5 will look like two columns in the data coming back from revDataFromQuery. Fortunately, you can specify the column delimiter to use in revDataFromQuery: put revDa...

Wondering why you are not using the standard sql date format of YYYY-MM-DD?

As Adrian noted, the answer to whether to execute the queries on the server depends on a lot of things. How sensitive is your data? Do you care if your database gets hacked via SQL injection? And many others. The simplest thing you can do to protect your security is to to use the variables list para...

Don;t think you can format it in exactly the way you want it but one way to make the code more readable is to break thew SQL statement into a series of constants and string them together to create the complete statement. For example; constant kSelect="Select Inventory.PLU_Number,Inventory.Plu_Descri...

I'd like to suggest one small but significant change to this. Change the code: put "SELECT MessageP FROM Proxic WHERE NameP='what i''m looking for';" into tSQL put revDataFromQuery(tab, return, gConnectionID, tSQL) into tData to: put "what I'm looking for" into tSearch put "SELECT MessageP FROM Prox...

Version 2.2.2 of lcStackBrowser, a plugin replacement for the Livecode Application and Project Browser, is now available. This is mainly a bug fix release with a couple of minor enhancements, detailed in the release notes at https://goo.gl/DGUg65. This is a free update for existing users. A 30-day, ...

Yes, those are the ones.
Pete

The SQL side of this is easy, with the caveat that you should use the variableslist/arrayname parameter of revExecuteSQL so you don't have to worry about escaping quotes. Can't help much with how to download the csv file if you mean you want to do it programmatically. To parse the csv file, the only...

The SQL to delete all rows from a table is: DELETE FROM <tablename> The absence of the WHERE clause indicates all rows are to be deleted. So your LC code would be: revExecuteSQL gConnectionID,"DELETE FROM MessagesP" if the result is not an integer then <insert your error handling here> end if If you...

Sequence should be:

BEGIN
INSERT
If error then ROLLBACK and exit
UPDATE
If error then ROLLBACK and exit
COMMIT

I'm pleased to announce the release of lcStackBrowser v2.2.1,a plugin replacement for the Livecode Application Browser, Project Browser, Property Inspector, and Tools palette. This is a free update for existing users. A free 30-day trial version is available at http://www.lcsql.com/lcstackbrowser.ht...

I'm pleased to announce the availability of version 2.2.0 of lcStackbrowser, a plugin replacement for the Livecode Application Browser and Project Browser. This is a free update for all existing users. A demo version is available at http://www.lcsql.com/lcstackbrowser.html. This release includes the...

You know that happened to me too but I thought it was a factor of what else was happening on my computer at the time. I have a test stack of my own that I used to figure out how to get what I need from the dictionary so I just went back and rant a few times and sure enough, it takes about 3 times as...

After successfully parsing the dictionary file, I was prowling around the array and came across jsonImport and jsonExport as part of a JSON library which looks like it was introduced in LC8. Out of curiosity, I used jsonImport to parse the dictionary file. It looks like it produced the same results ...