Ajax Call Back - Add record issue

[SteveK3003]

I am trying to use an AJAX callback function to add a new record to a table. I am getting an error

Error executing Ajax callback function 'RunUpdate' Error reported was: Variable is of different type

The xbasic code is

Function RunUpdate as c (e as c)

DIM e_name as c = e._currentRowDataOld.employee_name
DIM p_num as c = e._currentRowDataOld.procedure.number
DIM p_name as c = e._currentRowDataOld.procedure.name
DIM tblTrain as P

tblTrain = table.open("training")

tblTrain.enter_begin()
tblTrain.employee_name = e_name
tblTrain.procedure_number = p_num
tblTrain.procedure_name = p_name
tblTrain.enter_end()
tblTrain.close()

End Function

I'll admit that I am very new at this stuff. So far I have spent about 4 hours on this and can't understand the issue.

What I am trying to do is pull data from the detail view of and append a table with the data.

Any help would be gratefully appreciated.

Steve

[Davidk]

Re: Ajax Call Back - Add record issue

Hey Steve,

In your DBF table...

e_name is character
p_num is character
p_name is character

is that right?

[Davidk]

Re: Ajax Call Back - Add record issue

Hey Steve,

In your DBF table...

e_name is character
p_num is character
p_name is character

is that right?

And...

Do you have your syntax correct here?

DIM e_name as c = e._currentRowDataOld.employee_name
DIM p_num as c = e._currentRowDataOld.procedure.number
DIM p_name as c = e._currentRowDataOld.procedure.name

"dot" name and number?

Ooops... how did that double post happen?

[SteveK3003]

Re: Ajax Call Back - Add record issue

Good catch.. but not the problem

Correct code is

Function RunUpdate as c (e as c)

DIM e_name as c = e._currentRowDataOld.employee_name
DIM p_num as c = e._currentRowDataOld.procedure_number
DIM p_name as c = e._currentRowDataOld.procedure_name
DIM tblTrain as P

tblTrain = table.open("training")

tblTrain.enter_begin()
tblTrain.employee_name = e_name
tblTrain.procedure_number = p_num
tblTrain.procedure_name = p_name
tblTrain.enter_end()
tblTrain.close()

End Function


And all the variables are character

[Jim Coltz]

Re: Ajax Call Back - Add record issue

Steve,

Function RunUpdate as c (e as c)

this needs to be

function RunUpdate as c (e as [COLOR="#FF0000"][B]p[/B][/COLOR])

"e" is a pointer variable that is passed into the function.

You'll also want to look at path aliases http://alphafivewiki.com/Path+and+Co...String+Aliases and change the line

tblTrain = table.open("training")

to

tblTrain = table.open("[PathAlias.ADB_Path]\training")

[Davidk]

Re: Ajax Call Back - Add record issue

Could you zip and post the two tables involved... the table that the grid is based on and the training table?

I just ran your code in my grid. My grid is based on a dbf table with the same fields as you're writing, plus an auto increment emp_id field. Now, even though the grid is based on my "trainingdev" table, I am writing back out to the same table. That should not matter. I'm not getting any errors. New records are being inserted. Except for the emp_id field, all fields in the target table are character.

[Davidk]

Re: Ajax Call Back - Add record issue

Nice Jim... missed that one. That's the error. I ran Steve's code, but I let Alpha create the function so it was created correctly.

[SteveK3003]

Re: Ajax Call Back - Add record issue

Training_New.ziptraining-1.zipI tried Jim's code corrections and it wasn't working for me. Attached are the files.

Steve

[Davidk]

Re: Ajax Call Back - Add record issue

I'll have a look, but changing my working code Function header to the incorrect code of "Function RunUpdate as c (e as c)" created the error you're reporting.

[Davidk]

Re: Ajax Call Back - Add record issue

Hey Steve,

Training-1.zip contains the training table... excellent. But Training_New.zip contains a dialog with similar, but different code. Is that the right one?

[SteveK3003]

Re: Ajax Call Back - Add record issue

Training_R.zip

You are right. My mistake.. Please disregard the Training-New File with Training_R attached.

Thanks for taking a look.

Steve

[Davidk]

Re: Ajax Call Back - Add record issue

Hey Steve,

Your code, with Jim's corrections is fine, but I'm guessing that your error message changed and that you're no longer getting "variable is of different type". You're now getting a message about sub-elements not being there. This is because you are running code from the Detail section of a grid BUT the Ajax Callback is set to the Grid part of the grid. Get into your Detail section, into the onClick event of the Create New Record button, and into the Ajax Callback Action dialog. The 2nd option in the list is Submit Part which is currently set to Grid. But you're calling RunUpdate from the Detail section. Change this option to DetailView and you should be ok.

Here's a couple of other tips. In your question always specify what area you're working from that is most likely causing the problem... Search, Grid, Detail, Dialog, Repeating Section etc.

When you're having trouble with Ajax Callbacks, or Xbasic code in general, put a debug(1) line into your code - where ever you want to start looking at the code in debugging mode - and then run your component in working mode. The code will break when executed and you can walk through to find offending sections. This is how I found that e._currentRowDataOld was not being set at all which led me back to how the callback was being called.

[SteveK3003]

Re: Ajax Call Back - Add record issue

David, your da man. Such a simple solution. In the course of trying different things, I alternated with the two different error messages. It was driving me nuts.

Much thanks, I really appreciated your time. I hope someday to have enough knowledge to give back on this board.

Steve