More Lesson 3 Help Needed
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
More Lesson 3 Help Needed
Got side tracked with another project & still working through lesson 3
Everything is working & I can run the app in LC but when I go to test it in the Simulator everything looks fine, but only the "Direct MySQL" & "Web MySQL" database with the two Veronicas displays
When I click the "SQLite" button the database is still displaying two Veronicas, any tips?
Just been trying to figure this out & discovered that if I am in LC & the SQLite database is displaying just prior to setting the standalone settings, then, when the app is loaded in the simulator, the SQLite database is displayed, them I can click the Direct MySQL or the Web MySQL & the database changes but when I click back on the SQLite button the database is still showing the database with the two Veronicas in it?
Everything is working & I can run the app in LC but when I go to test it in the Simulator everything looks fine, but only the "Direct MySQL" & "Web MySQL" database with the two Veronicas displays
When I click the "SQLite" button the database is still displaying two Veronicas, any tips?
Just been trying to figure this out & discovered that if I am in LC & the SQLite database is displaying just prior to setting the standalone settings, then, when the app is loaded in the simulator, the SQLite database is displayed, them I can click the Direct MySQL or the Web MySQL & the database changes but when I click back on the SQLite button the database is still showing the database with the two Veronicas in it?
Re: More Lesson 3 Help Needed
Hi Pip,
Could you post your stack here for us to have a look at? It will be easier to track down what could be causing the issue when we can see what is going on in your stack.
Kind Regards,
Neil Roger
--
RunRev Support Team ~ http://www.runrev.com
--
Could you post your stack here for us to have a look at? It will be easier to track down what could be causing the issue when we can see what is going on in your stack.
Kind Regards,
Neil Roger
--
RunRev Support Team ~ http://www.runrev.com
--
Re: More Lesson 3 Help Needed
Thanks Neil
Tried to post the stack as an attachment but got a message saying "The extension live code is not allowed"
Is there another way to post the stack?
Pip
Tried to post the stack as an attachment but got a message saying "The extension live code is not allowed"
Is there another way to post the stack?
Pip
-
- VIP Livecode Opensource Backer
- Posts: 3901
- Joined: Sat Mar 24, 2007 2:54 am
- Location: Palo Alto
Re: More Lesson 3 Help Needed
Hi Pip,
zip your stack up first
Simon
zip your stack up first
Simon
I used to be a newbie but then I learned how to spell teh correctly and now I'm a noob!
Re: More Lesson 3 Help Needed
OK, have attached stack
Also continued to work thru lesson 3 & added the search code but now get the below error when connecting to the database. Can't understand why as didn't think I had touch the code for the database type.
group "databaseType": execution error at line 4 (Handler: can't find handler) near "databaseConnect", char 1
Pip
Also continued to work thru lesson 3 & added the search code but now get the below error when connecting to the database. Can't understand why as didn't think I had touch the code for the database type.
group "databaseType": execution error at line 4 (Handler: can't find handler) near "databaseConnect", char 1
Pip
- Attachments
-
- SummerSchoolApp.livecode.zip
- (175.67 KiB) Downloaded 475 times
Re: More Lesson 3 Help Needed
Hi Pip,
It looks like you had a few typos in your database search handler, and as this was causing an error when the stack is launched, it looks like it had an effect on your databaseConnect handler.
What you had in your search handler was -
where it should be-
Although this looks almost identical, please keep an eye out for single quote usage when generating your SQL statement (e.g after the %)
Although this is not directly linked to your initial question, it may inadvertently provide a solution. Please keep us informed on how you get on.
Kind Regards,
Neil Roger
--
RunRev Support Team ~ http://www.runrev.com
--
It looks like you had a few typos in your database search handler, and as this was causing an error when the stack is launched, it looks like it had an effect on your databaseConnect handler.
What you had in your search handler was -
Code: Select all
put "WHERE firstname LIKE "%" & tSearchText & "%" OR lastname LIKE "%" & tSearchText & "%"" after tSQLQuery
Code: Select all
put " WHERE firstname LIKE '%" & tSearchText & "%' OR lastname LIKE '%" & tSearchText & "%'" after tSQLQuery
Although this is not directly linked to your initial question, it may inadvertently provide a solution. Please keep us informed on how you get on.
Kind Regards,
Neil Roger
--
RunRev Support Team ~ http://www.runrev.com
--
Re: More Lesson 3 Help Needed
Thanks Neil
May need to look at getting a bigger screen, I could not see that there were both single ' and double " in the query.
The search is now working but I'm still left with the original problem of the app not working in the simulator.
Everything is working in LC but when I go to test it in the Simulator everything looks fine, but only the "Direct MySQL" & "Web MySQL" database with the two Veronicas displays, when I click the SQLite, the two Veronicas are still on display.
May need to look at getting a bigger screen, I could not see that there were both single ' and double " in the query.
The search is now working but I'm still left with the original problem of the app not working in the simulator.
Everything is working in LC but when I go to test it in the Simulator everything looks fine, but only the "Direct MySQL" & "Web MySQL" database with the two Veronicas displays, when I click the SQLite, the two Veronicas are still on display.
- Attachments
-
- SummerSchoolApp.livecode 2.zip
- (175.5 KiB) Downloaded 471 times
Re: More Lesson 3 Help Needed
Hoping someone can take a look at my stack and help me sort it out. Got past the SQLite part successfully but stuck on the Direct MySQL part.
Re: More Lesson 3 Help Needed
Hi willdee76,
I have tried out your stack and all is working from my end. Please see the below video that shows your stack working (with no changes) and stepping through your code.
The most likely reason for no database ID being returned is if there is no internet connection available to the LiveCode IDE. Please ensure no firewall are blocking internet traffic to LiveCode and that you have a valid internet connection when developing your app.
http://techsupport.on-rev.com/SS.mp4
Kind Regards,
Neil Roger
--
RunRev Support Team ~ http://www.runrev.com
——
I have tried out your stack and all is working from my end. Please see the below video that shows your stack working (with no changes) and stepping through your code.
The most likely reason for no database ID being returned is if there is no internet connection available to the LiveCode IDE. Please ensure no firewall are blocking internet traffic to LiveCode and that you have a valid internet connection when developing your app.
http://techsupport.on-rev.com/SS.mp4
Kind Regards,
Neil Roger
--
RunRev Support Team ~ http://www.runrev.com
——
Re: More Lesson 3 Help Needed
Much appreciated Neil, good lesson learned. I have a variety of networks to choose from here and I chose a different one and it worked perfectly. Thanks so much. Now I know I am not crazy, I compared the code with the lesson like ten times. Ha ha
Re: More Lesson 3 Help Needed
Wow I am back again. Went through the part where we set up the search function for each database type and now moved on to creating the new card and the navigation control for it. I think that the lessons are great and very detailed. I consider myself a above average learner. Livecode has a way of making me feel like a complete dolt every other step. Hopefully this is just a growing pain of a baby programmer. Well I am stuck on the part where clicking on the list in the field should display the alternative card. Instead I get this error.
Included my stack
Included my stack
Re: More Lesson 3 Help Needed
Hi Willdee76,
Apologies for the delayed response.
I've had a look at your script and it seems you are missing a single quote from your SQL query. More speficically you have-
where it should be-
After I made this change, the name details show within the contactDetails card
Kind Regards,
Neil Roger
--
RunRev Support Team ~ http://www.runrev.com
——
Apologies for the delayed response.
I've had a look at your script and it seems you are missing a single quote from your SQL query. More speficically you have-
Code: Select all
put " WHERE contact_id='" & pContactID & "" after tSQLQuery
Code: Select all
put " WHERE contact_id='" & pContactID & "'" after tSQLQuery
Kind Regards,
Neil Roger
--
RunRev Support Team ~ http://www.runrev.com
——