Einzelnen Beitrag anzeigen

marabu

Registriert seit: 6. Apr 2005
10.109 Beiträge
 
#23

Re: Filter in einer dBase Tabelle - Fortsetzung -

  Alt 22. Mai 2005, 20:22
Sorry, aber ich hatte vergessen, dass du D3 hast. Hier der Quelltext von Unit4.dfm mit der korrigierten Query-Komponente. Übernimm nur was du unter D3 brauchst.

Delphi-Quellcode:
object DataModule4: TDataModule4
  OldCreateOrder = True
  OnCreate = DataModule4Create
  Left = 569
  Top = 266
  Height = 205
  Width = 215
  object Tabelle: TTable
    TableName = 'lsoft'
    TableType = ttDBase
    Left = 22
    Top = 10
    object TabelleNUM_LAGER: TSmallintField
      DisplayLabel = 'Lager'
      DisplayWidth = 6
      FieldName = 'NUM_LAGER'
    end
    object TabelleNUM_REGAL: TSmallintField
      DisplayLabel = 'Regal'
      DisplayWidth = 6
      FieldName = 'NUM_REGAL'
    end
    object TabelleNUM_ART: TSmallintField
      DisplayLabel = 'Artikel'
      DisplayWidth = 7
      FieldName = 'NUM_ART'
    end
    object TabelleART_STUECK: TFloatField
      DisplayLabel = 'Stück'
      DisplayWidth = 6
      FieldName = 'ART_STUECK'
    end
    object TabelleART_PRODUC: TStringField
      DisplayLabel = 'Hersteller'
      DisplayWidth = 20
      FieldName = 'ART_PRODUC'
      Size = 40
    end
    object TabelleART_NAME: TStringField
      DisplayLabel = 'Artikel'
      DisplayWidth = 40
      FieldName = 'ART_NAME'
      Size = 50
    end
    object TabelleART_NUM: TStringField
      DisplayLabel = 'Artikel-Nummer'
      FieldName = 'ART_NUM'
    end
    object TabelleART_DESCR: TStringField
      DisplayLabel = 'Beschreibung'
      DisplayWidth = 50
      FieldName = 'ART_DESCR'
      Size = 100
    end
    object TabelleART_MIN_ST: TFloatField
      DisplayLabel = 'Min.-Stück'
      FieldName = 'ART_MIN_ST'
    end
  end
  object DataSource1: TDataSource
    Left = 24
    Top = 66
  end
  object Query1: TQuery
    DatabaseName = 'dBASE-Dateien'
    SQL.Strings = (
      
        'SELECT num_lager, num_regal, num_art, art_stueck, art_produc, ar' +
        't_name, art_num, art_descr, art_min_st'
      'FROM lsoft'
      'WHERE art_stueck <= art_min_st')
    Left = 104
    Top = 10
  end
  object DataSource2: TDataSource
    DataSet = Query1
    Left = 102
    Top = 66
  end
end
marabu
  Mit Zitat antworten Zitat