Rb-filter issue

system · December 13, 2004, 11:03am

THANKS!!

That was it!
Jasper

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, December 13, 2004 10:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] rb-filter issue

Jasper,
Just a quick look indicates a missing " " before the AND statement.
" AND QuoteDtl.QuoteLine = " + string(QLine).
Hope that's it.
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, December 13, 2004 9:25 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] rb-filter issue

Good morning all,

I have this procedure that keeps giving me this error:

RB-FITER has an error at offset 20: unrecognized name or operator

My procedure is below. If my rb-filter-value has only one filter
requirement in it, it works great. As soon as I add another filter
requirement I get that error.

Any ideas?
Thanks,
Jasper

****************************************
{v:/mfgsys61/vbp/vb.i}

DEF VAR rb-filter-value as CHARACTER initial "".
DEF VAR QNum AS INTEGER initial "".
DEF VAR QLine AS INTEGER initial "".

FIND QuoteDtl WHERE ROWID(QuoteDtl) = GetCurrentRowID() NO-LOCK.
QNum = QuoteDtl.QuoteNum.
QLine = QuoteDtl.QuoteLine.

rb-filter-value = "QuoteDtl.QuoteNum = " + string(QNum) +
"AND QuoteDtl.QuoteLine = " + string(QLine).

run aderb\_printrb( etc........
****************************************

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links

system · December 13, 2004, 9:25am

Good morning all,

I have this procedure that keeps giving me this error:

RB-FITER has an error at offset 20: unrecognized name or operator

My procedure is below. If my rb-filter-value has only one filter requirement in it, it works great. As soon as I add another filter requirement I get that error.

Any ideas?
Thanks,
Jasper

****************************************
{v:/mfgsys61/vbp/vb.i}

DEF VAR rb-filter-value as CHARACTER initial "".
DEF VAR QNum AS INTEGER initial "".
DEF VAR QLine AS INTEGER initial "".

FIND QuoteDtl WHERE ROWID(QuoteDtl) = GetCurrentRowID() NO-LOCK.
QNum = QuoteDtl.QuoteNum.
QLine = QuoteDtl.QuoteLine.

rb-filter-value = "QuoteDtl.QuoteNum = " + string(QNum) +
"AND QuoteDtl.QuoteLine = " + string(QLine).

run aderb\_printrb( etc........
****************************************

system · December 13, 2004, 10:27am

Jasper,
Just a quick look indicates a missing " " before the AND statement.
" AND QuoteDtl.QuoteLine = " + string(QLine).
Hope that's it.
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, December 13, 2004 9:25 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] rb-filter issue

Good morning all,

I have this procedure that keeps giving me this error:

RB-FITER has an error at offset 20: unrecognized name or operator

My procedure is below. If my rb-filter-value has only one filter
requirement in it, it works great. As soon as I add another filter
requirement I get that error.

Any ideas?
Thanks,
Jasper

****************************************
{v:/mfgsys61/vbp/vb.i}

DEF VAR rb-filter-value as CHARACTER initial "".
DEF VAR QNum AS INTEGER initial "".
DEF VAR QLine AS INTEGER initial "".

FIND QuoteDtl WHERE ROWID(QuoteDtl) = GetCurrentRowID() NO-LOCK.
QNum = QuoteDtl.QuoteNum.
QLine = QuoteDtl.QuoteLine.

rb-filter-value = "QuoteDtl.QuoteNum = " + string(QNum) +
"AND QuoteDtl.QuoteLine = " + string(QLine).

run aderb\_printrb( etc........
****************************************

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links