I'm not sure where to look to figure out this error message:
The specified record was not found. Server response failed (sql table): resource not found
and then sometimes I get: An entry is required or has an invalid value
When I go back to the sheet that has the form, the error is in the button which pushes the data to sql:
OnSelect Property
Navigate(scrForm2_EQRAttach,ScreenTransition.None); SubmitForm(Form1)
The bolded above has the error message with a red line. I've confirmed the table name is correct. All of the cards in the form have the correct name as the column names in SQL. The form name is correct. Where else should I look?
What can I provide that would be helpful?
As an update:
I've deleted all of the cards in the form but the date and I am still getting the error. Here is what I have for the form:
Name: Form1
OnSuccess: Set(varRecord,Form1.LastSubmit);Navigate(scrForm2_EQRAttach,ScreenTransition.None)
DefaultMode: If(varFormMode="edit",FormMode.Edit,varFormMode="view",FormMode.View,FormMode.New)
Item: varRecord
OnReset: False
OnFailure: False
The SQL table it should be posting to:
[StartDate] [datetime] NULL,
[BidAgency] [varchar](200) NULL,
[BidCode] [varchar](20) NULL,
[OppAccount] [varchar](200) NULL,
[OppName] [varchar](200) NULL,
[OppNumber] [varchar](30) NULL,
[ProjName] [varchar](200) NULL,
[ProjMgr] [varchar](200) NULL,
[ProjDir] [varchar](200) NULL,
[ProjPartner] [varchar](200) NULL,
[EQRPartner] [varchar](200) NULL,
[EQRPartnerIfNa] [varchar](200) NULL,
[OMPExempt] [varchar](5) NULL,
[CustNumber] [varchar](10) NULL,
[CustNameIfNa] [varchar](40) NULL,
[Agency] [varchar](200) NULL,
[AgencyIfNa] [varchar](30) NULL,
[GSAYesNo] [varchar](5) NULL,
[GSASched] [varchar](200) NULL,
[GSASchedBPADeliveryPOTO] [varchar](500) NULL,
[ContractNumber] [varchar](200) NULL,
[DeliveryOrderTO] [varchar](500) NULL,
[ClientGT] [varchar](20) NULL,
[Loc_Address] [varchar](200) NULL,
[Loc_City] [varchar](200) NULL,
[Loc_State] [varchar](200) NULL,
[Loc_Zip] [varchar](200) NULL,
[GTOffice] [varchar](10) NULL,
[Market] [varchar](20) NULL,
[LLPLLC] [varchar](100) NULL,
[SolutionCode] [varchar](10) NULL,
[SolutionOther] [varchar](200) NULL,
[Split1] [varchar](10) NULL,
[Per1] [float] NULL,
[Split2] [varchar](10) NULL,
[Per2] [float] NULL,
[Split3] [varchar](10) NULL,
[Per3] [float] NULL,
[SplitAgree] [varchar](10) NULL,
[UnbillableCodes] [varchar](5) NULL,
[UnbillableComment] [varchar](max) NULL,
[OtherComment] [varchar](max) NULL,
[ID] [int] IDENTITY(1,1) NOT NULL,
[EntryUser] [varchar](10) NULL,
[EntryTimestamp] [datetime] NULL,
[PAFProjEntryStatus] [varchar](20) NULL,
[Staffing] [varchar](10) NULL,
CONSTRAINT [PK_App_PAFNewProj_Main] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[App_PAFNewProj_Main] ADD DEFAULT ('Draft') FOR [PAFProjEntryStatus]
GO
