|
|
|
| Can anyone tell me the best way to retrieve a large string from a
SQLAnyWhere 9.x database? The column is long varchar and has 310000
characters in it.
| |
| Chris Keating \(iAnywhere Solutions\) 2005-04-12, 8:23 pm |
| Depends heavily on where it is being retrieved and whether that environment
is capable of handling a string of that size.
--
Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!
http://www.ianywhere.com/promos/deved/index.html
********************
********************
********************
*****************
iAnywhere Solutions http://www.iAnywhere.com
** Please only post to the newsgroup
** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com
********************
********************
********************
*****************
"Phyl" <phall@kssc.com> wrote in message news:425c60bc$1@foru
ms-1-dub...
> Can anyone tell me the best way to retrieve a large string from a
> SQLAnyWhere 9.x database? The column is long varchar and has 310000
> characters in it.
>
| |
|
| We're using PowerBuilder 9 and since the datawindow seemed to truncate the
string at around 200k characters, we hoped it was possible to use embedded
SQL.
"Chris Keating (iAnywhere Solutions)" < FightSpam_keating@iA
nywhere.com>
wrote in message news:425c639a$1@foru
ms-1-dub...
> Depends heavily on where it is being retrieved and whether that
> environment is capable of handling a string of that size.
>
>
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> ********************
********************
********************
*****************
> Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
> and try out the market-leading database for mobile, embedded and small to
> medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
> ********************
********************
********************
*****************
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
> ********************
********************
********************
*****************
>
> "Phyl" <phall@kssc.com> wrote in message news:425c60bc$1@foru
ms-1-dub...
>
>
| |
| Chris Keating \(iAnywhere Solutions\) 2005-04-13, 9:23 am |
| PB requires SELECTBLOB for this processing. The datawindow is not able to
handle a string of that size nor will standard EMBEDDED SQL statements in
PB.
"Phyl" <phall@kssc.com> wrote in message news:425cf37d@forums
-1-dub...
> We're using PowerBuilder 9 and since the datawindow seemed to truncate the
> string at around 200k characters, we hoped it was possible to use embedded
> SQL.
>
>
> "Chris Keating (iAnywhere Solutions)" < FightSpam_keating@iA
nywhere.com>
> wrote in message news:425c639a$1@foru
ms-1-dub...
>
>
|
|
|
|