-----Original Message-----
From: Keren Man [mailto:meow@c...]
Sent: 04 October 2000 16:33
To: support@w...
Subject: VB Oracle 8 1789


Hi, 
i hope someone can help me with this problem.  In VB6, SP4, using oo4o
(version 2.3.5.0), I am referencing my field values(oracle 7.3) by putting
an "!" in front of the field names. It works perfectly fine on all
machines except one.  The error I am getting is invalid procedure or
method.  Here's a sample of my code:

            mySQL = "select distinct to_char(podate,'yyyy') as fy from
tblfeeder "
            Set myDB = myConnection.Database
            Set myRS = myDB.CreateDynaset(mySQL, 4)
            With myRS
                        If !FY = Year(Now) Then   
<---------------------ERROR
                            Me.lstFY.Selected(Me.lstFY.NewIndex) = True
                        End If
            end with

Finally when I change from myRS!FY to myRS("FY").value, it worked on the
machine that wasnt working.  Is this a dll problem?  It really seems like
it is because the "!" doesnt work only on that one machine.  Please tell
me it is because it will be a pain to change all the "!" in my application
since due day is today. Welcome any hints or advises. Thanks in advance.