I am now getting an error on a page that was working perfectly well last
week. The error is as follows:

Error Executing Database Query.  
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Visual
FoxPro Driver]Base table fields have been changed and no longer match
view fields. View field properties cannot be set.  
  
The error occurred in C:\Inetpub\wwwroot\Identity.cfm: line 12


10 : <cfquery name="GetAllActive"
11 :          datasource="Identity"
12 :          dbtype="ODBC">SELECT BasicInfo.*, Identity.*, Enrollment.*
13 : FROM (BasicInfo INNER JOIN Identity ON BasicInfo.IDID =
Identity.ID) INNER JOIN Enrollment ON Identity.ID = Enrollment.IDID
WHERE Status < 4 Order By Lastname, firstname ASC</cfquery>
14 :

I am no expert at FoxPro, so I am at a loss as to what this is trying to
say to me.

Thanks for any direction you can provide!

Tim
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to