SQL statements variable on *.mdb

Software technical issues not related to any of the other categories

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
MCblogiz
Newcomer
Posts: 2
Joined: Wed Jan 15, 2020 1:00 pm

SQL statements variable on *.mdb

Post by MCblogiz » Wed Jan 15, 2020 1:12 pm

Hi everyone,
few days trying to find correct SQL statement for *.mdb file query.
Found some samples: https://www.nicelabel.com/support/knowl ... statements but no success maybe in case of using access DB instead of MS SQL Server.

Code: Select all

SELECT :variable FROM Augalai1 WHERE IDindexBK = 1;
Any thoughts?

User avatar
Kyleodonnell
NiceLabel Support
NiceLabel Support
Posts: 511
Joined: Mon Aug 28, 2017 3:07 pm

Re: SQL statements variable on *.mdb

Post by Kyleodonnell » Wed Jan 15, 2020 2:04 pm

MCblogiz,

Are you trying do a variable query? or simply just a query, if you wanted do variable query you would need to follow the steps exactly as the article states and run it through VB or python or you would use powerforms and do an execute sql statement on a button or event

User avatar
Saso
NiceLabel
NiceLabel
Posts: 2977
Joined: Mon Sep 04, 2006 8:09 am
Contact:

Re: SQL statements variable on *.mdb

Post by Saso » Wed Jan 15, 2020 2:26 pm

The EXEC() statement used in the KB article is not supported for queries inside Microsoft Access. You need Microsoft SQL server.
Saso Fleiser
Senior Technical Product Specialist

MCblogiz
Newcomer
Posts: 2
Joined: Wed Jan 15, 2020 1:00 pm

Re: SQL statements variable on *.mdb

Post by MCblogiz » Wed Jan 15, 2020 2:56 pm

Saso wrote:
Wed Jan 15, 2020 2:26 pm
The EXEC() statement used in the KB article is not supported for queries inside Microsoft Access. You need Microsoft SQL server.
Is it any way to use variables on *.mdb (access db) files?

Post Reply