Search found 340 matches

by AxWald
Fri Mar 15, 2019 11:26 am
Forum: Talking LiveCode
Topic: Encrypt error
Replies: 4
Views: 153

Re: Encrypt error

Hi, binary data (as in the result from 'encrypt') is a pest to handle/ display/ read. Converted to hex the data become much more amiable - check this: function B2H pString -- from libHash-Hmac V 2.3, http://marksmith.on-rev.com/revstuff/ repeat for each byte c in pString get bytetonum(c) put basecon...
by AxWald
Tue Mar 12, 2019 12:47 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: search in mysql column 3 when found, return contents of column1 only
Replies: 2
Views: 106

Re: search in mysql column 3 when found, return contents of column1 only

Hi,

if you don't want the whole record (*) but only a field (COL 1), just ask accordingly:

Code: Select all

put "SELECT `COL 1` FROM `TABLE 1` WHERE `COL 3` LIKE '%" & zoekopdit & "%'" into tSQL
;-)
by AxWald
Sun Mar 10, 2019 1:33 pm
Forum: Bug Triage
Topic: Table Field click causing freeze and phantom field appears
Replies: 3
Views: 126

Re: Table Field click causing freeze and phantom field appears

Hi,

disable the "cell editing", and be sure to never have enabled it anywhere.
This never really worked.

Have fun!
by AxWald
Tue Feb 19, 2019 9:26 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Rounding dollar value to nearest $5
Replies: 10
Views: 373

Re: Rounding dollar value to nearest $5

Hi,

try:

Code: Select all

return ((myNum + 4.9) div 5) * 5
Have fun!
by AxWald
Fri Feb 15, 2019 8:25 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Setting a custom font on Android
Replies: 2
Views: 159

Re: Setting a custom font on Android

Hi, putting the .ttf into a "fonts" folder next to your stack & referring it in the "Copy Files" section of the SA settings as "fonts/*" is all that's needed. It ends in "YourApp.apk/assets/fonts/" then. The font is available for your app this way as if it was installed on the machine. The same work...
by AxWald
Sun Feb 10, 2019 1:58 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Email Attachments on Windows
Replies: 10
Views: 496

Re: Email Attachments on Windows

Hi KimD, I admit the sheer numbers of possibilities (that MailAlert offers) can be irritating. But actually it's quite simple - it uses an .ini file for the configuration : [CONFIGURATION] To=monitor@example.org From=automail@example.org ReplyTo=info@example.org ;Cc=admin2@example.org,admin3@example...
by AxWald
Fri Feb 08, 2019 10:26 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Email Attachments on Windows
Replies: 10
Views: 496

Re: Email Attachments on Windows

Hi, You could use Sarah Reichelts SMTP library, it's excellent for this. I was under the impression that it wouldn't work anymore with more "modern" email servers that require SSL and/or STARTTLS (gmail etc.). Then you don't need the email client of the customer. That's why I'd never even try the ab...
by AxWald
Thu Feb 07, 2019 12:21 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Email Attachments on Windows
Replies: 10
Views: 496

Re: Email Attachments on Windows

Hi, Is there a better way of doing this? I don't know if this meets your preferences, but I'm using MailAlert for all of my email business on Windows. It's a tiny command line program that just sends mails as commanded - but with a very powerful feature set. I have yet to find an email problem that ...
by AxWald
Mon Feb 04, 2019 12:53 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Connect Livecode to DB
Replies: 9
Views: 456

Re: Connect Livecode to DB

Hi, put revDataFromQuery(tab, return,gConnID, "SELECT * FROM tbl_Events WHERE City= '"& gCityfield &"' AND Date = '"& gDatefield &"',") into tConxn This results in an SQL query like that: SELECT * FROM tbl_Events WHERE City= 'Hell Central' AND Date = '2019-01-30', Check the last char - this query wi...
by AxWald
Mon Feb 04, 2019 12:43 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Failed to get content from the web in Windows 10
Replies: 12
Views: 612

Re: Failed to get content from the web in Windows 10

Hi, reporting from a Win10 machine: Downloaded the stack: http://lessons.livecode.com/m/4071/l/7523-how-do-i-get-the-content-of-a-url-on-a-web-server-into-livecode . And run it with LC 9.02 Comm. Gives correct results both for google (as is predefined) as well as for the lessons.livecode URL from OP...
by AxWald
Fri Feb 01, 2019 3:21 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Performance and background jobs
Replies: 14
Views: 556

Re: Performance and background jobs

Hi, [...] hundreds of inserts [...] Oh oh. You will want to avoid this, it's a crazy slowdown! Better CREATE TEMPORARY TABLE and feed it the data all at once, then move it around inside the db (UPDATE, INSERT). Anyways, I don't really understand what you're doin here, but to me it looks like it shou...
by AxWald
Mon Jan 14, 2019 2:00 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Search and Scrolling List field
Replies: 4
Views: 273

Re: Search and Scrolling List field

Hi, put clickLine of field "choiceField" into z It's a function - "the clickline" or "clickline()". It should result in something like "line 4 of field 5" ... put item 1 of z into y Since you haven't defined another Itemdelimiter, it's comma, and you'll get "line 4 of field 5" in y. put word 2 of z ...
by AxWald
Fri Jan 04, 2019 10:28 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: What's wrong with "it" ??
Replies: 7
Views: 356

Re: What's wrong with "it" ??

Hi,

shell commands often return "terminal-formatted text", with spaces and CRs - so I always test if something is somewhere in the result:

Code: Select all

if "No" is in tvState then
Have fun!
by AxWald
Thu Dec 20, 2018 11:02 am
Forum: Databases
Topic: MS-SQL Server ODBC Connection
Replies: 11
Views: 713

Re: MS-SQL Server ODBC Connection

Hi, The advantage of using ODBC connection strings instead of DSN is, that the user does not have to create the DSN to get the software working. That may be seen as a disadvantage, too ;-) I don't want to have the credentials in my software, that's the job of the local admin IMHO. It's he that deter...
by AxWald
Tue Dec 18, 2018 1:25 pm
Forum: Databases
Topic: MS-SQL Server ODBC Connection
Replies: 11
Views: 713

Re: MS-SQL Server ODBC Connection

Hi, I never used ODBC the way you mention - there's a much more comfortable way (at least when using Win). Look at Max' wiki regarding MS Access . That's the method using a prefab DSN and simply calling it by name: get RevOpenDatabase("odbc", "DSNName",,,) (All data needed are in the DSN, so you hav...

Go to advanced search