Question Re: Selecting SQL server varchar(max) into datawindow? in Technology Q&A

Selecting SQL server varchar(max) into datawindow?

Former Member — Wed, 11 Jan 2017 19:37:48 GMT

Can you exceed the 32k max for a character column? I've seen reference to select blob... but I'd like an example. 🙂

Thanks

Re: Selecting SQL server varchar(max) into datawindow?

Former Member — Wed, 11 Jan 2017 20:31:09 GMT

Hi Matt;

Have you looked int using the new DW's TableBLOB feature for this that was introduced into the newer PB Versions?

Regards ... Chris

Re: Selecting SQL server varchar(max) into datawindow?

Former Member — Thu, 02 Feb 2017 20:10:31 GMT

Well I handled my situation like this.

I am selecting information from a SQL Server database which has a varchar(max) column. Creating a datawindow in PB converts these into a char(8000). For probably 90% of the time this is sufficient. For the other times I save the data into another table, use a second datastore to select against the same record set but looking for fields where the varchar(max) column exceeds the 8000 limit, then I loop through these records and create a dynamic cursor for each and select the varchar(max) field into a string variable. I then update the corresponding record with the string variable.

Re: Selecting SQL server varchar(max) into datawindow?

Former Member — Tue, 07 Feb 2017 13:56:15 GMT

I believe I have retrieved 1,000,000 chars before, it does slow down though. You can create the datawindow then edit the source and change the length of the field to whatever you want (I think, it's been a while!)