In the DataSource property, be sure to include the EQUAL sign before nID. This will force that property to be evaluated instead of treated as a character string. i.e., set the property to =nID instead of nID.

>I dont find a solution for a problem when using CursorAdapters that happens when I want to use a DataSource in a CA Base class.
>
>Steps to reproduce the problem.
>1) RUN Mark E. McCasland CABuilder to generate a CA Class
>2) Edit the base class (_CABASE) and change the DataSource propertie to a valid handler (nID)
>3) Save and close the Base CA Class
>*----
>4) Create a new Form and open the DataEnvironment (DE)
>5) Right click and select Builder
>6) In the DataEnvironment Builder Form Select the Second page from the pageframe and click on Add...
>7) In the open window, select the CA class that was generated with CA Builder
>8) Select any class you wish to add to the DE and click OK
>9) When the CursorAdapter Builder form opens only check "Use Connection settings in builder only" and click OK
>10) In the DataEnvironment Builder Form click OK
>11) Drag and Drop the fields to the form and save it. ("Test_CA_x")
>12) Run the code to connect to the Server and get an handle, then call the form that was saved.
>
>

>* (Sample to run the form)
>SET DEFAULT TO C:\test\CA1\Classes
>PUBLIC nID
>cStringConnect =("DRIVER={SQL Server};SERVER=BOSS700;UID=sa;" ;
      + "PWD=sa;DATABASE=Atuante;Network=DBMSSOCN")
>nID = SQLStringConnect(cStringConnect)
>?nID
>
>Do form Test_CA_x
>

>
>It allways it returns this error message (the handle is > 0):
>

>Error loading file - record number 5.  grdCrsseg1 <or one of its members>.
>ControlSource : Alias 'CRSSEG1' is not found
>

>
>
>If I define an DSN or a connection string in the CA Builder form at the DE, it works.
>But I dont want to hardcode this information in the BeforeOpenTables of the DE.
>I just want to use the DataSource defined in the main CA base class.
>
>Does someone has as Way to make it work ? I simply dont see a way to make it the way I want.
>
>Thanks in Advance
>
>Peter