Search found 80 matches

by matthiasr
Tue Jun 11, 2019 1:02 pm
Forum: Talking LiveCode
Topic: Drag-drop image onto app icon?
Replies: 2
Views: 354

Re: Drag-drop image onto app icon?

This is an example script how it will work with the standalone under Mac OS. Put the following script into the stack script and adjust it to your needs. on appleEvent pClass, pEventID, pSender if pClass is "aevt" and pEventID = "odoc" then ## This is an apple event ## We request the data about the a...
by matthiasr
Mon Apr 29, 2019 11:48 pm
Forum: Off-Topic
Topic: Old tips = new tricks
Replies: 51
Views: 5585

Re: Old tips = new tricks

Hi,

works here so far w/o a problem.
just noticed that the entries in the tip menu are longer than the width of the button. see 1 in screenshot

As current LC versions do not support old Mac OS anymore, maybe the reference could be removed. see 2 in screenshot
lctips.png
lctips.png (83.46 KiB) Viewed 1537 times
Regards,

Matthias
by matthiasr
Mon Apr 29, 2019 10:29 am
Forum: Databases
Topic: Requesting feedback on new docs for dbLib
Replies: 3
Views: 571

Re: Requesting feedback on new docs for dbLib

Hi Andre, first of all are you aware that http://fon.nu, which is shown in your signature, shows an account suspended error when visited. I´ve purchased a commercial library long time ago but did not use it yet. Not because of the library, but because of lack of time to dive into it. The docs looks ...
by matthiasr
Wed Feb 13, 2019 8:08 pm
Forum: Announcements
Topic: ANN: Seth V3 Released
Replies: 4
Views: 749

Re: ANN: Seth V3 Released

Hi again,

please forget my question. Just noticed that i can update from within V2.

Thanks.
by matthiasr
Wed Feb 13, 2019 7:39 pm
Forum: Announcements
Topic: ANN: Seth V3 Released
Replies: 4
Views: 749

Re: ANN: Seth V3 Released

That´s great news.

I am a current user, how do i get the update?

Will you send out an announcement to all current users?

Regards,

Matthias
by matthiasr
Thu Jan 31, 2019 4:55 pm
Forum: Talking LiveCode
Topic: Returning a value from an SQL query
Replies: 5
Views: 544

Re: Returning a value from an SQL query

You have to use the function revDatafromQuery for this.

revExecuteSQL is used for example for inserting, updating, deleting a record.
by matthiasr
Wed Jan 16, 2019 8:01 pm
Forum: Talking LiveCode
Topic: Retrieving text with accents
Replies: 2
Views: 423

Re: Retrieving text with accents

You could try to use textdecode() function to convert the complete response.

It tried just with only S√£o Paulo.

Put textdecode("S√£o Paulo","UTF-8") returns the correct spelling.

Matthias
by matthiasr
Wed Dec 26, 2018 9:07 pm
Forum: Talking LiveCode
Topic: How to switch off Autocomplete in Community Plus
Replies: 2
Views: 423

Re: How to switch off Autocomplete in Community Plus

Hi,

open Script Editor. In Menu Edit->Options you can disable it.

Image
by matthiasr
Thu Dec 20, 2018 12:37 pm
Forum: Databases
Topic: MS-SQL Server ODBC Connection
Replies: 11
Views: 1828

Re: MS-SQL Server ODBC Connection

A very old post may still be relevant to create dsn files without having to have the user do it beforehand. http://forums.livecode.com/viewtopic.php?t=2441 The link referred to will need to have "runrev" replaced with "livecode" and "/phpBB2" replaced with empty thus: http://forums.livecode.com/vie...
by matthiasr
Thu Dec 20, 2018 12:35 pm
Forum: Databases
Topic: MS-SQL Server ODBC Connection
Replies: 11
Views: 1828

Re: MS-SQL Server ODBC Connection

Matthiasr, Thanks for the snippets. The driver names are not matching I recognize, should they be changed to my driver name, or is LiveCode providing drivers based on those driver names? No, you have to use the exact driver name. Currently it´s not possible to use ODBC connection strings under Mac ...
by matthiasr
Thu Dec 20, 2018 12:27 pm
Forum: Databases
Topic: MS-SQL Server ODBC Connection
Replies: 11
Views: 1828

Re: MS-SQL Server ODBC Connection

I don't want to have the credentials in my software, that's the job of the local admin
That´s why my software has a preferences stack, where the user can add credentials e.g for ODBC, SMTP, SFTP or other services. :wink:
by matthiasr
Tue Dec 18, 2018 3:24 pm
Forum: Databases
Topic: MS-SQL Server ODBC Connection
Replies: 11
Views: 1828

Re: MS-SQL Server ODBC Connection

Dunno if this helps (and works on a Mac), but it may be worth a try DSN is also supported on Mac OS X, but i think the driver has to support it and until now i did not find a way to use the Microsoft ODBC SQL driver with DSN. Btw.: The advantage of using ODBC connection strings instead of DSN is, t...
by matthiasr
Tue Dec 18, 2018 10:13 am
Forum: Databases
Topic: MS-SQL Server ODBC Connection
Replies: 11
Views: 1828

Re: MS-SQL Server ODBC Connection

George, [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded I get this error message too under Mac OS X when using an SQL connection string to connect, regardless which drivers i use. I´ve filed a bug already. https://quality.livecode.com/sho...
by matthiasr
Tue Sep 25, 2018 3:48 pm
Forum: Talking LiveCode
Topic: CPanel
Replies: 9
Views: 955

Re: CPanel

You need to add the ip address from where you want to connect to the DB. That´s the ip address you are getting from your ISP when connecting to the internet, not your local ip address. But for security reasons you should consider to use a php or livecode server script on your webserver to do the dat...
by matthiasr
Mon Sep 24, 2018 7:34 pm
Forum: Talking LiveCode
Topic: CPanel
Replies: 9
Views: 955

Re: CPanel

HostM has provided a nice tutorial for how to securely connect to MySQL/MariaSQL Database from a Livecode Desktop app using a Livecode Server script on your webserver.

https://www.hostm.com/tutorials/livecod ... iadb-mysql

Go to advanced search