Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Mere Mortals 8.1 issue
Message
From
03/02/2014 14:17:52
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
03/02/2014 09:01:36
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows NT
Database:
Visual FoxPro
Application:
Web
Miscellaneous
Thread ID:
01592980
Message ID:
01593025
Views:
74
>Two users have begun seeing a sporadic error on a block of code that has never caused any issue before. One user gets the error about every 10th record being added. The other user has only gotten the error once.

A single cursor cannot have two fields with the same name. cFieldN is coming from both aliases according to the error message. Was a new field added recently?

>
>The error being returned is:
>
>
         Error # : 1429
>         Message : OLE IDispatch exception code 0 from Visual FoxPro for Windows: 13 :Alias is not found...
>     OLE Message : 13 :Alias is not found.
>   OLE Exception : 9
>            Code : SELECT ourAlias1.cFieldN, ourAlias2.cFieldN   FROM  abc!ourAlias1  INNER JOIN abc!ourAlias2  ON  ourAlias1.iPrimaryKey = ourAlias2.iForeignKey WHERE  NOT (ourAlias1.lDeleted ) AND  ourAlias1.iPrimaryKey = ( vp_iprimaryid ) into cursor Viewcalv59
>          Method : loadrelations
>          Object : xyz
>            Line : 24
>
>
>Line 24 is:
>
Application.RequestData(cAlias)
>
>The aliases in question do exist, are already in use, and can be browsed if stepped through that code. We have not been able to replicate the error. Originally it happened at one client's site and we assumed it was a setup issue on their computer or network. However, it's now happened at a second client.
>
>Has anybody had any experience with this error?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform