Problems with work areas

[INFORMAT]

Hi,

When I use the function AUSED(), I get the following result:

viewUsers1
2
viewUsers
1

And the only thing I have done is just a SQLEXEC() to retrieve the data. Does anybody knows why VFP created 2 views in 2 different work areas? Or is this a default feature in VFP 8.0?

Thx

 

[rgbean]

Can you share the code (simplified) for your SQLEXEC()? A lot can depend on the actual request.

Rick

 

[Mike Lewis]

It depends on what you specified as the third parameter for SQLEXEC().

In general, specifying a different cursor for SQLEXEC() does not destroy any previous cursor.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com