Re: shell() and pdftotext

Shell() always uses the default folder path. Example (mac/Linux): Set the defaultFolder to specialFolderPath(“home”) put shell(“ls”) Breakpoint Set the defaultFolder to specialFolderPath(“documents”) put shell(“ls”) Breakpoint I put any non native shell commands I want into my engine path,

Re: SQL(ite) question

On 1/13/20 3:03 PM, doc hawk via use-livecode wrote: On Jan 13, 2020, at 11:39 AM, Mark Wieder via use-livecode wrote: Single command? No. Also, note that you *can* submit compound commands from LiveCode to SQLite and PostgreSQL, unlike with mySQL. (Or, maybe the interface to mySQL has

Re: SQL(ite) question

Even easier: SELECT * FROM MyTable WHERE ((col1+col2+aCol1+aCol2) LIKE ‘%mysearchtermhere%’) Sean Cole Pi Digital Prod Ltd >> On 13 Jan 2020, at 23:03, Bob Sneidar via use-livecode >> wrote: > Actually I do this all the time. > > SELECT * from MyTable where > COLUMN1 like

Re: SQL(ite) question

Actually I do this all the time. SELECT * from MyTable where COLUMN1 like "%mysearchtermhere%" OR COLUMN2 like "%mysearchtermhere%" OR COLUMN3 like "%mysearchtermhere%" I loop through a list of columns I want to search to build the query. Bob S > On Jan 13, 2020, at 11:03 ,

Re: SQL(ite) question

On Jan 13, 2020, at 11:39 AM, Mark Wieder via use-livecode wrote: > > Single command? No. Also, note that you *can* submit compound commands from LiveCode to SQLite and PostgreSQL, unlike with mySQL. (Or, maybe the interface to mySQL has changed in the years since I learned this the hard

Re: iOS launch screen dimensions

Hi Panos, Here's the page with Apple's iOS launch screen sizes: Some of those are in the SB and some aren't, and vice versa. Here's what the SB asks for: 320x480 640x960 640x1136 750x1334

Re: iOS launch screen dimensions

Hello Jacque, The requirements in the S/B should match Apple's requirements - if they don't then it looks like a bug. Which screen's dimensions do not match? Also could you post the link of the webpage you are referring to? Kind regards Panos -- PS: Using a storyboard is not supported in LC. I

[ANN] This Week in LiveCode

Hi all, Read about new developments in LiveCode open source and the open source community in today's edition of the "This Week in LiveCode" newsletter! Read issue #208 here: http://bit.ly/2thhvV7 This is a weekly newsletter about LiveCode, focussing on what's been going on in and around

iOS launch screen dimensions

The list of launch screen dimensions on the Apple developer site doesn't match the requirements in the standalone builder. Does that matter? Apple doesn't recommend that method anyway, they prefer a storyboard. Has anyone done that, and is it possible? -- Jacqueline Landman Gay |

Re: SQL(ite) question

Hi Mark, > Am 13.01.2020 um 20:39 schrieb Mark Wieder via use-livecode > : > > On 1/13/20 11:03 AM, Klaus major-k via use-livecode wrote: >> Hi all, >> I searched the docs of SQLite but could not find a hint. >> Is it possible to create a "full text search" in SQL(ite) >> with ONE SQL command?

Re: SQL(ite) question

On 1/13/20 11:03 AM, Klaus major-k via use-livecode wrote: Hi all, I searched the docs of SQLite but could not find a hint. Is it possible to create a "full text search" in SQL(ite) with ONE SQL command? Something like this (pseudocode): ... SELECT * from MyTable where ANY_COLUMN like

SQL(ite) question

Hi all, I searched the docs of SQLite but could not find a hint. Is it possible to create a "full text search" in SQL(ite) with ONE SQL command? Something like this (pseudocode): ... SELECT * from MyTable where ANY_COLUMN like "%mysearchtermhere%" ... If not, how can this be done? You get the

Re: shell() and pdftotext

To elaborate further, if you can use pdftotext from the command line, but this is failing, it is because the path declared for your login shell is not getting picked up, or a different shell is being used by livedcode. Come to think of it, I have *no* idea which shell livecode defaults to—I’d

Re: use-livecode Digest, Vol 196, Issue 13

Hello Brian, Hello Phil > Message: 4 > Date: Sun, 12 Jan 2020 17:00:58 -0500 > From: Brian Milby > To: How to use LiveCode > Subject: Re: shell() and pdftotext > Message-ID: <565b0e85-464e-4a5b-9227-c6ab100b64ca@Spark> > Content-Type: text/plain; charset="utf-8" > > My guess is that shell