Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2006
    Posts
    34

    Unanswered: Problem need help

    ok the criteria with hath i have the problem looks like this


    SELECT DISTINCT table1.col1,...,table1.columnN,......TableM. Column X
    FROM Tables1, Table M
    INNER JOIN Table1
    ON (table1.col1 = tableN.colZ) , Tablex
    WHERE (table1.col1 = tableN.colZ)
    AND (table1.col1 LIKE '............')

    in this section '........' i have to introduce the next statment editbox text or other component externaly introduced datavalue wich is al integer value asstring

    Lehel

  2. #2
    Join Date
    Nov 2006
    Posts
    34
    yess it is exactly whath i want to use an earlier or exactly the last data introduced in the table to wiew all the modification iff necesary, and to bee able to list somme modified data if it is needed.
    thanks bekause sommebody sad to mee thath i have to write somme special procedure to do this thing.

    Lehel

  3. #3
    Join Date
    Nov 2006
    Posts
    34
    yess the ideea is good, but it gives me back somme empty cells and i'm sure thath i have data in the tables

    Lehel

  4. #4
    Join Date
    Nov 2006
    Posts
    34
    the code is the folowing:
    "SELECT DISTINCT Contractdetailat.NRCONTRACT, Contractdetailat.DINDATA,
    Contractdetailat.PINALADATA, Contractdetailat.PUNCTDELUC,
    Contractdetailat.COMPONENTE, Contractdetailat.PRETUNITAR,
    Contractdetailat.NRBUC, Contractdetailat.PRETTOTAL,
    Firma.DENUMIREFI, Firma.NRREGCOM, Firma.CODFISCAL,
    Firma.SEDIULSOCI, Firma.JUDETUL, Firma.CODIBAN,
    Firma.BANCA, Firma.PUNCTDELUC, Firma.NRCONTRACT,
    Delegati.NUMELEDELE, Delegati.BI_CI_, Delegati.SERIA,
    Delegati.ELIBERATPO, Delegati.MIJLOCTRAN,
    Delegati.NRMASINA, Delegati.DATAEXPED
    FROM "D:\ISTI\28.11.2006\contractdetailat.dbf" Contractdetailat
    INNER JOIN "D:\ISTI\28.11.2006\firma.dbf" Firma
    ON (Contractdetailat.NRCONTRACT = Firma.NRCONTRACT) , "D:\ISTI\28.11.2006\delegati.dbf" Delegati
    WHERE (Contractdetailat.NRCONTRACT = Firma.NRCONTRACT)
    AND (Contractdetailat.NRCONTRACT like'?"&intrari.nrcontract.text&"*')"
    now the rezult soud be
    at nrconract i have 25 contracts with the afferent next rows and i don't need all of it listed in the same sheet in one sheet i need listig of only one contract that is tha ideea.
    thanks.
    by the way the program is one man creation i'm vorking solo and it is werry hard to work solo

    Lehel

  5. #5
    Join Date
    Nov 2006
    Posts
    34
    the return rezult is zipp !!!!!
    it is a blank datatable
    I'm sure there is somme data on it because it when i select all it can be displayd in a data gird

    Lehel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •