Linking Databases in Designer 2019

Software technical issues not related to any of the other categories

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
1dwinter
Newcomer
Posts: 1
Joined: Sat Feb 09, 2019 10:59 am

Linking Databases in Designer 2019

Post by 1dwinter » Sat Feb 09, 2019 2:31 pm

Hi

I have setup 2 databases with item data. One is a SQL table and the other is from an excel sheet.

The SQL table contains "Item_no", "Description" & "Qty", The Excel table contains the "Item_no" & "Barcode".
Is there a way that i can link the databases together via the "Item_no"?

User avatar
dado
NiceLabel Development
NiceLabel Development
Posts: 687
Joined: Tue Sep 12, 2006 12:50 pm
Location: Kranj, Slovenia
Contact:

Re: Linking Databases in Designer 2019

Post by dado » Mon Feb 11, 2019 7:12 am

Yes it is possible.

You need to open the Data Menu / Dynamic Data Manager
Now select your SQL Table in the left part of the dialog
On the right side select Filter and Enable it.
Select which field you want (Item_no in your case)
And select the compare sign =
And on the right side select the Excel field called Item_no
JoinedConnection.png
JoinedConnection.png (68.98 KiB) Viewed 1955 times
I have a sample for you. But first you'll need to create on your local SQL Express server (if you have one) a database called TEST and in that database a table called Test1.

Code: Select all

CREATE TABLE [dbo].[Test1](
	[Item_no] [int] NULL,
	[Description] [nchar](50) NULL,
	[Qty] [int] NULL
) ON [PRIMARY]
GO
Then just download the NiceLabel solution and the .xlsx file and place then in the c:\tmp\ folder
Open the sample and you'll see that the connection between excel and sql on the field Item_no works.
tmp.zip
(11.15 KiB) Downloaded 109 times
Regards, Damjan

Post Reply