Search found 838 matches

by bangkok
Tue Dec 31, 2019 2:31 pm
Forum: Databases
Topic: Can't connect to my mySQL server
Replies: 1
Views: 161

Re: Can't connect to my mySQL server

Many possible causes, outside Livecode. MOST LIKELY -on your server : you need to allow MySQL login to be "remote" : https://manage.accuwebhosting.com/knowledgebase/2417/How-to-Allow-Remote-Connection-to-MySQL-Server-in-cPanelorWHM-Server.html Type your fixed IP address (if you have), or use the wil...
by bangkok
Wed Dec 25, 2019 11:14 am
Forum: Internet
Topic: Communicate with a webdav server
Replies: 9
Views: 1504

Re: Communicate with a webdav server

FourthWorld wrote:
Tue Dec 24, 2019 10:21 am
Did you find a workaround for that header issue?

If need be we can fork libURL for WbDAV support. I have some things on the horizon that need WebDAV.
Unfortunately no.

So if you have a solution, I would be glad to try it.
by bangkok
Wed Nov 27, 2019 10:43 am
Forum: SQL Yoga
Topic: name myswl table from variable
Replies: 4
Views: 1293

Re: name myswl table from variable

the whole command is below. the 2 variables are global. The put command shows the right name. In that case, what the result says ? Because if tTableName is okay, but the table creation stilll " doesn't work "... it means you have a SQL error, hence "the result" should tell you what is this error. I...
by bangkok
Tue Nov 26, 2019 12:26 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Solved: Getting and Setting global Vars from a db table
Replies: 5
Views: 282

Re: Getting and Setting global Vars from a db table

You make it much more complex that it is and should be. 2 cases. CASE 1 You want to do a : put "SELECT * FROM appSettings" into tSQL And imagine that the table appSettings contains 3 fields : f1, f2 and f3 (they were created in the table, in that order). By doing : put revDataFromQuery(,,gdbid, tSQL...
by bangkok
Tue Nov 26, 2019 11:54 am
Forum: SQL Yoga
Topic: name myswl table from variable
Replies: 4
Views: 1293

Re: name myswl table from variable

If you do not control the way you create tTableName, you'll continue to be in the dark ... In other words : what is the content of the 2 variables tclientname and taccountkey ? You should begin here. So in your script : command databaseCreateTables put tclientname & taccountkey into tTableName answe...
by bangkok
Thu Nov 07, 2019 4:37 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Compare dates question
Replies: 8
Views: 516

Re: Compare dates question

To compare 2 dates : convert them to "seconds". put "12/01/19" into tDate convert tDate from english date to seconds put the english date into tDateNow convert tDateNow from english date to seconds if tDate>tDateNow then answer "After" else answer "Before" end if
by bangkok
Wed Oct 09, 2019 3:10 am
Forum: Android Deployment
Topic: I have a bug when typing 0,35 or 0.35 in fields at Android phones
Replies: 12
Views: 671

Re: I have a bug when typing 0,35 or 0.35 in fields at Android phones

-Which field shows this weird behavior ? You have 6 fields on your card. -be more precise : when the user select field "kapmm", he types "0.35", then what is shown exactly in the field ? -no need to put the handler preOpenStack in your button script ! (it's already into your stack script) -why you s...
by bangkok
Mon Sep 23, 2019 10:44 pm
Forum: Databases
Topic: Path to database
Replies: 18
Views: 1461

Re: Path to database

Let's say the file will be located in "my documents".

Code: Select all

put specialFolderPath("documents") & "/db_test.sqlite" into tDatabasePath

put revOpenDatabase("sqlite", tDatabasePath, , , , ) into tID
by bangkok
Mon Sep 09, 2019 4:38 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Data Grid - how to count the data per column
Replies: 13
Views: 878

Re: Data Grid - how to count the data per column

This lesson explains how to do it :

http://lessons.livecode.com/m/datagrid/ ... -to-a-cell

or the stack here (card "colors and drag drop") : DG_EXAMPLES 1.4

viewtopic.php?f=7&t=15540
by bangkok
Sun Sep 08, 2019 11:10 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Populating Datagrid From SQL Cursor
Replies: 3
Views: 322

Re: Populating Datagrid From SQL Cursor

Hi, 2 mistakes : - put the result into dlist (actually the data from the query are stored into ptext !) - wrong method to populate the DG (addline. Use instead dgText) So here is something that should work, more simple : put "SELECT * FROM testtable" into tSQL put revDataFromQuery(,,conID,tSQL) into...
by bangkok
Sat Jul 27, 2019 5:22 am
Forum: Android Deployment
Topic: Barcode scanner widget : very cool
Replies: 10
Views: 1130

Re: Barcode scanner widget : very cool

As far as the barcode scanner goes, can you get it to change the preview size and get any different overlay views? Or disable it? These just simply do not work for me. I'm still doing tests (but it's boring : change something in the IDE, compile, copy .apk on the phone, uninstall previous version, ...
by bangkok
Sat Jul 27, 2019 3:00 am
Forum: Android Deployment
Topic: Barcode scanner widget : very cool
Replies: 10
Views: 1130

Re: Barcode scanner widget : very cool

But apart from one random time when snapshot data was passed with the message, I find it impossible to test for the snapshot data, nothing is passed. Well... for that matter, I still haven't figured out what is exactly... the "snapshot mode". :D I guess with time, we shall get some kind of document...
by bangkok
Fri Jul 26, 2019 1:28 am
Forum: Android Deployment
Topic: Barcode scanner widget : very cool
Replies: 10
Views: 1130

Re: Barcode scanner widget : very cool

Here is my test stack. Actually, on the area covered by the widget... you'll see your back camera working constantly (you can set up the "FPS"). The area of the widget is like... a lens. Then with your phone "target" a barcode... focus by moving back and forth your phone... LC can display a red bar ...
by bangkok
Thu Jul 25, 2019 12:32 pm
Forum: Android Deployment
Topic: Barcode scanner widget : very cool
Replies: 10
Views: 1130

Barcode scanner widget : very cool

With the release of LC 9.5 rc1, the barcode library and the barcode scanner widget become part of indy licence (a wise decision from HQ). I started to try it. It's very cool ! As usual, we can regret a lack of "documentation materials" (just the dictionary actually), but very, very interesting. And ...
by bangkok
Tue Jun 25, 2019 7:38 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: SQL Statement
Replies: 4
Views: 603

Re: SQL Statement

It's becoming a real trend. All newbies got lost with the "variablesList" and "arrayName" forms, for revExecuteSQL and revQueryDatabase commands (look in the forum...) Just don't do it ! Use the classic form, which you can read, which you can "see". If you can not "see" (read) a SQL statement, then ...

Go to advanced search