Non-global global recordsets? 
Author Message
 Non-global global recordsets?


I have dimensioned a recordset as global and open it with an OpenRecordset
containing an SQL statement.  This works fine -- but:

On the first call to a modal form which also uses this recordset,
I find a completely different record in it.  This first appears in the
Form_Activate property of the modal form.

I have checked and double-checked the usual "did I dimension it somewhere
else?"  "does this form think it's a different variable?" "did some other
routine do an OpenRecordset or CreateDynaset or move the pointer?"

Answer to all these: no.

It seems that the global recordset isn't truly global.  Anyone else been
here?  Comments? Anyone have a workaround?

Thanks in advance.

Reg Jacklin
Contract Programmer / VB Instructor / Columnist

Thu, 10 Sep 1998 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Global.MPT and Enterprise Global Template

2. Refering to Functions and Subs held in one global template from another global template

3. global.asa and global.asax ?

4. Global Variables / Global Objects

5. Calling global non-cached procedures from another project

6. Add non-working time to Global Resource Pool

7. dotnet Reference to non-shared member requires object reference - Global.asax.vb

8. Enumerate Global Group Members from Remote, Non-Admin?

9. Declaring Global Recordsets

10. Global Or Local Recordsets???

11. Making a DAO recordset global in scope?

12. Global Or Local Recordsets???


Powered by phpBB® Forum Software