Search found 557 matches

by AxWald
Thu Apr 07, 2016 3:22 pm
Forum: Databases
Topic: sqlite deployment
Replies: 10
Views: 6443

Re: sqlite deployment

Hi, The encrypting/decrypting the file on startup/shutdown intrigues me, but I suspect I need an external to do this which is beyond me unless you were talking about native LC encrypt feature? Encrypting the whole db should work like this: put char 1 to 256 of the script of this stack into MyPW answ...
by AxWald
Thu Apr 07, 2016 9:31 am
Forum: Databases
Topic: sqlite deployment
Replies: 10
Views: 6443

Re: sqlite deployment

Hi, it wouldn't help to encrypt only the relevant fields in the records? It slows down quite a bit, but as long as you don't have heavy db usage this shouldn't matter. Often it's enough to use non-describing table names, and encrypt only 1 or 2 fields ... Alternatively, if not too big, decrypt the w...
by AxWald
Wed Apr 06, 2016 4:54 pm
Forum: Databases
Topic: Relative paths don't work in LC8, for SQLite?
Replies: 2
Views: 2912

Re: Relative paths don't work in LC8, for SQLite?

Hi,

done. Bug report

Edit: The ReadMe in the attachment is wrong. Replace Win 7 with Win 10 ;-)

Have fun!
by AxWald
Wed Apr 06, 2016 2:44 pm
Forum: Databases
Topic: Relative paths don't work in LC8, for SQLite?
Replies: 2
Views: 2912

Relative paths don't work in LC8, for SQLite?

Hi, to save you the time I've lost: :evil: It seems that LC8 doesn't support relative paths anymore when connecting to a SQLite db. It gives you a proper looking connectionID at "revopendatabase", but any subsequent calls to "revdatafromquery" or "revdb_execute" will fail with "no such table ..." - ...
by AxWald
Tue Apr 05, 2016 4:07 pm
Forum: Databases
Topic: The infamous POS app
Replies: 21
Views: 16956

Re: The infamous POS app

Hi, what you're describing here is commonly named an ERP . That is what I'm making my living with - helping ppl to find, setup & maintain it, then adding customer specific stuff to it - and that's where LC comes in: connecting the ERPs to web shops, POS terminals, tax advisers/ accountants/ authorit...
by AxWald
Tue Apr 05, 2016 1:27 pm
Forum: Talking LiveCode
Topic: Limiting a field to 2 decimal places
Replies: 21
Views: 10473

Re: Limiting a field to 2 decimal places

Hi, I did something similar some years ago. My experience was that "the common User™" becomes confused when what it types isn't displayed - its mental capabilities are often less than desired, and instead of realizing that it types something wrong it may cry for the IT department to replace its keyb...
by AxWald
Tue Apr 05, 2016 12:28 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: ftp ---> ftps (panic!) ...help me please... (=*.*=)
Replies: 16
Views: 8782

Re: ftp ---> ftps (panic!) ...help me please... (=*.*=)

Hi,

you might have a look in the putty package.
PSCP or PSFTP might do what you want, via simple shell scripts.

Haven't tried myself, but should I need, I'd start here ;-)

Have fun!
by AxWald
Sun Apr 03, 2016 6:30 pm
Forum: Linux
Topic: 32bit LC on 64bit Linux - hints
Replies: 13
Views: 9340

Re: 32bit LC on 64bit Linux - hints

Hi, you're a prophet: Frankly I would just install the latest 7 series 64 bit version and stop worrying about things. Well, nearly. It's a LC 8-64 that started for the first time close to the time of your posting ;-) Meanwhile on another partition: Heavy discussions between me & a 32bit CentOS that ...
by AxWald
Fri Apr 01, 2016 6:59 pm
Forum: Linux
Topic: 32bit LC on 64bit Linux - hints
Replies: 13
Views: 9340

Re: 32bit LC on 64bit Linux - hints

Hi, V8 took about double the time compared to V6. That just seems wrong. I mean, not the fact that you're seeing the slowdown, but the fact that it takes twice as long. I'd be really interested to see some sample code [...] Wasn't serious testing, just a Q&D try. I compiled a (known good) socket ser...
by AxWald
Fri Apr 01, 2016 10:27 am
Forum: Linux
Topic: 32bit LC on 64bit Linux - hints
Replies: 13
Views: 9340

Re: 32bit LC on 64bit Linux - hints

Hi, The great thing about Linux is that it's infinitely configurable; the bad thing about Linux is that it's infinitely configurable. ;) And the most bad thing is that nearly every other distributon has another way to do it ;-) You're welcome to start such a discussion, but personally I see it as lo...
by AxWald
Thu Mar 31, 2016 9:56 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 25358

Re: Remove Carriage Returns

Hi, a few more hints about this: Here: put revDataFromQuery(tab, cr, gConnectionID, tSQL) into tData is a potential culprit. It adds additional linefeeds (see Dictionary CR, which is synonym to Return). When working with data containing such already you'll want to use other delimiters, for instance:...
by AxWald
Mon Mar 28, 2016 10:03 pm
Forum: Linux
Topic: 32bit LC on 64bit Linux - hints
Replies: 13
Views: 9340

Re: 32bit LC on 64bit Linux - hints

Hi, With Ubuntu the one-liner Neil provided here did the trick for me: http://forums.livecode.com/viewtopic.php?f=20&t=20091&p=104639#p104639 Been there, tried that - no i386 versions in the repos anymore, for Centos or Solus at least. What is important is that here the i686 packages contained them!...
by AxWald
Mon Mar 28, 2016 7:21 pm
Forum: Linux
Topic: 32bit LC on 64bit Linux - hints
Replies: 13
Views: 9340

32bit LC on 64bit Linux - hints

Hi, seems there's a bit of confusion about this - running 32bit versions of LC on 64bit Linux systems. Some say it works, some say it doesn't, there's some few hints what's required all over the forum - so when I decided to give Linux another try I quickly became rather confused, too. But since it's...
by AxWald
Sat Mar 26, 2016 1:04 pm
Forum: Databases
Topic: Invisible data in MySQL
Replies: 3
Views: 3716

Re: Invisible data in MySQL

Hi, "Those are padding characters that are inserted [...] in order to achieve the desired sorting behavior depending on the input type settings. For a query like that we need to join to the ProductionControlJobs table to get the settings and then use the _FS_MARK_STR function (a user-defined functio...
by AxWald
Thu Mar 24, 2016 1:05 pm
Forum: Talking LiveCode
Topic: LiveCode Serial Problems - will they ever be fixed?
Replies: 8
Views: 5918

Re: LiveCode Serial Problems - will they ever be fixed?

Hi, Unfortunately, I'm now on a 64-bit GNU/Linux computer, and LiveCode 6 doesn't run on 64-bit GNU/Linux. Oooops? I know it's off topic, but I got the latest 6.* STABLE running on 64-bit Solus . Only - it doesn't display any fonts yet, like shown here by Richmond. Seems all that's lacking is 32-bit...

Go to advanced search