read a file????

[hugal]

i have a request SQL in a text file, and with the name of the file, i want to read the request, how can i proceed?

[booogt]

there are plenty of posts that cover this sort of thing so you can search the archives for something about this...hope it helps

- nc

[JeffB]

There is other method (like with OPEN as RANDOM for READ 0, bu tthat one works well, it's with the FileSystemObject

    'Add a reference to Microsoft Scripting Runtime
    Dim fso As FileSystemObject
    Set fso = New FileSystemObject
    Dim objFile As File
    
    'Get the file wanted
    Set objFile = fso.GetFile("C:\boot.ini")
    
    Dim objTextStream As TextStream
    
    'Use the TextStream Object to retrieve text
    Set objTextStream = objFile.OpenAsTextStream(ForReading)
    
    'Read ALL the files
    MsgBox objTextStream.ReadAll
    
    'read a line
    'objTextstream.ReadLine
    
    'Destroy objects
    Set objTextStream = Nothing
    Set objFile = Nothing
    Set fso = Nothing

JeffB - hope it helps

[hugal]

when i compile your code, i have this error:

non defined type for filesystemobject...

[Boumxyz2]

You have to add a reference to the microsoft runtime script.

[hugal]

and how can i do that? ;-)

[JeffB]

Guess you have French version, in VB6, go there:

Projects -> Références

Chose, in the list, Microsoft Scripting Runtime (coche la case)

If not there, try to find the file "scrrun.dll"

JeffB -hope it helps