Normal Topic [Solved] Blank error message (Read 1027 times)
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
[Solved] Blank error message
Sep 14th, 2007 at 4:22pm
Print Post Print Post  
User creating @MsgBox with a blank message due to conditional programming.

I swear I didn't program this:
http://www.jamiara.com/helpful.jpg

I don't know what will happen when I click the OK button, but from the exclamation point it's sure to be exciting!
« Last Edit: Sep 16th, 2007 at 1:06am by Hammer »  

**
Captain Infinity
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Now THAT's helpful!
Reply #1 - Sep 14th, 2007 at 4:47pm
Print Post Print Post  
What did you do that made that appear?
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: Blank error message
Reply #2 - Sep 14th, 2007 at 4:55pm
Print Post Print Post  
I put a Workorder number in the Workorder Number field of a new Invoice and hit enter.  With that change the program performs a large number of XLookups into my Workorder database to retrieve the billing information.  It got as far as filling the customer info, and then the blank error message popped up.  After I clicked OK, the rest of the routine completed without incident.  And there was much rejoicing.
  

**
Captain Infinity
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Blank error message
Reply #3 - Sep 14th, 2007 at 5:26pm
Print Post Print Post  
Scott,

That picture looks an awful lot like what @MsgBox pops up. Are you sure you aren't calling @MsgBox in such a way that the message text can be empty?
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: Blank error message
Reply #4 - Sep 14th, 2007 at 5:32pm
Print Post Print Post  
Well, I'll double check all my message box programming, but I'm 99.999999% sure I've never programmed a msgbox without a msg.
  

**
Captain Infinity
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Blank error message
Reply #5 - Sep 14th, 2007 at 5:55pm
Print Post Print Post  
Scott, do you have touch screen?

Could this be a braille message?

  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Blank error message
Reply #6 - Sep 14th, 2007 at 6:09pm
Print Post Print Post  
Infinity wrote on Sep 14th, 2007 at 5:32pm:
Well, I'll double check all my message box programming, but I'm 99.999999% sure I've never programmed a msgbox without a msg.


Yes, but if you use a field or variable that can be empty as the message text, you can get this result.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: Blank error message
Reply #7 - Sep 14th, 2007 at 8:38pm
Print Post Print Post  
That I am certain I have never done.
  

**
Captain Infinity
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Blank error message
Reply #8 - Sep 14th, 2007 at 8:39pm
Print Post Print Post  
Do you have a line that reads

Code
Select All
@MsgBox("@Error", "", "") 



or any other line that starts with a @?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: Blank error message
Reply #9 - Sep 15th, 2007 at 3:40pm
Print Post Print Post  
Well, my certainty was misplaced; I do indeed have a MsgBox that displays a variable.  The problem is with the data looked at by this code:
Code
Select All
vBillingNotes = @XLookup(@FN, Bill_To_Code, "CUSTOMER!CODE", "Billing_Notes")
If Not @Error Then
	{
	// Writeln(sExceptionLookupFlag)
	IF NOT sExceptionLookupFlag = Bill_To_Code
	THEN
		{
		@MSGBOX(vBillingNotes, "", "")
		sExceptionLookupFlag = Bill_To_Code
		// Writeln(sExceptionLookupFlag)
		}
	}
// Else WriteLn("Lookup of Billing Notes info Failed") 


This is part of a larger subroutine that looks up billing information, in this case the value in the Billing_Notes field of my customer database.  sExceptionLookupFlag is a static declared at the beginning of my Global code and set to 0 in on-form-entry.  The above code sets it to equal the customer bill-to code once the lookup has run, so that the billing notes message will only display once, or again if the bill to code changes.

The problem is that recently a number of customer's billing notes were deleted, when my Rigging dispatcher told me he knew the details of certain customers by heart and did not need the message popping up each time he billed them.  But!  For those customers who once had details which have now been deleted, this empty @MsgBox pops up.  For customers with valid billing notes it pops up with those notes displayed.  For customers who never had billing notes, it does not pop up at all because the lookup returns with an error, and IF @ERROR prevents the display.

So It seems like I have a 3 state set which I have to check for before allowing this box to pop up.  I'll have to experiment with this.

Thanks for the pointers, Erika and Ray, which helped me track this down.
  

**
Captain Infinity
Back to top
IP Logged