About SQL string in VBSCRIPT using text-base file

Discussion in 'Scripting' started by ppsy, Apr 10, 2004.

  1. ppsy

    ppsy Guest

    Dear sirs:
    I have 2 text-base data files which use a field to make relation.
    May I use a SQL-string like following to select data depending on its
    relation?

    text1.txt
    NameNo,Name
    text2.txt
    No,Machine,NameNo
    ----Code
    block-----------------------------------------------------------------------
    -----------------
    dim rs as ADODB.Recodrset
    SQL="select * from text1.txt,text2.txt where
    text1.txt.NameNo=text2.txt.NameNo"
    rs.Open SQL
    ----------------------------------------------------------------------------
     
    ppsy, Apr 10, 2004
    #1
    1. Advertisements

  2. ppsy

    Jeff Cochran Guest

    What the heck are "text-base data files which use a field to make
    relation"?
    Okay, how did you "compile" VBScript?

    If you're using simple text file to store data, then the answer is
    no. If it's a delimited file, then you can open it as a data file
    using the Jet driver or the ODBC Text driver, with some reservations
    on what yu can do with it. For example, you can't use the SQL you
    posted as an example, you can only select the file as a record set.

    See:

    http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForText
    http://www.able-consulting.com/MDAC...roviders.htm#OLEDBProviderForMicrosoftJetText

    If you tell us what you're trying to do and show us some data, then
    maybe we can suggest an alternative.

    Jeff
     
    Jeff Cochran, Apr 11, 2004
    #2
    1. Advertisements

  3. ppsy

    ppsy Guest

    Sorry for my heck description.
    I didn't describe question well.
    But your answer is helpful to me.
    Thanx...
     
    ppsy, Apr 15, 2004
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.