Re: Database Character Columns Longer than 255 Characters
Microsoft stopped support for its dblib based interface, which was used for
the MSS native interface from PB. In new versions of PB, the driver used for
SQL 2000 is OLE DB. I don't think PB 6.5 had that driver available, so you
could try ODBC.
I would recommend upgrading to a newer version of PowerBuilder since PB 6.5
is no longer a supported version.
From: Adebolade@mtnnigeria.net [mailto:Adebolade@mtnnigeria.net]
Subject: Database Character Columns Longer than 255 Characters
I use Powerbuilder 6.5 with SQL Se...Unrecognized character
I'm have a big problem. I make a module(pm) and now i
want compile this module. I tried use the perlcc but i
receive the msg that the module can't be compiled
because have shared libs.
However i found a module, PAR(Perl Archive Toolkit)
which can compile my module. Then, i was to install
this module(PAR). After the instalation of module i
run the command:
$ pp -o compiled.pm -M Exporter module.pm
ps.: The module.pm just require the lib Exporter.
I not have problems with the compilation. Then the
next step would be execute a script (CGI) that use the
compile...When is a column not a column?
I have several extremely similar datawindows that I have to maintain that go
against the same table. Recently, I had to add a column to that table, and
also add the column to ALL of these datawindows that go against this table.
I added the column to the first datawindow, set up the edit control style,
etc. I then did a copy/paste of the columns edit control to the remaining
dw's (of course remembering to first add the column in SQL). Everything
(update props, column specs, column props) seems to indicate that the pasted
column is linked to the column I selected, HOWEVER, when I...Unicoded CSV supports chinese characters but excell shows all columns in a single column (may be an excell unicode csv issue)
so i have the unicoded CSV that supports chinese but excel doesn't like it, it put all the columns into a single columns. Any though?
Response.ContentEncoding = Encoding.Unicode;Response.Charset = "Unicode";
Response.AddHeader("Content-Type", "text/csv");Response.AddHeader("Content-Disposition", "inline;filename=consultantList.csv");Response.BinaryWrite(Encoding.Unicode.GetPreamble());
Response.End();...Thank you, perl5 porters!
I am happy to report that bleadperl 16147 has built successfully on VOS and
has passed all of its tests. There is only one local patch, to vos.c, which
is already in the repository but not in this snapshot. I may yet find more
things to change, but this is an important milestone to me; this is the
first time I've passed all of the tests on the first try.
A thousand thanks to everyone who has assisted me in the effort to get perl
5.7 ported to the Stratus VOS operating system. I started working on this
effort last October. If I had known how long it would take, or...this decade on perl5-porters
As a side effect of something else, I found myself digging around in the
archives of Perl5-Porters from quite a long time ago.
For example, take a look at the archives from 10 years ago:
Several names you see there are still active today, and others are still in
contact, which is nice.
Although I was surprised to discover that Jarkko had a different .sig back
...last character in the column
How can I know the last character typed in a column of a datawindow , as I
need to wrap it to the next time .
Autoheight does not works for the same
Try using the Right ( string, n ) String function within either ItemChanged
or EditChanged event, or maybe a compute in the dw.
"Van" <VanJacobson@hotmail.com> escribi� en el mensaje
> How can I know the last character typed in a column of a datawindow , as
> I need to wrap it to the next time .
> Autoheight does not works fo...This week on Perl5-porters
[Apologies for the unannounced leave of absence: the conference had
me very busy. - SC]
The HTML version will be up in a few hours (if it isn't already) at
The current report is always available at
An RSS file of this week's report will be available at
The current RSS file is always available at
The archive of past reports:
...where is the perl5-porters FAQ ?
there is link to the perl5-porters FAQ at
which does not exist any more.
Sending e-mail to firstname.lastname@example.org still works
so I have the document now but it would be good to update
the link on that site.
email@example.com (Gabor Szabo) writes:
> there is link to the perl5-porters FAQ at
> which does not exist any more.
You could mail me about i...Text column character limit ?
This is a multi-part message in MIME format.
PB 9.0.2 Build 7578
I have a simple datawindow column mapped to a sqlserver 2000 text =
column set to use only a vertical scrollbar with no edit mask. It is =
basically a notes field. =20
I have the Column Specification for that column set to char(32766) as it =
was used in legacy via ODBC and that seemed to be a limit back then. =
Now using OLEDB. =20
I have the Edit limit set to 3200...Pasting from Word
When a user pastes text from a Word document that contains an apostrophe or double quote (and possibly other special characters), they are NOT the normal apostrophe or double quote.
normal apostrophe: '
Word pasted apostrophe: ‘
normal double quote: "
Word pasted apostrophe: “
What can I do to convert these characters to something I can insert into my database, then read back out again? Right now, Oracle is converting them to upside down question marks and then they display as boxes in HTML.The aim of an argument or discussion should not be victory, but prog...PB10
I just started playing with the eval version of PB10, using Microsoft SQL
Server 2000 with OLEDB. I've noticed that all character strings are missing
their last character when they are retrieved from the database. This only
happens at runtime; it works fine in the DB painter and the DW painter.
For example, a char(4) column with a value of CUST is retrieved as CUS.
This also happens with varchar columns.
Is this a bug, or is there something that I need to change in my DB
connection parameters? I'm using the same parameters that worked for PB9:
PROVIDER='SQLOLEDB'...Column name begins with character %
I have a Microsoft Access table with a column name that begins with
When I try to make a dw to update that table i have some problems:
- I configure ODBC for put quotes in columns and table names. (Syntax
Tab in Database Profile)
- In the query dw Painter I have to 'Convert to Sintax' for not have
Syntax error 37000. PB translates:
Select "table.column1", "table.%column2" from "table" with
Select "table.column1", table.%column2 from "table"
- In no graphic mode (convert t...