Search found 557 matches
- 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...
- 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...
- 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!
done. Bug report
Edit: The ReadMe in the attachment is wrong. Replace Win 7 with Win 10 ;-)
Have fun!
- 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 ..." - ...
- 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...
- 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...
- 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!
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!
- 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 ...
- 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...
- 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...
- 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:...
- 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!...
- 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...
- 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...
- 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...