Invalid Argument OpenRecordset 
Author Message
 Invalid Argument OpenRecordset

I have a weird situation,
In the next line of code i have error 3001 -
Invalid Argument
set rs=db.OpenRecordSet(sql,
dbOpenForwardOnly, ,dbReadOnly)

However if i use:
set rs=db.OpenRecordSet(sql, dbOpenForwardOnly,

or even
set rs=db.OpenRecordSet(sql, dbOpenForwardOnly,
dbReadOnly, dbReadOnly)

it works,
the weird thing is that the first one follows
documentation on DAO 3.51, that is the dbReadOnly
is used in LockEdits and not in the options
argument, further more, the help states this:
"[...]Supplying a lockedits argument when options
uses the dbReadOnly constant also causes an

So, by the book the first one should work, the
second should work thanks to backwards
compatibility and the third should produce an

Has anybody seen this behaviour,
Any fix, workaround

Sent via http://www.***.com/
Before you buy.

Sun, 04 Aug 2002 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. OpenRecordset 3001 Invalid Argument error

2. Openrecordset "Select into" causes invalid operation

3. ERROR 3001 - "Invalid Argument"

4. invalid arguments in call

5. Newbie needs help with invalid argument

6. PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed: Invalid argument

7. Invalid Procedure Call or Argument

8. Run-time error '5': Invalid procedure call or argument

9. invalid argument value

10. IpcMemoryCreate: shmget failed (Invalid argument)

11. Need help on Invalid Argument

12. Error 3001: Invalid argument

Powered by phpBB® Forum Software