Window kill

[dkolbach]

I have a form with a link field that call a dialog on a new window. How can i kill the window if a variable passed is blank. I know how to test for the variable but all the commands that i put on the initialize section did not work.

[NoeticCC]

Re: Window kill

Javascript seems the obvious answer... although perhaps not even opening the window if the variable isn't set might be a better plan?

[dkolbach]

Re: Window kill

Thanks Andrea, you are correct not opening the window was my first idea but i couldn't find "show/hide" for a link. Is there other field to do that?

[NoeticCC]

Re: Window kill

Thanks Andrea, you are correct not opening the window was my first idea but i couldn't find "show/hide" for a link. Is there other field to do that?

Custom Controls are useful for that... :)

[Steve Wood]

Re: Window kill

if this is a grid, create a calculated field and add it as a link field:

IF that var is not blank then
the url
else
blank
end if

[dkolbach]

Re: Window kill

Thanks guys, i'll try the suggestions.

[dkolbach]

Re: Window kill

Andrea, Steve:
I'm working on a grid and using MySql. I created the field to link on the select statement (" " as LinkUpload). I grabbed that field and made a link. I used address type as Calculated from other fields on the grid, which makes sense (I want to go to the link if Grower is "") but the Link Address section does not allow me to add any kind of code.
I probably missing something, where do you suggest i enter the code for testing the blank field?

Sorry for bothering you, i'm new but learning fast.

[Steve Wood]

Re: Window kill

I wasn't too clear. Here is an example.

Calculated field expression:

myurl = if(Regstatus="ACTIVE","http://www.sqst.com","")

Add field as a link. Display Vaue in Field. Field Value is Link Address.

So if my field named regstatus is the word "ACTIVE", the URL will show as a link. If not, no link will show at all. See attached image.

[dkolbach]

Re: Window kill

Steve, I think the sample you sent is based on Alpha database. I'm using MySql and as far as I know I can't up IF statments on the sql builder (as soon as say OK strips the IFs and THENs out) The other problem is i need to send two parameters when I call the new page.
Do you think this is possible, may be will be easier to try to kill the new window if the parameters are empty.

Thanks again

[Steve Wood]

Re: Window kill

Don't know about sql. Causing the window to just close is bad form. Better if you add xbasic on the target page that causes all components to disappear, and a simple message appear saying "Nothing to do, click here to return to xyz".

Making the components disappear and replaced with a message is easy.

You put xbasic above the first component that says:

IF the parameters are blank THEN
display this text and a link back to the previous page
ELSE

Then below the last component, put an xbasic block with simply:

END IF

That is, it's OK to break up the xbasic in to two blocks of code like this.

[dkolbach]

Re: Window kill

That is clever. It is simple.

Thanks

[Steve Wood]

Re: Window kill

You would never be able to effectively accomplish the kill window concept anyway. Browsers don't work the same way, and don't allow you to just close a window without some fussing with the differences between browsers.

[NoeticCC]

Re: Window kill

Andrea, Steve:
I'm working on a grid and using MySql. I created the field to link on the select statement (" " as LinkUpload). I grabbed that field and made a link. I used address type as Calculated from other fields on the grid, which makes sense (I want to go to the link if Grower is "") but the Link Address section does not allow me to add any kind of code.

You can't format calc fields in mySQL grids the same as DBF grids...

Which is why I (admittedly because I didn't think of the fact you can define calc fields in DBF grids!) suggested a custom control...

I found them hugely confuddling at first but now rely on them a lot - you'd put this in the definition (replace the names of the fields as needed):

Dim HasVal as c
HasVal = Data.VALCHECKFIELD

'Write Xbasic code here that returns the HTML to be displayed by this control
If HasVal = "" then
    LINKFIELD_NAME_render = ""
Else
    LINKFIELD_NAME_render = "<a target='_new' href='test.aw?value="+HasVal+"'>Click here</a>"
end if

[dkolbach]

Re: Window kill

Thanks Andrea, I'll try your suggestion. Let you know.

Daniel