Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Not lUseLocalData + 3-tier config
Message
From
26/08/2004 15:07:15
 
 
To
24/08/2004 15:45:06
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00934919
Message ID:
00936736
Views:
14
Chis,
After studing the situation a little bit more I found the way to do it. This is what I did in BizObj.first() method:

I reeplaced:
loDataAccess = This.GetDataAccessObject()
lnRetVal = loDataAccess.First()
with:
IF This.UseRemoteExecutant()
  tcExecString = "nav_first '" + SUBSTR(This.GetAlias(), 3) + "','" + ;
 		This.cDescField + "','" + This.cUniqueIDField + "'"
			
  lnRetVal = This.RemoteExecutantExecSQL(tcExecString, 'cSQLPassThrough')
	
  IF lnRetVal > 0
    SELECT cSQLPassThrough
    lcProperty = 'This.' + This.cUniqueIDField 
    IF TYPE('cSQLPassThrough.id') = 'N'
      &lcProperty = cSQLPassThrough.id
    ELSE
      &lcProperty = VAL(cSQLPassThrough.id)
    ENDIF 	
		
    USE 
		
    lnRetVal = This.Requery()
  ENDIF 

  RETURN lnRetVal
ELSE
  loDataAccess = This.GetDataAccessObject()
  lnRetVal = loDataAccess.First()
ENDIF 
The key is using the method RemoteExecutantExecSQL which I discover after studing the situation.

Thank,
Monique
Previous
Reply
Map
View

Click here to load this message in the networking platform