+1 800 256 3608 (toll-free in North America) or +49 7531 90 60 10| service@combit.com

MS SQL and nvarchar


(Ron Russo) #1

I develop with dBase Plus and MS SQL 2012 using ADO.
My database has many nvarchar columns in the various tables, but L&L20 is giving an error when I include any of these in the queries. It seems happier with varchar columns.
Is there a way around this?


(combit Support - Erdal Alacali) #2

Dear Ron,
thank you for your note.

I would ask you to send more informations about the problem.
-What is the error (Exception, GPF etc.)?
-How you define the data? Do you use any provider?
-Have installed the most recent service pack for List & Label 20?
-Could you share some sample code?

Kind regards

Erdal Alacali
Technical support
combit GmbH


(Ron Russo) #3

Erdal,

Please see the attached screenshots for the error, the data and the provider.
I am using the latest service pack.
Sample code:
cSQL = “select * from CustomerTypes”
SET PROCEDURE TO CustomClasses\LL20.CC ADDITIVE
r = new LL20InterfaceSample()
d = new database()
d.databasename = “BMS”
d.active = true
r.query1 = new QUERY()
r.query1.database = d
r.query1.sql = cSQL
r.query1.active = true
r.rowset = r.query1.rowset
r.query1.parent = r
//Use reportcontainer object to activate gantt-chart
r.ReportContainer = true
r.Design = form.LLDesign
r.Extension = “.REP”
r.Filename = “Reports\CustomerDailyBookings.rep”
r.render()
r.query1.active = false

Error.jpg

Data.jpg

Provider.jpg


(Ron Russo) #4

Hello, I have given up on a solution and have modified my database to only use varchar and char and not nvarchar and nchar.

regards
Ron