Search found 24 matches

by nrprioleau
Wed Oct 12, 2016 8:35 pm
Forum: SQL Yoga
Topic: Return specific columns from DB
Replies: 1
Views: 1029

Re: Return specific columns from DB [RESOLVED]

I have found my solution.
by nrprioleau
Wed Oct 12, 2016 2:00 pm
Forum: SQL Yoga
Topic: Return specific columns from DB
Replies: 1
Views: 1029

Return specific columns from DB

What is the syntax using sqlyoga for the following:

Code: Select all

SELECT year(sales_salesDate) as yr from sales
GROUP BY yr
Or can I build my own query such as the above and execute within the SQL Yoga framework?
by nrprioleau
Wed Oct 12, 2016 1:57 pm
Forum: SQL Yoga
Topic: DBConnection on hosted server drops after a few minutes
Replies: 6
Views: 1612

Re: DBConnection on hosted server drops after a few minutes

Thank you.

I was using the sqlYoga syntax incorrectly and have managed to solve my problem
by nrprioleau
Mon Oct 10, 2016 11:01 am
Forum: SQL Yoga
Topic: Last Inserted ID
Replies: 2
Views: 1537

Last Inserted ID

Please can I have the right syntax to use for retrieving the last inserted id after creating a record? I have this which returns 0 command mlteSales_CreateSales pRecordA local tSqlQuery, tSqlParamsA, tRowid -- sqlquery_create "sales", pRecordA put the result into theError put it into theAffectedRows...
by nrprioleau
Fri Oct 07, 2016 11:41 am
Forum: SQL Yoga
Topic: "3rd" generation relationship
Replies: 1
Views: 890

"3rd" generation relationship

This is a bit perplexing for me so hopefully I am just being short sighted here but I have 3 tables. products (products) poheader (purchase order header) podetail (purchase order detail) I have defined relationships between the poheader and podetail tables as well as a relationship between the produ...
by nrprioleau
Fri Oct 07, 2016 7:55 am
Forum: SQL Yoga
Topic: DBConnection on hosted server drops after a few minutes
Replies: 6
Views: 1612

Re: DBConnection on hosted server drops after a few minutes

Thanks for all the comments, I now understand why I am having the errors as I moved away from SQLYoga in various parts of my app as I was not sure how to achieve the results I needed using SQLYoga. Perhaps someone can shed some light for me. I am building a chart and need to execute the following sq...
by nrprioleau
Thu Oct 06, 2016 8:25 am
Forum: SQL Yoga
Topic: DBConnection on hosted server drops after a few minutes
Replies: 6
Views: 1612

DBConnection on hosted server drops after a few minutes

Good morning, i have built my application using SQLYOGA and GLXApp Framework. It works beautifully. But... I host my PHP/Mysql on Godaddy file hosting service. After I have connected to the DB and worked for a few minutes, the connection drops out and my application becomes unresponsive. Would this ...
by nrprioleau
Thu Sep 15, 2016 9:05 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Document Management in Livecode
Replies: 2
Views: 795

Re: Document Management in Livecode

Thanks Lagi,

That has definitely given me something to work on. I may check back with you if I run into any trouble.

Nic
by nrprioleau
Tue Sep 13, 2016 2:28 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: glxApplication Framework Auto Update
Replies: 3
Views: 793

Re: glxApplication Framework Auto Update

Anyone at all got any help for me?
by nrprioleau
Mon Sep 12, 2016 3:07 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Document Management in Livecode
Replies: 2
Views: 795

Document Management in Livecode

I am nearing the end of my app build but one last thing I have to achieve is to allow users to "attach" documents to a record. For instance, on a purchase, I'd like to link or attach Purchase Orders, Supplier Invoices, etc to a record. My app is built using mySQL. I would assume the best way would b...
by nrprioleau
Fri Aug 26, 2016 11:24 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: glxApplication Framework Auto Update
Replies: 3
Views: 793

Re: glxApplication Framework Auto Update

I am manually calling glxapp_updateIfAvailable and if I debug it, the command

Code: Select all

put glxapp_getProp("auto update url") into theURL
is empty.. a screenshot of my Properties is attached.
by nrprioleau
Thu Aug 25, 2016 2:12 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: glxApplication Framework Auto Update
Replies: 3
Views: 793

glxApplication Framework Auto Update

Good day, I have built my application using glxApp Framework. I am having trouble with getting the auto update feature to do anything. I have created my build, uploaded to the server, etc. When and how does the app check to see if there is a new version? Is this a call I have to make? From my unders...
by nrprioleau
Thu Aug 25, 2016 1:55 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Switch Button Widget
Replies: 2
Views: 1011

Re: Switch Button Widget

Hi thanks, that worked great!
by nrprioleau
Thu Aug 25, 2016 9:42 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Switch Button Widget
Replies: 2
Views: 1011

Switch Button Widget

Please can someone explain why this code in my switch button generates an error in the IDE as well as the standalone?

Code: Select all

on hiliteChanged
   put the hilited of me into tAction
   doChangeRecord tAction
end hiliteChanged
by nrprioleau
Thu Aug 25, 2016 9:37 am
Forum: SQL Yoga
Topic: Standalone will not run [Solved]
Replies: 11
Views: 1966

Re: Standalone will not run ** FIXED **

I don't know why exactly but I removed the revDB external package in the standalone settings and the app is now running!

Go to advanced search