Hi,

I am using the ODBC to pull transaction history and can pull all of it. However this takes
a bit of time and I really need to only pull certain dates. When trying to use the WHERE
condition, I get the odd error of

[Softrak Systems][SQLEngine] (31750) Column not found: 20180412

Which is the date of my query that I am looking for.

Here is the query string

SELECT Code, Item, TrxDateCode, Detail ,Reference,TrxDate,StockQty,SaleAmt,ExtCost FROM ICTransactionHistory__an92ahaj WHERE ICTransactionHistory__an92ahaj.TrxDateCode="20180412"


Can anyone tell my why this does not work?

Thanks!
Brian

Never Mind. TrxDateCode is a number not a string.... .DOH!

Sometimes I would explain to my Mom why some piece of code could not possibly be doing what it was doing. Usually the problem became apparent pretty quickly!

Glad you're back on track.