for datatype var char no result size

Report PGNP bugs.

for datatype var char no result size

Postby SF » Wed Mar 19, 2014 3:19 pm

for datatype varchar always returns 4 instead of the maximum number of characters!!!
SF
 
Posts: 2
Joined: Wed Mar 19, 2014 3:13 pm

Re: for datatype var char no result size

Postby Moderator » Wed Mar 19, 2014 9:40 pm

Would you e-mail to Support the table DDL and query that can be used to reproduce the issue?

Thank you!
User avatar
Moderator
Site Admin
 
Posts: 302
Joined: Wed Oct 29, 2008 11:27 pm

Re: for datatype var char no result size

Postby SF » Fri Mar 21, 2014 1:37 am

//table is very simple
CREATE TABLE adresy_dost
(
key_id serial NOT NULL,
kontrah character varying(20) DEFAULT ''::character varying,
id_kontrah integer,
adres character varying(200) DEFAULT ''::character varying,
adres_full character varying(255) DEFAULT ''::character varying,
CONSTRAINT adresy_dost_pkey PRIMARY KEY (key_id)
)

// for all vatchar return size of field = 4
// insted of 21 for field ''kontrah''
// 201 for field ''adres''

I used MSADO and there it works correctly. I wanted to change for Postgres but it will not let me. I need this to control how many max characters user can type in the application desktop.
SF
 
Posts: 2
Joined: Wed Mar 19, 2014 3:13 pm

Re: for datatype var char no result size

Postby Moderator » Sat Mar 22, 2014 1:29 pm

What version of the PGNP Provider are you using? I have not been able to reproduce the issue with the latest build.

The provider returns columns schema, columns information, and columns rowset from result, with all sizes correctly.
User avatar
Moderator
Site Admin
 
Posts: 302
Joined: Wed Oct 29, 2008 11:27 pm


Return to Report Bugs

Who is online

Users browsing this forum: hxdrbunctsyw and 1 guest

cron