Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why does cursor adaptor's cursorfill() cause a browse?
Message
From
26/03/2005 17:35:37
Mike Sue-Ping
Cambridge, Ontario, Canada
 
 
To
26/03/2005 17:29:24
Mike Sue-Ping
Cambridge, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00999309
Message ID:
00999310
Views:
29
Never mind folks.

Turned out that my SelectCmd had a bunch of trailing tab characters in the memo field. I guess that was enough to mess with VFP's internals to cause the browse window. After removing the tabs, everything is working as I expected.

Mike

>VFP9 Beta (and yeah I know it expires shortly).
>
>I've added a cursor adaptor to my form's dataenvironment and am trying to set it up via code as follows:
>
>
>SELECT * FROM SEC_CA WHERE CATEGORY = UPPER(ALLTRIM(this.caption)) INTO CURSOR csrCA
>
>THISFORM.oDE.ADDOBJECT("ca"+this.caption, "caSectional")
>oCA = EVALUATE("thisform.oDE.ca"+ ALLTRIM(this.caption))
>
>WITH oCA
>	.Alias = "csr" + lcCategory
>	.BufferModeOverride = 5
>	.CursorSchema = ""
>	.DataSourceType = "NATIVE"
>	.FetchSize = -1
>	.KeyFieldList = "SECT_NO"
>	.SelectCmd = ALLTRIM(csrCA.Selcmd)
>	.Tables = ALLTRIM(csrCA.tablenames)
>	.UpdatableFieldList = ALLTRIM(csrCA.Updfldlst)
>	.UpdateNameList = ALLTRIM(csrCA.UpdnamLst)
>* The following line gets the data AND automatically displays it in a browse window!
>* Needless to say, that's very annoying.
>	.CursorFill()
>ENDWITH
>
>
>All of the cursor adaptor's settings are being filled in from values stored in a table. Prior to me doing this, I hardcoded them and the CursorFill() method did not cause the browse window to appear. What's causing it now?
>
>Regards,
>
>Mike
Previous
Reply
Map
View

Click here to load this message in the networking platform