CursorAdapter

I got 30 fields need to call from MSSQL Server and create the cursor using
cursoradapter builder.

It show Error Message, 'The CursorSchema property must be no longer than 255
character", Any solution on this Visual Foxpro Version 8, SP 1, limitation ?

Than you in advance.

Dan
Tue Jun 29 11:47:09 CDT 2004

This is a limitation in the *PROPERTY SHEET*, not in the cursor adapter
itself. (This limit is removed in VFP9)

You can set this property in code (in Init, for example), and then it can be
much longer than 255 characters.

Dan


tsair wrote:
> I got 30 fields need to call from MSSQL Server and create the cursor
> using cursoradapter builder.
>
> It show Error Message, 'The CursorSchema property must be no longer
> than 255 character", Any solution on this Visual Foxpro Version 8, SP
> 1, limitation ?
>
> Than you in advance.

tsair
Tue Jun 29 20:31:50 CDT 2004

How to set this property, I got no idea what is the command to use.

Thank you


"Dan Freeman" <spam@microsoft.com> wrote in message
news:uy4YZifXEHA.736@TK2MSFTNGP10.phx.gbl...
> This is a limitation in the *PROPERTY SHEET*, not in the cursor adapter
> itself. (This limit is removed in VFP9)
>
> You can set this property in code (in Init, for example), and then it can
be
> much longer than 255 characters.
>
> Dan
>
>
> tsair wrote:
> > I got 30 fields need to call from MSSQL Server and create the cursor
> > using cursoradapter builder.
> >
> > It show Error Message, 'The CursorSchema property must be no longer
> > than 255 character", Any solution on this Visual Foxpro Version 8, SP
> > 1, limitation ?
> >
> > Than you in advance.
>
>

Stefan
Wed Jun 30 02:29:57 CDT 2004

The cursor adapter builder uses TEXT TO
Text To This.SelectCmd NoShow
Select CUSTOMERS.* From CUSTOMERS where companyname like 'C%'
EndText

but you can also divide the long string into pieces
This.SomeProperty = ;
"very long " + ;
"expression to be continued ..."


hth
-Stefan


"tsair" <tsair@myjaring.net> schrieb im Newsbeitrag
news:uBMUFIkXEHA.3044@TK2MSFTNGP09.phx.gbl...
> How to set this property, I got no idea what is the command to use.
>
> Thank you
>
>
> "Dan Freeman" <spam@microsoft.com> wrote in message
> news:uy4YZifXEHA.736@TK2MSFTNGP10.phx.gbl...
> > This is a limitation in the *PROPERTY SHEET*, not in the cursor adapter
> > itself. (This limit is removed in VFP9)
> >
> > You can set this property in code (in Init, for example), and then it can
> be
> > much longer than 255 characters.
> >
> > Dan
> >
> >
> > tsair wrote:
> > > I got 30 fields need to call from MSSQL Server and create the cursor
> > > using cursoradapter builder.
> > >
> > > It show Error Message, 'The CursorSchema property must be no longer
> > > than 255 character", Any solution on this Visual Foxpro Version 8, SP
> > > 1, limitation ?
> > >
> > > Than you in advance.
> >
> >
>
>