>Hi Aleksey
>
>I avoid this problem putting somethig in the Edit Box, but I lost the
>connection, so, I can handle being very carefully when I use the the
>builder and alway check "Use connections settings in builder only", but is
>anoying, because if I forget to check I get the freeze in the next opening.
>
>I found another bug. When I use an ODCB data source type I only find the
>tables in SQL Server, and I didn't find views, most of my sources are SQL
>Sever 2000 views. To find views I have to choose ADO in data source type,
>find the view, and change to ODBC again.
>
>The third bug is the squema box that not support more than 255 charaters, as
>you know. I put the following code in the after cursor fill event, at least
>help something to write the SQHEMA, UPDATABLEFIELDLIST and UPDATENAMELIST in
>an automatic way:
>
>

>lcAlias=ALLTRIM(this.Alias)
>i= AFIELDS(A_CAMPOS,lcAlias)
>lcTables=THIS.TABLES
>m.lcUList=''
>m.lcNList=''
>m.lcSqhema=''
>FOR N=1 TO i
>	m.lcUList=A_CAMPOS(N,1)+','+m.lcUList
>	m.lcNList=A_CAMPOS(N,1)+' '+lcTables+'.'+A_CAMPOS(N,1)+','+m.lcNList
>	m.lcSqhema=A_CAMPOS(N,1)+' '+A_CAMPOS(N,2)+'('+ALLTRIM(STR(A_CAMPOS(N,3)))+','+ALLTRIM(STR(A_CAMPOS(N,4)))+'),'+m.lcSqhema
>ENDFOR
>
>THIS.UPDATABLEFIELDLIST=LEFT(lcUList,LEN(lcUList)-1)
>THIS.UPDATENAMELIST=LEFT(lcNList,LEN(lcNList)-1)
>THIS.CURSORSCHEMA=LEFT(lcSqhema,LEN(lcSqhema)-1)
>

>
>I would be possible get a copy of the cursor adapter builder proyect to
>correct those errors? or we can do something about that, because
>cursoradapter is a very nice feature.
>


Hi Carlos,

I believe, you can find the source code for CursorAdapter/DataEnvironment builder in ...\Microsoft Visual FoxPro 8\Tools\xsource\xsource.zip .

However, setting CursorSchema in AfterCursorFill event is too late because it is called after CursorFill has been executed.

Thanks,
Aleksey.