Search found 52 matches

by hrcap
Sun Mar 29, 2020 3:56 pm
Forum: Databases
Topic: Join
Replies: 5
Views: 320

Re: Join

Thank you very much guys ghettocottage you are correct, I was already using a 'linking table' but just used the example given on here as a simplified example. I was previously picking data from each table and combining the data which would become a problem once I have many lines of data... hence loo...
by hrcap
Sat Mar 28, 2020 3:35 pm
Forum: Databases
Topic: Join
Replies: 5
Views: 320

Join

Hi All I hope everyone is staying safe and making most of the extra time they have at home. I am trying to write an SQL query with little luck: Aim: To retrieve data from two tables e.g. Table: PERSONS ID......Name......Age 1.......Ben.........12 2.......Peter........21 3.......Paul.........32 Table...
by hrcap
Wed Mar 25, 2020 1:06 pm
Forum: LiveCode Hosting
Topic: server migration to quartz
Replies: 5
Views: 2772

Re: server migration to quartz

Hi All I hope that everyone is staying safe and well. Matthiasr, thank you very much for your input, liburlformdata solved the problem, as you stated where the server was upgraded to a newer version which is more 'strict' it was causing an issue. I have now been through all of my scripts and amended...
by hrcap
Tue Mar 10, 2020 9:56 am
Forum: LiveCode Hosting
Topic: server migration to quartz
Replies: 5
Views: 2772

Re: server migration to quartz

Thanks for the reply much appreciated

when using liburlformdata is there another command that I must you on the server to 'un-form' the data from the url format?


Many Thanks
by hrcap
Tue Mar 10, 2020 12:25 am
Forum: LiveCode Hosting
Topic: server migration to quartz
Replies: 5
Views: 2772

server migration to quartz

Hi All I have just been migrated to the new hosted server. When I post to the server to request data from the server it work fine unless I post the following (note that this used to work fine until the migration): MODE_DEVELOPMENT=mode_test&DATA_RETURN_FORMAT=~~~_separated&SQL=select COLUMN_NAME fro...
by hrcap
Wed Nov 20, 2019 11:22 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Data grid Mobile - unexpecged Hilite
Replies: 0
Views: 1725

Data grid Mobile - unexpecged Hilite

Evening All I hope that everyone is well. I have a funny occurrence that I have spent the last two days trying to figure out but cannot for the lift of me work out what's causing it. It occurs when using a data grid on mobile. If I click on the datagrid the boarder of the datagrid seems to hilite it...
by hrcap
Fri Nov 01, 2019 1:13 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Call Script from within script on server
Replies: 2
Views: 555

Re: Call Script from within script on server

wonderful thank you

I think the part I was missing was the 'include' which seems to be how you get a 'script only stack' to run when calling it from a server based script, i.e.

include "script_connect_to_db"



thanks for your help
by hrcap
Thu Oct 31, 2019 6:53 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Call Script from within script on server
Replies: 2
Views: 555

Call Script from within script on server

Hi Guys I hope that everyone is well. Is it possible to call another script from within a script held on a the hosted server (the same way as you call a script only stack when working in a local environment) EXAMPLE: If you have an app that sends a post to a script on the LiveCode server (I'll give ...
by hrcap
Sun Sep 08, 2019 8:52 pm
Forum: Mac OS
Topic: Script editor view problem
Replies: 10
Views: 3725

Re: Script editor view problem

Evening All

I have had a similar problem.

My script editor view no longer shows the variables pane at the bottom. I have uninstalled and reinstalled Livecode indy 9.05 on Mac and it still isn't showing.


Am I unaware of a setting?


Many Thanks
by hrcap
Mon Aug 19, 2019 6:09 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Snapshot as Gif
Replies: 2
Views: 353

Snapshot as Gif

Good Afternoon All I have been building my app on a Mac and until today have only built the solution for use on a Mac. Today I tried building my App for windows and was very impressed with the performance. I have however discovered an issue and I can't work out why it is happening, does anybody have...
by hrcap
Mon Aug 19, 2019 3:19 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Failed to Load External: TsNet
Replies: 5
Views: 505

Re: Failed to Load External: TsNet

Hi Again Panos

Again thank you very much for the reply. I have now downloaded the most recent version of Livecode which has solved the problem :D

Now on to solving the unique quirks that it appears running in windows has thrown up.


Have a great day
by hrcap
Mon Aug 19, 2019 2:13 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Failed to Load External: TsNet
Replies: 5
Views: 505

Re: Failed to Load External: TsNet

Hi Panos

Thank you very much for taking the time to reply. I can confirm that I did copy the whole folder to the windows computer


I am currently using version 9.5.0-dp-1


Many Thanks
by hrcap
Mon Aug 19, 2019 11:26 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Failed to Load External: TsNet
Replies: 5
Views: 505

Failed to Load External: TsNet

Good Morning All I hope that everyone is well. I have just tried to build my Livecode App in the Windows version for first same time. Up to now I have been building compiling it for Mac and iOS which has worked excellently. I now build my App for windows (using my Mac) and then copy the App to a win...
by hrcap
Sat Jul 20, 2019 7:06 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Array add column with 'days until due'
Replies: 13
Views: 1448

Re: Array add column with 'days until due'

Thank you very much all With some further research I have found that the word 'cast' is necessary within the sql statement to remove the decimal place... as below: --selects all of the data and then adds the number of days until expiry on to the end of each row of data put "SELECT *, cast(ROUND( STR...
by hrcap
Sat Jul 20, 2019 2:37 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Array add column with 'days until due'
Replies: 13
Views: 1448

Re: Array add column with 'days until due'

Thanks Bogs

However if the method of searching for a decimal point was used it would again mean that the data should have to be looped through line by line to find the decimal point near the end of each line.

Is there any reason why the ROUND part of the SQL query wouldn’t be working?

Many Thanks

Go to advanced search