ODBC connection to MAS90 tables

[pchanna1]

My company uses some numeric and some non-numeric PO numbers. I am trying to extract a range of the numeric POs without getting the non-numeric ones. The problem is that anytime I use the Number() function in the WHERE clause, I get an error (ERROR [S0000] [ProvideX][ODBC Driver]Internal error).

I can execute the following query without any problem:

SELECT { fn Number(PO1_PurchaseOrderEntryHeader.PurchaseOrderNumber) } FROM PO1_PurchaseOrderEntryHeader

But if I try to use the same function in the WHERE clause, I get the error.

SELECT { fn Number(PO1_PurchaseOrderEntryHeader.PurchaseOrderNumber) } FROM PO1_PurchaseOrderEntryHeader WHERE { fn Number(PO1_PurchaseOrderEntryHeader.PurchaseOrderNumber) } Between 10009 And 10014

Can anyone tell me what I am doing wrong?

Thanks

 

[BigLouie]

Which application are you using? Generally it is better to use a simple query on the MAS tables and then use a more complex query on that query.

 

[pchanna1]

I am using VB.net to extract the data.

 

[gbaughma]

I don't think it likes the "BETWEEN" thing.

The ODBC implementation of MAS90 is... well... limited, at best.



Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

http://parallel.tzo.com