Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Clipper Visual-Objects > VO & Ado
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 19 Topic 11324 of 11558
Post > Topic >>

VO & Ado

by Rob van Erk <erk.v@[EMAIL PROTECTED] > Apr 19, 2008 at 02:20 AM

The following code displays an empty bBrowser with no SQL records in
the bBrowser:

== CODE 1 =======================================================
METHOD bBrowserTest CLASS Standardshellwindow
	LOCAL odtwBrowser		AS DwAdoTest
	LOCAL odbsServer		AS AdoServer
	LOCAL oBrowser		AS bBrowser

	odtwBrowser := DwAdoTest{SELF}
	odbsServer  := LEDEN{}

	IF odbsServer<>NULL_OBJECT .and. odbsServer:Used
	    odtwBrowser:Use(odbsServer)

   	    oBrowser := odtwBrowser:browser
   	    oBrowser:server:NewRecordset("SELECT * FROM LEDEN WHERE 1=0")

    	    oBrowser:Recalculate()
	    oBrowser:Refresh()
	ENDIF

	odtwBrowser:Show()
RETURN NIL

== CODE 2 ======================================================
CLASS DwAdoTest INHERIT DATAWINDOW
     etc..
CLASS LEDEN INHERIT AdoServer
     etc..

== CODE 3 ======================================================
on the DwAdoTest Datawindow I have a push button with following code:

METHOD executebutton CLASS DwAdoTest
    LOCAL uError     AS USUAL
    LOCAL oErrbox
    BEGIN SEQUENCE
         SELF:oDCbBrowser:server:NewRecordSet(SELF:oDCmSQL:value)
    RECOVER USING uError
       oErrBox := ErrorBox{SELF, "Oops, We have an error!"}
   oErrBox:Show()
    END
RETURN NIL
================================================================

The problem: when I submit a new, valid, SQL statement using the code
3 the records are
perfectly displayed on the screen (for example using code 'SELECT *
FROM LEDEN WHERE
naam = 'Rob van Erk'), but, as soon as I click on one of the records
on the screen the following
error is displayed: "adErrObjectClosed, subsystem Vo2Ado Error subcode
3704". No idea why
this errormessage is displayed. Still using evaluation version of
bBrowser 1.4 which I downloaded
from the Internet. Furthermore using VO2.7.

Thks for any sup****t that can be given.
 




 19 Posts in Topic:
VO & Ado
Rob van Erk <erk.v@[EM  2008-04-19 02:20:59 
Re: VO & Ado
Robert van der Hulst <  2008-04-19 13:00:26 
Re: VO & Ado
Rob van Erk <erk.v@[EM  2008-04-19 06:40:09 
Re: VO & Ado
"Willie Moore"   2008-04-19 08:56:23 
Re: VO & Ado
=?iso-8859-1?Q?E=AE!k_\\/  2008-04-19 16:14:55 
Re: VO & Ado
"Geoff Schaller"  2008-04-20 01:17:24 
Re: VO & Ado
jorgeaccinelli@[EMAIL PRO  2008-04-20 03:24:18 
Re: VO & Ado
Lars Broberg <this.is.  2008-04-20 13:45:49 
Re: VO & Ado
jorgeaccinelli@[EMAIL PRO  2008-04-20 08:11:52 
Re: VO & Ado
Lars Broberg <this.is.  2008-04-20 15:54:46 
Re: VO & Ado
jorgeaccinelli@[EMAIL PRO  2008-04-20 10:13:18 
Re: VO & Ado
Rob van Erk <erk.v@[EM  2008-04-20 12:03:00 
Re: VO & Ado
"Geoff Schaller"  2008-04-20 21:36:57 
Re: VO & Ado
Rob van Erk <erk.v@[EM  2008-04-20 22:22:24 
Re: VO & Ado
"Geoff Schaller"  2008-04-21 06:17:44 
Re: VO & Ado
=?iso-8859-1?Q?E=AE!k_\\/  2008-04-21 08:30:41 
Re: VO & Ado
"Geoff Schaller"  2008-04-21 07:43:41 
Re: VO & Ado
jorgeaccinelli@[EMAIL PRO  2008-04-21 19:22:16 
Re: VO & Ado
"Geoff Schaller"  2008-04-22 08:05:09 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Jul 24 16:21:43 CDT 2008.