cursor location
cursor location
cursor location
cursor location
cursor location
cursor location cursor location cursor location cursor location cursor location cursor location cursor location cursor location
cursor location cursor location
cursor location
Go Back  Xtreme Visual Basic Talk > > > cursor location


Reply
 
Thread Tools Display Modes
  #1  
Old 12-26-2003, 12:46 AM
cscrsr cscrsr is offline
Newcomer
 
Join Date: Dec 2003
Posts: 11
Default cursor location


We are using connection.cursorlocation without knowing the real purpose. We use VB to develop client application and not as client and server application, ideally a standalone system.

When the code gives error we change the location either from .adclient to .adserver or vice-versa. On changing the error would vanish. What is the ideal cursor location? Whether it is absolutely required for the application that we develop as standalone?

Require some help
Reply With Quote
  #2  
Old 12-26-2003, 06:34 AM
Shurik12cursor location Shurik12 is offline
Steppe Walker

Retired Moderator
* Expert *
 
Join Date: Jul 2002
Location: Ukraine/Russia/Belgium
Posts: 7,227
Default

Hi,

>What is the ideal cursor location?
I don't think one can give a definition of an ideal cursor location.
It's rather a matter of the 'scenario' you have.

>Whether it is absolutely required for the application that we develop as standalone?
Again, it's not about the application being stand-alone or not but rather
what you're doing in your application, to what database you are connecting, etc.

Just some examples.
With the server side cursor, if you use an ADO .Recordset object you might not be able to do .RecordCount,.Filter .As well as you might not be able to update the underlying table by opening the recordset and doing .Update (well surely not on Oracle)...
---------
EDIT: .Seek should have server side cursor (initially I mentioned 'client' cursor)
--------

I think the list can be continued/modified , depending on what data provider and ADO objects (connection/command/recordset) you are using


Just out of curiosity, you say you just switch between 'client' and 'server' when you receive an error. Could you give an example of such a situation?


Regards,
Shurik.
__________________
"A diaper is not like a computer that makes satisfying burbling noises from time to time, hinting at great inner complexity." Malcolm Gladwell

"I'm sitting here completely surrounded by no beer." Onslow, 'Keeping up appearances'

Last edited by Shurik12; 12-26-2003 at 06:56 AM.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
cursor location
cursor location
cursor location cursor location
cursor location
cursor location
cursor location cursor location cursor location cursor location cursor location cursor location cursor location
cursor location
cursor location
 
cursor location
cursor location
 
-->