excel vba - Vba- Query table limit for database table with a column having data type as nvarchar(5000) -


i have excel application button click connects hana database using hana client (hdbodbc) , put data in sheet after fetch. method working fine except tables having column data type nvarchar(5000). in case, column values not displaying correctly. example, have unique id auto increment column, starts showing 0 many rows. below method using -

function importroutine(sheet string, provider string, databaseschema string, server string, app string, row long, column long, commandtext string, displayname string, errorflag boolean) integer     debug.print commandtext     dim l querytable     dim rs object     dim cnt adodb.connection     dim cmd adodb.command     dim icols integer     set cnt = new adodb.connection     set cmd = new adodb.command     set rcd = new adodb.recordset  dim rangesheet string rangesheet = sheets(sheet).cells(row + 1, column).address dim connectionsheet string connectionsheet = "driver=" + provider + ";servernode=" + server + ";" + getauthentication + "; cs=" + databaseschema + ""  cnt.connectionstring = connectionsheet cnt.open  set cmd.activeconnection = cnt cmd.commandtext = commandtext cmd.commandtype = adcmdtext      rcd.open commandtext, cnt '', adopenstatic   set rs = createobject("adodb.recordset") rs.activeconnection = cnt rs.open commandtext, cnt   sheets(sheet).listobjects.add(sourcetype:=3, source:=rs, destination:=range(sheets(sheet).cells(row, column).address)).querytable     '.commandtext = commandtext     '.commandtype = xlcmdsql     .rownumbers = false     .filladjacentformulas = false     .preserveformatting = true     .refreshonfileopen = false     .backgroundquery = true     .refreshstyle = xlinsertdeletecell     .savepassword = false    .savedata = true     .adjustcolumnwidth = false     .refreshperiod = 0     .listobject.name = displayname     .preservecolumninfo = false     on error resume next     .refresh backgroundquery:=false end     sheets(sheet).listobjects(displayname).tablestyle = "tablestylemedium10" importroutine = 0 call deleteconnection   closerecordset: rs.close set rs = nothing closeconnection: cnt.close set cnt = nothing  on error goto 0     end function

the interesting part nvarchar limit different different excel version. excel 2010 - 500 excel - 2013- 3000 excel - 2016 - 4000 question is there limit on number of characters column in vba query tables each excel versions ? or there can change resolve ?

this how data appearing. can check unique_id identity column in database showing 0 many rows although in database fine.

enter image description here


Comments

Post a Comment

Popular posts from this blog

javascript - Clear button on addentry page doesn't work -

this addentry blog page have made scratch , there underlying problems code particularly clear button supposed clear text entered when button clicked on doesn't work have saved html file problem. also 1 other problem submit button works doesn't pass of text index file have written php , reason whenever click on submit button redirects me index page without posting entry have made. <!doctype html> <html> <head> <script> function message() { alert("clear form?"); } </script> <style> body {background-color: beige;} h1 {color: black;} p {color: black;} textarea { width: 50%; height: 150px; padding: 12px 20px; box-sizing: border-box; border: 2px solid #ccc; border-radius: 4px; background-color: white; font-size: 16px; resize: none; } div { padding-left: 20px; } </style> </head> <meta charset="utf-8"> <link rel="stylesheet" href=".
Read more

c# - Selenium Authentication Popup preventing driver close or quit -

i have selenium automated task setup login website retrieve information. it's basic in automation. logging in , clicking 2 links. running issue proving problem. the site in question uses authentication required popup not javascript popup rather regular windows auth popup. have read isn't handled out of box selenium. i using " http://username:password@url.com " site every , site has issues on end prompt me again username/password randomly. have enter username/password twice in row when navigating there hand. since task loops continuously few hours picking needed info figured use webdriverwait verify element present on page. if authentication popup appears, element isn't present. no need care run, start over. the problem having when authentication popup displayed , hit timeout limit want close driver/browser window can start task on again. however, driver.close() , driver.quit() not doing anything. browser remains open , unloaded page still there login p
Read more

tensorflow when input_data MNIST_data , zlib.error: Error -3 while decompressing: invalid block type -

i'm geting started tensorflow,followed tutorials,but cannot download mnist data. import tensorflow tf tensorflow.examples.tutorials.mnist import input_data mnist=input_data.read_data_sets("mnist_data/",one_hot=true) print("download done!") error information: extracting mnist_data/train-images-idx3-ubyte.gz traceback (most recent call last): file "/home/sj/program/tesorflow_try.py", line 6, in <module> mnist=input_data.read_data_sets("mnist_data/",one_hot=true) file "/usr/local/lib/python2.7/dist-packages/tensorflow/contrib/learn/python/learn/datasets/mnist.py", line 213, in read_data_sets train_images = extract_images(f) file "/usr/local/lib/python2.7/dist-packages/tensorflow/contrib/learn/python/learn/datasets/mnist.py", line 60, in extract_images buf = bytestream.read(rows * cols * num_images) file "/usr/lib/python2.7/gzip.py", line 268, in read self._read(readsize) file
Read more