Navision native database C/ODBC WHERE-clause

subzero

Hello,

I am currently working on a project to generate EAN13-type barcodes for our products.

I am using the C/ODBC driver to access our native Navision database server (v3.70).

I've run into a problem though. I cannot figure how to write a proper WHERE-clause, that the C/ODBC driver will accept.

I have tried to write it like:
SELECT * FROM "Stregkode opsætning" WHERE Nummer = 100
and
SELECT * FROM "Stregkode opsætning" WHERE Nummer = "100"
and
SELECT * FROM "Stregkode opsætning" WHERE "Nummer" = "100"

the query string works fine without the WHERE-clause.

How can I write this properly?

- Thanks in advance

Best Regards
Kenneth Fuglsang

boby

Hello,
try to make your query in excel and copy the sql statement from MSquery..
I should work

fb

Did you try this?

SELECT * FROM "Stregkode opsætning" WHERE Nummer = '100'