Set Primary Address

[Gustavo1478]

Re: Set Primary Address

Also tried

IF cn.open("::Name::JAC")=.f.
alert("boken")
else
vSQL = "update email SET isActive = 0 WHERE fk_trainee_id ="+e.dataSubmitted.fk_trainee_id
cn.execute(vSQL)
end if

But I do not get an alert and the records do not update. Im seriously at a loss at this?

[lgrupido]

Re: Set Primary Address

Take your sql statement and try running it in whatever you are using to run SQL statements. (ie: Navicat or SQL server manager.)

Make sure you have a working sql statement. Because what you are describing is acting like the sql is not running properly.

Also, you should put in

debug(1)

At the front of this code.

That will put you into debugger mode. The next thing to check is that fk_trainee_id is holding the correct information.

From the debugger, you can see all the variables. If you've never been in the debugger, you are in for a treat!

Larry

[Gustavo1478]

Re: Set Primary Address

Im pretty sure Im using the debug(1) wrong because for every variable that I dimmed, it tells me that the variable is not found. Need to research how to use the debug(1) statement.

[lgrupido]

Re: Set Primary Address

Start stepping through the procedure, at least until you get past the dims.

Until you actually encounter the dim, it won't be there.

The debugging starts right at the debug command and any statements that come after it haven't been run yet.

[Gustavo1478]

Re: Set Primary Address

Ok, I Just stepped through my statement and everything looks fine, Everytime the step gets to a flag, it returns .t. Heres the statement I am running

debug(1)
dim cn as sql::Connection
dim TraineeID as n
dim sqlUpdate as c
TraineeID = e.dataSubmitted.FK_TRAINEE_ID

flag = cn.open("::Name::JAC")
If flag = .f. then
alert("Could Not Establish Connection")
end if

sqlUpdate = "UPDATE email SET isActive = 0 WHERE fk_trainee_id="+TraineeID

flag = cn.Execute(sqlUpdate)

And it is using the correct Parent ID. But the update never happens? What am I missing.

[Gustavo1478]

Re: Set Primary Address

I ran

UPDATE jac.email SET isActive = 0 WHERE fk_trainee_id=8064

In MySQL workbench (I use navicat but Im not sure how to run a query through it) and the result was zero rows affected, but there are atleast five that it should have updated?

[Gustavo1478]

Re: Set Primary Address

Ooops, My bad.

Ive been refreshing the wrong table which is why I never saw the change, I am so sorry for wasting your time. The update is working just fine.

[Gustavo1478]

Re: Set Primary Address

Two more questions, there is a date field which I would also like to update called "ModifiedOn" which simply holds a date in the following format 'MM/DD/YYYY', When I try to add this column to the update as Date(), it returns all zeros in MySQL table. Do I need to format this before it will insert the properly formatted date?

How do I create a pop-up window for the user if the update failed? alert() does not work here,
flag = cn.Execute(sqlUPDATE)
If flag = .f. then
alert("Record Update ERROR")
end if

[lgrupido]

Re: Set Primary Address

alert is a javascript function, not an Xbasic function. Look in the instructions for the event you are in to get an explanation of how to run javascript after the event.

Generally, you have to do something like:

e.javascript = "alert('Record Update Error');"

Note the exact format of what I put in there. Capitalization and formatting matter a LOT for javascript. Also, single quotes denote text in JavaScript, but double quotes are text in Xbasic.

As far as the modified on date - just do that in a trigger:

set modifiedon = date(now()) ;

In the update and/or the insert trigger.

[Gustavo1478]

Re: Set Primary Address

alert is a javascript function, not an Xbasic function. Look in the instructions for the event you are in to get an explanation of how to run javascript after the event.

Generally, you have to do something like:

e.javascript = "alert('Record Update Error');"

Note the exact format of what I put in there. Capitalization and formatting matter a LOT for javascript. Also, single quotes denote text in JavaScript, but double quotes are text in Xbasic.

As far as the modified on date - just do that in a trigger:

set modifiedon = date(now()) ;

In the update and/or the insert trigger.

Thank you Larry, right before you posted this reply I found another thread that mentioned using args.set() with dim args as sql::Arguments which I had some time to play with and turned out to work just fine.

I didnt know you could inject javascript into the xbasic command, Thank you for the e.javascript = "alert('Record Update Error');" I will put that in and see where I end up.

- Ivan