Lots of errors when opening a solution

I have been working on a Servoy solution for a few weeks. Today I had a tabpanel that would stop displaying when I restarted Servoy. I ended up checking the logfile and found that Servoy was generating many errors when it loaded my solution. I would copy and paste the errors here, but each time I open Servoy it generates more than 1,000 lines of errors. The solution is quite small - only 9 forms and a handful of methods so far although the database structure is largely complete. What should I do? Thanks.

Reed

Forgot to post the version etc.

Servoy Developer
Version R2 2.2.3-build 335
Java version 1.5.0_06-b05 (Windows XP)

Not too difficult I guess. Haven’t looked at the complete log file but your errors look like this a lot of times:

2006-01-27 16:13 : select Appointments.AppointmentID, Appointments.PatientID, Appointments.Appointment_Number, Appointments.Appointment_Date, Appointments.ProviderID, Appointments.CarrierID, Appointments.DepartmentID, Appointments.New_Patient_Flag, Appointments.Appointment_Length, Appointments.Notes, Appointments.Blacked_Out_Flag, Appointments.Signed_In_Flag, Appointments.Overbooked_Flag, Appointments.Late_Flag, Appointments.Really_Late_Flag, Appointments.Referring_PhysicianID, Appointments.Current_Illness_Date, Appointments.Original_Illness_Date, Appointments.Insurance_Override_Account, Appointments.Type_Override_Account, Appointments.Appointment_Made_Stamp, Appointments.Appointment_Made_Account, Appointments.Appointment_Made_Workstation, Appointments.Creation_Stamp, Appointments.Creation_Account, Appointments.Appointment_Status_Words, Appointments.Appointment_Status_Letters, Appointments.patient_name, Appointments.provider_initials, Appointments.Appointment_TypeID, Appointments.Appointment_Type_HTML from Appointments where Appointments.Appointment_Date >= ? and Appointments.Appointment_Date <= ? and Appointments.Signed_In_Flag is null and ? <= Appointments.Appointment_Date and ? >= Appointments.Appointment_Date and ? = Appointments.Signed_In_Flag order by Appointments.Appointment_Date
2006-01-27 16:13 : java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter not set, index: 2.

What it says is that your input array, the array of values that you use to replace the ? with ‘real’ values is incorrect/not set…

When you don’t know how to solve it then please post (part of) your method that builds the query.[/code]

There is not a method running. The solutions loads and goes to the form specified under solution settings. There are no onshow or onload events specified. There are only six methods (all globals) in the whole solution and they are all for navigation purposes. The form that loads has 4 portals on it, one of which is appointments. However, the forms that loads is not the appointments form. I don’t understand what I could have done to cause this to happen.

Reed

hmm, but portals are based on relationships right? So is that relationship set correct?

That was it. The initial sort for two of the portals was incorrectly set and that caused all of the errors. I’m coming from a FM background and will have to make adjustments. Thanks for the help.

Reed