Exportfile for AOT version 1.0 or later Formatversion: 1 ***Element: FRM ; Navision Axapta Forms unloaded at Viernes 01/02/2008 ; -------------------------------------------------------------------------------- FRMVERSION 5 FORM #FTX_cosultaSQL PROPERTIES Name #FTX_cosultaSQL ENDPROPERTIES METHODS Version: 3 SOURCE #ClassDeclaration #class FormRun extends ObjectRun #{ # FormTableControl _table; # FormStringControl _edit; # FormIntControl _intEdit; #} ENDSOURCE SOURCE #Run #void run() #{ # _table = element.control(control::Table); # _edit = element.control(Control::EditLine); # //_intEdit = element.control(Control::IntEdit); # # super(); # # sql.text( # @"SELECT --+ index (t i_40007ftx_iftpv_arqueos_i2) #DISTINCT t.fecha, to_char(t.fecha, 'Day') dia, t.tienda, tt.descripcion # FROM ftx_iftpv_arqueos t, ftx_tiendas ti, ftx_tipotiendas tt # WHERE t.tienda = ti.tienda (+) # AND ti.tipo_tienda = tt.tipo_tienda # AND t.fecha >= to_date('01012007', 'ddmmyyyy') # AND NOT EXISTS (SELECT /*+ index (t2 i_40021ftx_tpv_paquetesca40001)*/ 1 # FROM ftx_tpv_paquetescargados t2 # WHERE t2.ktienda = t.tienda # AND t2.kfecha = t.fecha) #ORDER BY t.fecha ASC, t.tienda"); # #sql.text( #@"select a.userName,a.audsid, b.lock_type, b.mode_held, b.mode_requested, b.blocking_others, c.object_name,c.object_type # from v$session a, dba_locks b, dba_objects c # where a.sid=b.session_id # and nls_lower(a.userName)=nls_lower('%1') # and b.lock_id1=c.object_id(+) #" #); # #sql.text("select * from v$session "); # #} ENDSOURCE ENDMETHODS OBJECTBANK ENDOBJECTBANK JOINS ENDJOINS DESIGN PROPERTIES Left #Auto (left) Top #Auto Width #928 Height #679 Visible #Yes Caption # TitleDatasource # Frame #Standard WindowResize #Auto WindowType #Standard SaveSize #No AlwaysOnTop #No HideToolbar #No SetCompany #Yes ColorScheme #Default CssClass # ShowWebHelp #Default BackgroundColor #Button face (3D) ImageName # ImageResource #0 Imagemode #Normal (preserve pict. attributes) Mode #Watch SubmitMethod #Auto SupportReload #No LocalWebMenu # AllowDocking #No Font # FontSize #0 Italic #No Underline #No Bold #Default CharacterSet #0 LabelFont # LabelFontSize #0 LabelItalic #No LabelUnderline #No LabelBold #Default LabelCharacterSet #0 DataSource # TopMargin #Auto BottomMargin #Auto LeftMargin #Auto RightMargin #Auto ArrangeWhen #Default ArrangeMethod #Vertical Columns #2 Columnspace #Auto ArrangeGuide ARRAY INDEX Columns #0 #0 ENDARRAY HideIfEmpty #No AlignChildren #Yes AlignChild #Yes AllowUserSetup #Yes NeededAccessLevel #NoAccess ENDPROPERTIES CONTAINER CONTROL TABLE ;==== controlId:12289, containerId: 0, containerdata: 0 ;---------------------------------------------------------- PROPERTIES Name #Table AutoDeclaration #Yes Visible #Yes AllowEdit #Yes Left #Auto (left) Top #Auto Width #Column width Height #Column height VerticalSpacing #Auto Enabled #Yes Skip #No AlignControl #No HelpText # ConfigurationKey # SecurityKey # DragDrop #None ColorScheme #Default BackgroundColor #Window text TopMargin #0 BottomMargin #0 LeftMargin #0 RightMargin #0 Columns #2 Rows #2 Column #0 Row #0 ShowColLabels #Yes ShowRowLabels #Yes GridLines #Yes ENDPROPERTIES METHODS Version: 3 SOURCE #EditControl #FormControl editControl(int column, int row) #{ # return _edit; # #} ENDSOURCE ENDMETHODS CONTAINER CONTROL STRINGEDIT ;==== controlId:12296, containerId:12289, containerdata:12289 ;---------------------------------------------------------- PROPERTIES Name #EditLine AutoDeclaration #No Visible #Yes AllowEdit #Yes Left #Auto (left) Top #Auto Width #80 Height #15 VerticalSpacing #Auto Enabled #Yes Skip #No AlignControl #Yes HelpText # ConfigurationKey # SecurityKey # DragDrop #None LookupButton #Auto ReplaceOnLookup #Yes LimitText #Auto DisplayLength #Auto DisplayHeight #Auto Border #Auto Text # PasswordStyle #No Alignment #Auto ChangeCase #Auto MultiLine #No ColorScheme #Default BackStyle #Opaque BackgroundColor #Window background ForegroundColor #Window text Font # FontSize #0 Italic #No Underline #No Bold #Default CharacterSet #0 LabelForegroundColor #Window text ShowLabel #Yes Label # LabelFont # LabelFontSize #0 LabelItalic #No LabelUnderline #No LabelBold #Default LabelCharacterSet #0 LabelWidth #Auto LabelHeight #Auto LabelPosition #Left LabelAlignment #Right DataSource # DataField # Mandatory #No ExtendedDataType ARRAY # # ENDARRAY ArrayIndex #0 DataMethod # SearchMode #None ENDPROPERTIES ENDCONTROL ENDCONTAINER ENDCONTROL CONTROL GROUP ;==== controlId:12300, containerId: 0, containerdata: 0 ;---------------------------------------------------------- PROPERTIES Name #Group AutoDeclaration #No Visible #Yes AllowEdit #Yes Left #Right edge Top #Auto Width #Auto Height #Auto VerticalSpacing #Auto Enabled #Yes Skip #No AlignControl #No HelpText # ConfigurationKey # SecurityKey # DragDrop #None FrameType #Auto FramePosition #Outside Caption # FrameOptionButton #None OptionValue #1 ColorScheme #Default BackStyle #Opaque BackgroundColor #Button face (3D) Font # FontSize #0 Italic #No Underline #No Bold #Default CharacterSet #0 LabelFont # LabelFontSize #0 LabelItalic #No LabelUnderline #No LabelBold #Default LabelCharacterSet #0 DataSource # TopMargin #Auto BottomMargin #Auto LeftMargin #Auto RightMargin #Auto ArrangeWhen #Default ArrangeMethod #Vertical Columns #1 Columnspace #Auto ArrangeGuide ARRAY INDEX Columns #0 ENDARRAY HideIfEmpty #Yes AlignChildren #Yes AlignChild #Yes AllowUserSetup #Yes NeededAccessLevel #View DataGroup # AutoDataGroup #No ENDPROPERTIES CONTAINER CONTROL STRINGEDIT ;==== controlId:12298, containerId:12300, containerdata: 0 ;---------------------------------------------------------- PROPERTIES Name #sql AutoDeclaration #Yes Visible #Yes AllowEdit #Yes Left #Auto (left) Top #Auto Width #Auto Height #Auto VerticalSpacing #Auto Enabled #Yes Skip #No AlignControl #Yes HelpText # ConfigurationKey # SecurityKey # DragDrop #None LookupButton #Auto ReplaceOnLookup #Yes LimitText #Auto DisplayLength #Auto DisplayHeight #Auto Border #Auto Text # PasswordStyle #No Alignment #Auto ChangeCase #Auto MultiLine #Yes ColorScheme #Default BackStyle #Opaque BackgroundColor #Window background ForegroundColor #Window text Font # FontSize #0 Italic #No Underline #No Bold #Default CharacterSet #0 LabelForegroundColor #Window text ShowLabel #Yes Label # LabelFont # LabelFontSize #0 LabelItalic #No LabelUnderline #No LabelBold #Default LabelCharacterSet #0 LabelWidth #Auto LabelHeight #Auto LabelPosition #Left LabelAlignment #Right DataSource # DataField # Mandatory #No ExtendedDataType ARRAY # # ENDARRAY ArrayIndex #0 DataMethod # SearchMode #None ENDPROPERTIES ENDCONTROL CONTROL BUTTONGROUP ;==== controlId:12297, containerId:12300, containerdata: 0 ;---------------------------------------------------------- PROPERTIES Name #ButtonGroup AutoDeclaration #No Visible #Yes AllowEdit #Yes Left #Right edge Top #Auto Width #Auto Height #Auto VerticalSpacing #Auto Enabled #Yes Skip #No AlignControl #No HelpText # ConfigurationKey # SecurityKey # DragDrop #None FrameType #Auto FramePosition #Outside Caption # SizeWidth #Yes SizeHeight #Yes Font # FontSize #0 Italic #No Underline #No Bold #Default CharacterSet #0 BackStyle #Opaque ColorScheme #Default BackgroundColor #Button face (3D) DataSource # TopMargin #Auto BottomMargin #Auto LeftMargin #Auto RightMargin #Auto ArrangeWhen #Default ArrangeMethod #Vertical Columns #1 Columnspace #Auto ArrangeGuide ARRAY INDEX Columns #0 ENDARRAY HideIfEmpty #Yes AlignChildren #Yes AlignChild #Yes AllowUserSetup #Yes NeededAccessLevel #View ENDPROPERTIES CONTAINER CONTROL BUTTON ;==== controlId:12292, containerId:12297, containerdata: 0 ;---------------------------------------------------------- PROPERTIES Name #Button AutoDeclaration #No Visible #Yes AllowEdit #Yes Left #Auto (left) Top #Auto Width #Auto Height #Auto VerticalSpacing #Auto Enabled #Yes Skip #Yes AlignControl #No HelpText # ConfigurationKey # SecurityKey # DragDrop #None Text # Value #No ButtonDisplay #Text only NormalImage # NormalResource #0 DisabledImage # DisabledResource #0 Font # FontSize #0 Italic #No Underline #No Bold #Default CharacterSet #0 Border #Auto ShowShortCut #Yes DefaultButton #No SaveRecord #Yes MultiSelect #Auto ColorScheme #Default BackStyle #Opaque BackgroundColor #Button face (3D) ForegroundColor #Button text NeededAccessLevel #View ENDPROPERTIES METHODS Version: 3 SOURCE #clicked #void clicked() #{ # # LoginProperty loginProperty = new LoginProperty(); # OdbcConnection connection; # Statement statement; # ResultSet resultSet; # int i; # int columns; # int row; # int col; # ResultSetMetaData rsmd; # # ; # connection = new Connection(); # # statement = connection.createStatement(); # //resultSet = statement.executeQuery('SELECT itemid FROM inventtable'); # # resultSet = statement.executeQuery(sql.text()); # #//num colums # while (resultSet.next()) # { # // ... # rsmd = resultset.getMetaData(); # columns = rsmd.getColumnCount(); # row ++; # Table.columns(columns); # Table.rows(row); # for (i=1; i <= columns; i++) # { # //print resultSet.getString(i); # //print rsmd.getColumnType(i); # if (rsmd.getColumnType(i) != 7) # { # Table.setColLabel(i,rsmd.getColumnName(i)); # Table.cell(i,row).data(resultSet.getString(i)) ; # } # } # // ... # } # //print _edit.widthValue() * columns; # //print _edit.heightValue() * row ; #// table.width((100 * columns > 300 ? 100 * columns : 300) ); # //table.height((21 * row > 75 ? 21 * row : 75) ); # # element.redraw(); # # super(); #} ENDSOURCE ENDMETHODS ENDCONTROL ENDCONTAINER ENDCONTROL ENDCONTAINER ENDCONTROL ENDCONTAINER ENDDESIGN ENDFORM ***Element: END