Help...Run-time error '440':

[manvee1]

I get Run-time error '440': OIP-08193: Cannot create cusor
when i try to use a field form the database.

The field is a date calculated with 'SysDate - PWord_Set_Date'


problem code is line below:
Set flds(i) = ODS.Fields(i) //problem code

/*flds(i) on the database = .000798611111111111111111111111111111111111 */

MsgBox IsNull(ODS.Fields(i))
// returns 'False' after about 10 secs wait



MsgBox ODS.Fields(i)
// returns Run-time error '440':
OIP-08193: Cannot create cusor


When i wait a few mins (about 12 mins) and then try again
it works without errors.

the value of MsgBox IsNull(ODS.Fields(i))
// returns 'False' instantly. not 10 secs wait

and the value of
MsgBox ODS.Fields(i) =
.008483796296296296296296296296296296296296

any ideas why this is happening? or need more info?

 

[Darrylles]

Hi,

In an MS Access database?

Regards,

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@hotmail.com

 

[manvee1]

this is on an oracle database.

i notice it works when the value is at least
00848...... but why dosent it work when there are three 0s to start the value like 0007......




thanks
manvee