BAM .p (6.1) issue

Yahoo Archive
1
Hi,

I think if it just a checkbox then it should be just true and
not 'true'.



--- In vantage@yahoogroups.com, "Bruce Butler" <bbutler@...> wrote:
>
> Below is a sample of some simple code I have for a sales
notification.
> I seem to be having an issue with my checkbox. How does the
procedure
> editor deal with checkboxes? Is it 'yes', 'true', 't', etc..?
>
>
>
>
>
> {I:\mfgsys61\ud\GlbAlert.i &TableName = "QuoteDtl"}
>
>
>
> FIND Mfgsys.Part WHERE (Mfgsys.Part.Company =
> Mfgsys.QuoteDtl.Company) AND
>
> (Mfgsys.Part.PartNum =
> Mfgsys.QuoteDtl.PartNum) NO-LOCK NO-ERROR.
>
> IF not avail Mfgsys.Part then return "CANCEL SEND":U.
>
>
>
> If (Part.CheckBox01 = 'True') Then Do:
>
> Message QuoteDtl.PartNum + " This item is on
> hold for " + Part.Character01 + " as of " + Part.Date01 View-as
> alert-box information buttons ok.
>
>
>
> END.
>
>
>
> Return "Cancel Send":U.
>
>
>
>
>
> Return.
>
>
>
>
>
> Thanks,
>
>
>
> Bruce Butler, IT Manager
>
> Knappe & Koester, Inc. <http://www.knappe-koester.com>
>
> 18 Bradco Street
>
> Keene, NH
>
> p. 603-355-1166
>
> f. 603-355-2266
>
> bbutler@...
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
Below is a sample of some simple code I have for a sales notification.
I seem to be having an issue with my checkbox. How does the procedure
editor deal with checkboxes? Is it 'yes', 'true', 't', etc..?





{I:\mfgsys61\ud\GlbAlert.i &TableName = "QuoteDtl"}



FIND Mfgsys.Part WHERE (Mfgsys.Part.Company =
Mfgsys.QuoteDtl.Company) AND

(Mfgsys.Part.PartNum =
Mfgsys.QuoteDtl.PartNum) NO-LOCK NO-ERROR.

IF not avail Mfgsys.Part then return "CANCEL SEND":U.



If (Part.CheckBox01 = 'True') Then Do:

Message QuoteDtl.PartNum + " This item is on
hold for " + Part.Character01 + " as of " + Part.Date01 View-as
alert-box information buttons ok.



END.



Return "Cancel Send":U.





Return.





Thanks,



Bruce Butler, IT Manager

Knappe & Koester, Inc. <http://www.knappe-koester.com>

18 Bradco Street

Keene, NH

p. 603-355-1166

f. 603-355-2266

bbutler@...





[Non-text portions of this message have been removed]
3
It might be because you have the ' around True. I looked up one of my
logical checks and I don't have the apostrophe:



if (OrderHed.CreditOverride = True )



Once you've added the checkbox to your vb form, you can use the data
dictionary viewer to verify the format of the data stored.



Butch



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bruce Butler
Sent: Tuesday, January 09, 2007 11:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM .p (6.1) issue



Below is a sample of some simple code I have for a sales notification.
I seem to be having an issue with my checkbox. How does the procedure
editor deal with checkboxes? Is it 'yes', 'true', 't', etc..?

{I:\mfgsys61\ud\GlbAlert.i &TableName = "QuoteDtl"}

FIND Mfgsys.Part WHERE (Mfgsys.Part.Company =
Mfgsys.QuoteDtl.Company) AND

(Mfgsys.Part.PartNum =
Mfgsys.QuoteDtl.PartNum) NO-LOCK NO-ERROR.

IF not avail Mfgsys.Part then return "CANCEL SEND":U.

If (Part.CheckBox01 = 'True') Then Do:

Message QuoteDtl.PartNum + " This item is on
hold for " + Part.Character01 + " as of " + Part.Date01 View-as
alert-box information buttons ok.

END.

Return "Cancel Send":U.

Return.

Thanks,

Bruce Butler, IT Manager

Knappe & Koester, Inc. <http://www.knappe-koester.com
<http://www.knappe-koester.com> >

18 Bradco Street

Keene, NH

p. 603-355-1166

f. 603-355-2266

bbutler@... <mailto:bbutler%40knappe-koester.com>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
4
Thanks Butch, that was it. I did have to convert the table fields to
string vars for it to work.



One more question.... Are there different types of message boxes
available? I would like an error box to stop the processing of the
record.



Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Butch Menge
Sent: Tuesday, January 09, 2007 3:24 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM .p (6.1) issue



It might be because you have the ' around True. I looked up one of my
logical checks and I don't have the apostrophe:

if (OrderHed.CreditOverride = True )

Once you've added the checkbox to your vb form, you can use the data
dictionary viewer to verify the format of the data stored.

Butch

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Bruce Butler
Sent: Tuesday, January 09, 2007 11:39 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAM .p (6.1) issue

Below is a sample of some simple code I have for a sales notification.
I seem to be having an issue with my checkbox. How does the procedure
editor deal with checkboxes? Is it 'yes', 'true', 't', etc..?

{I:\mfgsys61\ud\GlbAlert.i &TableName = "QuoteDtl"}

FIND Mfgsys.Part WHERE (Mfgsys.Part.Company =
Mfgsys.QuoteDtl.Company) AND

(Mfgsys.Part.PartNum =
Mfgsys.QuoteDtl.PartNum) NO-LOCK NO-ERROR.

IF not avail Mfgsys.Part then return "CANCEL SEND":U.

If (Part.CheckBox01 = 'True') Then Do:

Message QuoteDtl.PartNum + " This item is on
hold for " + Part.Character01 + " as of " + Part.Date01 View-as
alert-box information buttons ok.

END.

Return "Cancel Send":U.

Return.

Thanks,

Bruce Butler, IT Manager

Knappe & Koester, Inc. <http://www.knappe-koester.com
<http://www.knappe-koester.com>
<http://www.knappe-koester.com <http://www.knappe-koester.com> > >

18 Bradco Street

Keene, NH

p. 603-355-1166

f. 603-355-2266

bbutler@... <mailto:bbutler%40knappe-koester.com>
<mailto:bbutler%40knappe-koester.com>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]