Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

PowerBuilder Bugs?Why the datawindow.importString,Losted data when data contains double quotation marks!

2 posts in General Discussion (Chinese) Last posting was on 2006-08-01 09:13:33.0Z
Robon Posted on 2006-07-31 09:18:54.0Z
Sender: 67b4.44cdc207.1804289383@sybase.com
From: Robon
Newsgroups: sybase.public.chinese.powerbuilder.general
Subject: PowerBuilder Bugs?Why the datawindow.importString,Losted data when data contains double quotation marks!
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44cdc90f.6927.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 31 Jul 2006 02:10:39 -0700, 10.22.241.42
Lines: 30
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 31 Jul 2006 02:10:40 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 31 Jul 2006 02:18:54 -0700
X-Trace: forums-1-dub 1154337534 10.22.108.75 (31 Jul 2006 02:18:54 -0700)
X-Original-Trace: 31 Jul 2006 02:18:54 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.chinese.powerbuilder.general:81
Article PK: 104127

Every one know the datawindow support format of the import
string is:
column1+tab+column2+tab...+columnN+Enter
But when any column data contains double quotation
marks,there are maybe lost some data.
Example:
The import data is :
"111"222 B"111"222
The datawindow has two columns,when import above string into
the datawindow the first column will be 111,
and second column willbe B"111"222 .Obviously,the first
column lost data 222.why the first column lost the data
222?Because the first column begin with double quotation
marks and 222 behind the second double quotation marks.
If add a space to the first column ,there are will not be
lost any data.
How about this:"111""222"?
The result will be 111"2222!
Also :"111"222"?
The result will be 111 !
And :"111""222?
The result will be 111"222 !


I don't know How the Importstring function parse the
imported string?
Also you can test this create a table only one column and
using import row.

ALL testing with Version 9.0.1 Build 7066


ZhongCanJun Posted on 2006-08-01 09:13:33.0Z
From: "ZhongCanJun" <pb_zj@163.com>
Newsgroups: sybase.public.chinese.powerbuilder.general
References: <44cdc90f.6927.1681692777@sybase.com>
Subject: Re: PowerBuilder Bugs?Why the datawindow.importString,Losted data when data contains double quotation marks!
Lines: 3
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
X-Original-NNTP-Posting-Host: 211.140.142.194
Message-ID: <44cf194b@forums-2-dub>
X-Original-Trace: 1 Aug 2006 02:05:15 -0700, 211.140.142.194
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 1 Aug 2006 02:05:15 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 1 Aug 2006 02:13:33 -0700
X-Trace: forums-1-dub 1154423613 10.22.108.75 (1 Aug 2006 02:13:33 -0700)
X-Original-Trace: 1 Aug 2006 02:13:33 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.chinese.powerbuilder.general:84
Article PK: 104130

up....