Loading a SQL_TINYINT field always returns a 0

[wrh00000]

Hello

Relatively new to QlikView so hoping not too stupid a question!

I'm Loading data into QlikView from sage 50 accounts program using a ODBC driver. It all works well apart from one field:

The field in sage is called RECORD_DELETED with a  Data Type:  SQL_TINYINT (-6) and its a flag denoting if the record has been deleted or not. (When deleted sage doesn't remove the record, just marks it as deleted)

However after loading all values are shown as 0, when some should definitely flag as deleted. I would have expected some to be a 1 or -1?

Any ideas? Does this type of data need to be loaded differently?

I've tried:

Num(RECORD_DELETED) as SOP_RECORD_DELETED 

Text(RECORD_DELETED) as SOP_RECORD_DELETED 

Both return the same 0 for all records

Thanks in advance.

[Chanty4u]

if your connected to ODBC.. i think it is required.

https://www.oracle.com/technetwork/database/windows/odbcfaq-128251.pdf

[Brett_Bleess]

@wrh00000 I would venture the poster is on the right track with ensuring the DB Connector can handle that data type properly, as generally that is where the issue lies in situations like this.  

I would suspect just reading the field without trying to change things and using an IF statement to check the values to determine what to populate things would be the best way to approach this, but rather difficult to say for sure with you having provided no sample data etc.  My best hunch would be this is an issue related to the DB driver though, try doing the same thing using Excel etc. and see if you have the same issue there, as if so, that will confirm the DB Driver is the issue, then you at least know where to go looking at that point.  If that works though, a small sample of data etc. would be helpful to try to see what else may be going on here.  Sorry I could not find anything else that might be helpful at the moment.

Regards,
Brett