How do I save the data from an Unbound Grid

[-Jinx-]

Re: How do I save the data from an Unbound Grid

A.H.

yes it does in my program every day.
i check to see if an item exist and then alert that item can not be added, or it adds one
and both times i get a message.
i modified my code to fit his.

I'll have to try it myself then. I was thinking that your way would save the use of one more variable. I think the only problem would be when you want to add more stuff to the variable.
I'm guessing that

  addConsequence =  addConsequence + "some more stuff"

Wouldn't work right?
So, if you only need it for an alert, your way is probably best, if you need it to execute some compiled script, then maybe not.

i will read your code that seems well written.

I stole ideas from a lot of people on the forum to write it....LOL

[Turnbullca]

Re: How do I save the data from an Unbound Grid

jINX TRIED THAT BUT STILL NO ALERT SHOWS UP - I was wondering if something is turned off.

[-Jinx-]

Re: How do I save the data from an Unbound Grid

Could be something with Javascript being turned off, yeah. It's a javascript popup alert. Try an a5 message box instead. I'll see if I can find the code quick.

[GGandhi]

Re: How do I save the data from an Unbound Grid

okay i read your code.
you are using one super if to start and end and process all in between. i have few if and endif. you must be a big programmer, i am not.
i do this as a hobby and learned all by myself, with the documentation alpha provided, you know exactly what that means.
the added stuff in your code
you name something as a message and then assigned that something back to the function name. i did not. i assigned the message directly to the function name.
you provided additional message what was wrong with failure to connect, execute whatever. i simply opted for a message. no additional info.
is yours better? may be.
mine suits me well and has served well
i do not know how to add smileys
that will not be my handicap.

[-Jinx-]

Re: How do I save the data from an Unbound Grid

Try this in place of the alerts:

vjscmd = "A5.msgBox.show('Message Title','<div style=`height: 1in; padding: 15pt;`>Record successfully inserted!</div>',[{html: 'OK', value: 'ok'}],function(button) {if(button == 'ok') {setTimeout(function() {},10)}});"


vjscmd = "A5.msgBox.show('Message Title','<div style=`height: 1in; padding: 15pt;`>Execute Error: Error returned was: " + js_escape(cn.CallResult.text) + "</div>',[{html: 'OK', value: 'ok'}],function(button) {if(button == 'ok') {setTimeout(function() {},10)}});"

vjscmd = "A5.msgBox.show('Message Title','<div style=`height: 1in; padding: 15pt;`>Connection Error: Error returned was: " + js_escape(cn.CallResult.text) + "</div>',[{html: 'OK', value: 'ok'}],function(button) {if(button == 'ok') {setTimeout(function() {},10)}});"

You can change the title to whatever you'd like with these as well....I think they also should be a work-around for a popup blocker.

[-Jinx-]

Re: How do I save the data from an Unbound Grid

okay i read your code.
you are using one super if to start and end and process all in between. i have few if and endif. you must be a big programmer, i am not.
i do this as a hobby and learned all by myself, with the documentation alpha provided, you know exactly what that means.
the added stuff in your code
you name something as a message and then assigned that something back to the function name. i did not. i assigned the message directly to the function name.
you provided additional message what was wrong with failure to connect, execute whatever. i simply opted for a message. no additional info.
is yours better? may be.
mine suits me well and has served well
i do not know how to add smileys
that will not be my handicap.

I learned all by myself too from reading endless documentation but mostly from people on this forum. I just started coding Xbasic a few months ago. I'm actually a Manufacturing Engineer by trade and have more experience coding for CNC machines and robots.

You taught me something new today with how you did your alerts and I'm going to try it myself.

I try to write code as clean and small as possible and your way of doing the alerts may be the way to go.

Thanks!

P.S. adding the cn.callresult is VERY helpful when you have to try to figure out why there's an error. Also you can use cn.callresult.rowsaffected to see how many records you've changed., also very helpful

[Turnbullca]

Re: How do I save the data from an Unbound Grid

mmmmm till no message with the new code

[-Jinx-]

Re: How do I save the data from an Unbound Grid

WIERD......... Have you tried a different browser? I'm guessing your right about some settings being turned off. Do you have any problems with any other javascript running properly through alpha? If you just add a new button and put nothing but a javascript alert in it, does it work?

[Progytech]

Re: How do I save the data from an Unbound Grid

I am relatively new to Alpha xBasic, but been programming mostly with VFP and VB.NET for several years and in my opinion both code are pretty good and deliver the expected result, I am used to object oriented programming and prefer JinX way of coding shown here, but coding is very personal to each developer or hobbyist and Govindan doing this as a hobby, it is a pretty darn clear code to me.

There is a constant learning in this profession and I always learn something from the forums.

[Turnbullca]

Re: How do I save the data from an Unbound Grid

Have found the issue

The default function name for the onclick event is function serverside_0c4059c580604f94b8e343e0e18738d9 and we were using addConsequence for the error message.

When I change the function to be called addconsequence i GET AN ERROR MESSAGE SAYING serverside_0c4059c580604f94b8e343e0e18738d9 CANNOT BE FOUND

[-Jinx-]

Re: How do I save the data from an Unbound Grid

Huh?
where is that function serverside_blahblah coming from? That looks like serverside xbasic that came from clicking on the "Server-side Xbasic" button in your button's onclick event and then accidently saving it. Toast that stuff. Get rid of your onClick event. Then:
1. Go back to your buttons properties and click on "onClick"
2. "Add New Action"
3. "Ajax Callback"
4. Select the callback type as "internalXbasicFunction"
5. Put your function name in "addConsequence"
6. Click ok and save, your done, since you should already have the function defined in your Xbasic functions.

[GGandhi]

Re: How do I save the data from an Unbound Grid

Edhy Rijo

thanks, appreciate your comments.

[GGandhi]

Re: How do I save the data from an Unbound Grid

chris

i have added a check to see if the record exists and if so it just updates that record as opposed to creating a new one, so you should have only one record.
please check the code, i did not test it. so look for any typographical errors, please.
few thinking: see any one can apply to you.

the whole function can be applied to on change event of the consequence field (which is radio button) if that works well for you then you can remove the button
totally so every time the teacher changes the field it will automatically submit the record no need to click another button. less work when many students are naughtier.

instead inserting and updating another record you can just update the main table and create a report based on the class_id and person_id so you can see how they behave with different teachers.

[Turnbullca]

Re: How do I save the data from an Unbound Grid

Gandi

Thanks for the reply and youe work that has helped me so much.

I have added the above function as an xbasic function and I keep getting this error.

Error executing Ajax callback function 'addConsequence' Error reported was: command: person_id = e._currentRowDataNew.person_id Property not found
e._currentRowDataNew.person_id subelement not found.

Any Ideas.

Thanks

Chris

[Turnbullca]

Re: How do I save the data from an Unbound Grid

Also,

If the Update was to be done this way (Which I like) the Selection Check Query Would be different as I would have to check to see if it had happened just in that lesson. I need to collect the Current Teacher Credentials which is the email address which is set in an Argument called USER and the Lesson which are known as periods and are names P1, P2, P3, P4 and P5.

Chris