1:
2:
3:

 
Send MoveToFirstRow of oDbCJGrid1

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:

Use Windows.pkg
Use DFClient.pkg

Deferred_View Activate_oTest for ;
Object oTest is a dbView

    Set Border_Style to Border_Thick
    Set Size to 200 300
    Set Location to 2 2

    Object oForm1 is a Form
       Set Size to 13 100
       Set Location to 80 69
       Set Form_Margin to 5
    End_Object

Cd_End_Object

1:
2:
3:

Set Auto_Clear_Deo_State to False

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:

Class IBISDataDictionary is a DataDictionary
 ...
End_Class
Class IBISDbView is a DbView
  Procedure Construct_Object Integer iImage
    Forward Send Construct_Object No_Image
    Set DSO_Detach_Mode  to Detach_Always
    Set View_Latch_State to False
  End_Procedure
  Procedure Letzten_Satz_Anzeigen
     Integer iCur iMain iServer iFile iSatz
      Get Main_DD to iMain
      If (iMain)   Get Server of iMain to iServer
      If (iServer) Get Current_Record of iServer  to iCur
      If (Not(iCur)) Begin
         If (iServer) Begin
            Get piLetzter_Satz of iServer to iSatz
            Get Main_File of iServer to iFile
         End
         If (iSatz and iServer) Send Find_By_Recnum to iServer iFile iSatz
      End
   End_Procedure
End_Class //IBdbView

Class IBISDbForm is a dbForm
    // Construct_Object: Object constructor.
    Procedure Construct_object
       Forward Send Construct_Object
       // Set property values:
       Set Label_shadow_display_mode to TBSHADOW_ON_NONE  
       //Anzeige 
       On_Key key_F3        Send Letzten_Satz_Anzeigen
    End_Procedure
End_Class // IBDbForm

1:
2:
3:
4:

DRIVER_NAME MSSQLDRV
SERVER_NAME DFCONNID=IBIS_CONNECT

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:

Object oCLIHandler is a cCLIHandler
End_Object

Procedure CreateConnectionID
  Integer iResult
  String sServer sUser sPasswort sTreiber sDatenbank
  String sConnectString
  
   If (sTreiber="MSSQLDRV") Begin
       Set psDriverID of oCLIHandler to "MSSQLDRV"
       
       If (Pos("Trusted", sUser)) Begin
           Move ("SERVER="+sServer + "; Trusted_Connection=yes; DATABASE=" + sDatenbank) to sConnectString
       End
       Else Begin 
           Move ("SERVER="+sServer+"; DATABASE=" + sDatenbank + "; UID=" + sUser+ "; PWD=" + sPasswort) to sConnectString
       End
       Get CreateConnectionID of oCLIHandler "IBIS_CONNECT" sConnectString 0 to iResult
      
   End    
End_Procedure