Hi all:
I have a problem which is as follows:
code:
select REMOTE_VIEW
=afields(paRemoteViewStru)
create cursor TEMP from paRemoteViewStru
alter table TEMP add column FIELD1 n(18,4) add column FIELD2 l(1)
This code is in the Load() event of a formset. I am using VFP8.SP1.
Basically, what I am trying to do is create a cursor based on a remote view structure and add new fields to the cursor. This code has been working before in VFP6. I upgraded the forms to VFP8 and it worked well. Only after I added a few fields (less than 10) to the remote view in VFP8 did I encounter this problem. Currently the remote view has 112 fields, way below the VFP field count limit.
The error message says "Invalid operation for cursor.". What could be the cause of this problem?
Currently, my workaround is to manipulate the array to add the definition of the 2 fields i needed to add before i create the cursor from the array. But that is a workaround to a problem that we are trying to solve. Any comment/help is highly appreciated.
TIA
Bernard L. Omiple
VFP, SQL Server, Crystal Reports