view

[Zach Ahmed]

Hi All:
I have two tables: event and event_times.
Event is connected to event_times with left outer join. When I run my view, I get result set as if the two tables are inner joined. What am I doing wrong? This is on sql 2000.

Thanks

SELECT dbo.events.event_title
FROM dbo.events LEFT OUTER JOIN
dbo.event_times ON dbo.events.event_id = dbo.event_times.event_id

[RobDog888]

This actually should go in the Databases forum, but anyways...
What results does this bring back?

SELECT
 events.event_id,
 events.event_title,
 event_times.event_id,
 event_times.event_time
FROM
 events 
LEFT OUTER JOIN
 event_times ON events.event_id = event_times.event_id

If you include other fields you may be able to really see what the
issue may be.

Ex.

events                       event_times
Id   Title                   Id             Time
123  Crash                   123           12:00
124  Stop                    <null>
125  Start                   125            1:00

Query results
123 Crash                    12:00
124 Stop                     <null>
125 Start                     1:00

HTH

[Zach Ahmed]

Hi :
Thanks for getting back to me. Actually I was able to solve this connecting all the tables to left outer joins. However, I have a another question for you.


How can I determine if a certain file exist. For example:


SaveFile = App.Path & "\Rpts" & "\RoomSetup.xls"

If SaveFile <> "" Then
Kill SaveFile 'Delete the previous file.
End I

This works as long as there is a file,if there is no file, it errors out.

Thanks

[RobDog888]

Option Explicit
 
Private Const OF_EXIST = &H4000
Private Const OFS_MAXPATHNAME = 128
 
Private Type OFSTRUCT
    cBytes As Byte
    fFixedDisk As Byte
    nErrCode As Integer
    Reserved1 As Integer
    Reserved2 As Integer
    szPathName(OFS_MAXPATHNAME) As Byte
End Type
 
Private Declare Function OpenFile Lib "kernel32" (ByVal lpFileName As String, lpReOpenBuff As OFSTRUCT, ByVal wStyle As Long) As Long
 
Public Function FileExists(ByVal Fname As String) As Long
 
    Dim lRetVal As Long
    Dim OfSt As OFSTRUCT
    
    lRetVal = OpenFile(Fname, OfSt, OF_EXIST)
    If lRetVal = 1 Then
        FileExists = 1
    Else
        FileExists = 0
    End If
    
End Function

Enjoy.

[Zach Ahmed]

Hi RobDog888:
Thanks

[RobDog888]

No prob.
Glad to help.