does string parameter have a max size of 256 characters?

Visual Basic

    Sponsored Links

    Next

  • 1. Hierarchical option in CR 9 ?
    Dear Sir, I am creating an Accounts Application with the following fields. Acc_Code Parent_ID Description Amount 1 1.1 1 Assets 1.1.1 1.1 Current Assets 1.1.1.1 1.1.1 Receivables 2000 Total Receivables: 2000 Total Current Assets 2000 Total Assets 2000 I need hierarchical totals to show after in group footers. How can I create a group and to which Field ? Any idea please ? Best Regards, Luqman
  • 2. finding groupname by groupnumber ?
    Is it possible to print groupname by groupnumber anywhere in crystal report 8.5 or 9.0 ? something like : groupname(2) to print groupname of groupnumber 2 ? Best Regards, Luqman
  • 3. Multiple Ranking Formulas in Crystal
    Hello! My client needs to have a report showing multiple ranking formulas. They need to compare this year ranking with the previous year ranking. For example: Name | YTD | Previous YTD | YTD Ranking | Privious YTD Ranking Is this possible? Thank you
  • 4. exporting to ms word tables
    l.s. my c# .net application creates some crystal reports. when exporting to word the structure in word only contains text objects. I would like it to export the report as a word document containing tables. Is there any way to accomplish this behaviour automatically?? Should I change something in the report or in the export options?? Or am i faced with writing some word macro that creates a table out of all the text objects? regards, Erald Kulk
  • 5. Anybody has Crystal Report 8 Patch of Runtime API??????
    Hi I am using Crystal Report 8 Runtime API to create reports. When I run it it displays a message to register....... anybody with some registration No or some patch to get rid of it???? Regards, Abdul Mateen

does string parameter have a max size of 256 characters?

Postby Osvaldo Bisignano » Sat, 13 Dec 2003 22:38:08 GMT

This is a multi-part message in MIME format.


I get an ArgumentException when calling 

MyStringParam.ApplyCurrentValues(myDiscreteValue)

I have only created a new string param, do I have to declare its size somewhere? thanks.


this is the Stack:

Source: CrystalDecisions.CrystalReports.Engine
TargetSite:Void d(System.Object, `*)
STACKTRACE:
   at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.d(Object , `* )
   at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.AddCurrentValue(Object value)
   at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.ApplyCurrentValues(ParameterValues currentValue)

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I get an ArgumentException when calling 
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial 
size=2><STRONG>MyStringParam.ApplyCurrentValues(myDiscreteValue)</STRONG></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have only created a new string param, do I have 
to declare its size somewhere? thanks.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>this is the Stack:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#008080 size=2>Source: 
CrystalDecisions.CrystalReports.Engine<BR>TargetSite:Void d(System.Object, 
`*)<BR>STACKTRACE:<BR>   at 
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.d(Object , `* 
)<BR>   at 
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.AddCurrentValue(Object 
value)<BR>   at 
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.ApplyCurrentValues(ParameterValues 
currentValue)</FONT></DIV></BODY></HTML>


Re: does string parameter have a max size of 256 characters?

Postby Bob Holmes » Sun, 14 Dec 2003 01:21:47 GMT

his is a multi-part message in MIME format.


Hi Osvaldo,
It depends on which version of CR you are using. I believe CR9 is the first version that allows longer strings than 254 characters.

Bob Holmes

"Osvaldo Bisignano" < XXXX@XXXXX.COM > wrote in message news: XXXX@XXXXX.COM ...
I get an ArgumentException when calling

MyStringParam.ApplyCurrentValues(myDiscreteValue)

I have only created a new string param, do I have to declare its size somewhere? thanks.


this is the Stack:

Source: CrystalDecisions.CrystalReports.Engine
TargetSite:Void d(System.Object, `*)
STACKTRACE:
at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.d(Object , `* )
at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.AddCurrentValue(Object value)
at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.ApplyCurrentValues(ParameterValues currentValue)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4934.1600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi Osvaldo,    </FONT></DIV>
<DIV><FONT face=Arial size=2>    It depends on which version of
CR you are using.  I believe CR9 is the first version that allows longer
strings than 254 characters.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Bob Holmes</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Osvaldo Bisignano" <<A
href="mailto: XXXX@XXXXX.COM "> XXXX@XXXXX.COM </A>>
wrote in message <A
href="news: XXXX@XXXXX.COM ">news: XXXX@XXXXX.COM </A>...</DIV>
<DIV><FONT face=Arial size=2>I get an ArgumentException when calling
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2><STRONG>MyStringParam.ApplyCurrentValues(myDiscreteValue)</STRONG></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have only created a new string param, do I have
to declare its size somewhere? thanks.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>this is the Stack:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#008080 size=2>Source:
CrystalDecisions.CrystalReports.Engine<BR>TargetSite:Void d(System.Object,
`*)<BR>STACKTRACE:<BR>   at
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.d(Object ,
`* )<BR>   at
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.AddCurrentValue(Object
value)<BR>   at
CrystalDecisions.CrystalReports.Engine.ParameterFie

Re: does string parameter have a max size of 256 characters?

Postby Osvaldo Bisignano » Sun, 14 Dec 2003 04:21:31 GMT

his is a multi-part message in MIME format.


jajaja this is a shame. I can't believe it. Too Much. Do you know if some of thouse "known issues" (read it BIG BUGS) are fixed in subsequent versions?

I have visual Studio 2002, with its corresponding CR version.
I searched for those "hot fixes" (which are "WEEKLY" so every week there's a new problem to solve) but they say it's only for english, japanese and french i think. I have Spanish version. hould I install them anyway or is better to deal forever with these "known bugs"? What do you think? Are there any service packs? Should I buy CR9? How many Known Bugs will I have to fight with?

Regards,
Osvaldo

"Bob Holmes" < XXXX@XXXXX.COM > escribien el mensaje news: XXXX@XXXXX.COM ...
Hi Osvaldo,
It depends on which version of CR you are using. I believe CR9 is the first version that allows longer strings than 254 characters.

Bob Holmes

"Osvaldo Bisignano"<< XXXX@XXXXX.COM >> wrote in message news: XXXX@XXXXX.COM ...
I get an ArgumentException when calling

MyStringParam.ApplyCurrentValues(myDiscreteValue)

I have only created a new string param, do I have to declare its size somewhere? thanks.


this is the Stack:

Source: CrystalDecisions.CrystalReports.Engine
TargetSite:Void d(System.Object, `*)
STACKTRACE:
at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.d(Object , `* )
at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.AddCurrentValue(Object value)
at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.ApplyCurrentValues(ParameterValues currentValue)
< < < < < < <jajaja this is a shame. I can't believe it. Too
Much. Do you know if some of thouse "known issues" (read it BIG BUGS) are fixed
in subsequent versions< < < <I have visual Studio 2002, with its corresponding
CR version.< <I searched for those "hot fixes" (which are
"WEEKLY" so every week there's a new problem to solve) but they say it's only
for english, japanese and french i think. I have Spanish version. hould I
install them anyway or is better to deal forever with these "known bugs"? What
do you think? Are there any service packs? Should I buy CR9? How many Known Bugs
will I have to fight with< < < <Regards< <Osvald< < < <
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px>>
<"Bob Holmes" << href="mailto: XXXX@XXXXX.COM >> XXXX@XXXXX.COM <> escribi
en el mensaj<
href="news: XXXX@XXXXX.COM >">news: XXXX@XXXXX.COM <

Re: does string parameter have a max size of 256 characters?

Postby Osvaldo Bisignano » Sun, 14 Dec 2003 04:24:33 GMT

his is a multi-part message in MIME format.


PS: You don't know how much i miss Access Reports!
"Bob Holmes" < XXXX@XXXXX.COM > escribien el mensaje news: XXXX@XXXXX.COM ...
Hi Osvaldo,
It depends on which version of CR you are using. I believe CR9 is the first version that allows longer strings than 254 characters.

Bob Holmes

"Osvaldo Bisignano"<< XXXX@XXXXX.COM >> wrote in message news: XXXX@XXXXX.COM ...
I get an ArgumentException when calling

MyStringParam.ApplyCurrentValues(myDiscreteValue)

I have only created a new string param, do I have to declare its size somewhere? thanks.


this is the Stack:

Source: CrystalDecisions.CrystalReports.Engine
TargetSite:Void d(System.Object, `*)
STACKTRACE:
at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.d(Object , `* )
at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.AddCurrentValue(Object value)
at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition.ApplyCurrentValues(ParameterValues currentValue)
< < < < < < <PS: You don't know how much i miss Access
Reports< <
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px>>
<"Bob Holmes" << href="mailto: XXXX@XXXXX.COM >> XXXX@XXXXX.COM <> escribi
en el mensaj<
href="news: XXXX@XXXXX.COM >">news: XXXX@XXXXX.COM <l<>A>.<.
< Hi Osvaldo,   <
<     It depends on which version of
CR you are using.  I believe CR9 is the first version that allows longer
strings than 254 character<.
< &nbs<;
< Bob Holm<s
< &nbs<;
<
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0p>">
< "Osvaldo Bisignano" &l<;
href="mailto: XXXX@XXXXX.COM >"> XXXX@XXXXX.COM .<r<>A>>
wrote in messag<
href="news: XXXX@XXXXX.COM >">news: XXXX@XXXXX.COM <l<>A>.<.
< I get an ArgumentException when calling
<
< &nbs<;
< size><>MyStringParam.ApplyCurrentValues(myDiscreteValu<)
< &nbs<;
< I have only created a new string param, do I
have to declare its size somewhere? thank<.
< &nbs<;

Similar Threads:

1.Setting size for a parameter for a varchar(max) field

I am writing an application using VS2008 and SQL Server 2005. I have
code that executes a stored procedure for a table that has a field
which is varchar(max). I usually use code as follows to create and
populate a parameter...

  SQLParam(8) = New System.Data.SqlClient.SqlParameter
  With SQLParam(8)
    .ParameterName = "@LastProcessingResults"
    .DbType = DbType.String
    .Direction = ParameterDirection.Input
    .Size = 1000
    .Value = _LastProcessingResults
  End With

However, obviously, in this case, I don't want to set .Size = 1000.
What do I set .Size equal to for a varchar(max) field? Or, do I leave
out the .Size property altogether?

2.perform action on string that can't be done if no string

"RipperT @comcast.net>" <rippert<nospam> wrote in message
news:% XXXX@XXXXX.COM 
> Hello,
>
> I would like to use a Try Catch block

Then you can't use VB as VB doesn't have Try/Catch


-- 
try asking in a group with "dotnet" in the name; this group is for VB 6.0
and earlier
VB.Net is Not.VB

3.Painting on 256 colors display error

Hi

I've an picturebox and fill this with a brush with a color say
color.skyblue

On a screen with 265 colors (like terminal servers clients have) this
is owfull. However, when i set the background of the picture box to
the same color in IDE the color is ok. 

So there is a different setteing the color at design time or at run
time using a brush.

Is there anothe method to use? 

I'm now using

        Dim NormalBrush As Brush
        NormalBrush = New Drawing2D.LinearGradientBrush(New Point(0,
0), New Point(0, Me.Height), Color.CornflowerBlue,
Color.CornflowerBlue)
        e.Graphics.FillRectangle(NormalBrush, ClientRectangle)

4.Excell vba getting error after searching 256 columns

I am searching a column of data for a string of users input and am
receiving an error after searching 256 rows. Is there a limit on the
worksheet object? If not does anyone have any advice? I can not figure
out why it will not search past 256. Thank you.

Below is my code:

Set rngCasNumberRange = Range("A1:B13242")

intIfCounter = 1

'for loop to loop through column A and search for the first number
entered.
'fill Column D with the number and column E with the code if found
For rwIndex = 1 To 1
    For colIndex = 2 To 13242
        With Worksheets("SortedByCasNumberAndPhrase").Cells(rwIndex,
colIndex)
            If rngCasNumberRange.Cells(colIndex, 1) = strCASNumberOne
Then
            'fill variable with phase code corresponding to the cas
number found
            strPhaseCodeOne = rngCasNumberRange.Cells(colIndex, 2)
            'fill cells with found phrase code numbers
            rngCasNumberRange.Cells((intIfCounter + 14), 4).Value =
strCASNumberOne
            rngCasNumberRange.Cells((intIfCounter + 14), 5).Value =
strPhaseCodeOne
            intIfCounter = intIfCounter + 1
            End If
        End With
    Next colIndex
Next rwIndex

Thanks.

5.Using Transpose from within VBA with >256 array

Hi all,

I'm trying to automate Excel from within Word. In my code I have a two 
dimensional array with over 300 elements. The Transpose command doesn't seem 
to work in this situation. 
It works perfectly for arrays with up to 256 elements but I can't get it to 
work for my code.

I made an example to show where I am talking about, this code doesn't put 
anything in the Excel sheet. 

-----------------------------------------------------------------------------------
Dim arrData() As String
Dim i As Long
Dim j As Long
Dim oXlApp As Excel.Application
Dim oXlBoek As Excel.Workbook

  ReDim arrData(1, 257)
  
  For i = 1 To 257
    
    j = i - 1
    arrData(0, j) = j
    arrData(1, j) = j
    
  Next i
  
  On Error Resume Next
  Set oXlApp = GetObject(Class:="Excel.Application")
  If Err.Number <> 0 Then
    Err.Clear
    Set oXlApp = CreateObject(Class:="Excel.Application")
  End If

  oXlApp.Visible = True
  Set oXlBoek = oXlApp.Workbooks.Add
  arrData = oXlApp.Application.Transpose(arrData)
  j = UBound(arrData, 2)
  oXlBoek.Sheets(1).Cells(1, 1).Resize(2, j).Value = arrData
  
  Set oXlBoek = Nothing
  Set oXlApp = Nothing

-----------------------------------------------------------------------------------

If I redimension the array to 256 elements, this code works fine, but I need 
it to work for a larger array. Can anyone please give me a suggestion how I 
can solve this?

TIA,
Renate

6. set printer.paperbin = (>= 256)

7. Query DFS Root Server with more thean 256 Roots

8. 128 * 256 causes overflow ?



Return to Visual Basic

 

Who is online

Users browsing this forum: No registered users and 89 guest