Support Forum

I'm about to go nuts with this buggy software. There are several things that happen randomly. The one that really gets me is when it randomly closes while in the app on a device. No errors, just closes. Now I'm getting "The table name could not be acquired from the select statement SubContractorEmployees which is needed for auto save." when trying to save a data page source. What does this mean exactly??? I AM ACTUALLY using the table name in the select statement and only the fields I want to update. When I go to save the solution, I get this error. It's a very basic select statement with a primary key and all fields are filled in that should be saved. I have been looking at this for hours now.

EmployeeID is PK and Auto Increment. The Page Source name is Employee. I have even named it SubContractorEmployees to match the actual table name, still get the error. I have all the fields set on the page linked to a control except CompanyNumber which I set just before saving.

Here is the current Select statement:

select EmployeeID, CompanyNumber, Email, FirstName, LastName, Phone, Photo, HireDate, TerminationDate, DispatchRights, TotalYearsOfService, CCTV, Intrusion, AccessControl from SubContractorEmployees where EmployeeID=:EmployeeID

I have also tried:
select EmployeeID, CompanyNumber, Email, FirstName, LastName, Phone, Photo, HireDate, TerminationDate, DispatchRights, TotalYearsOfService, CCTV, Intrusion, AccessControl from SubContractorEmployees Employee where EmployeeID=:EmployeeID

and

select * from SubContractorEmployees where EmployeeID=:EmployeeID

and

select * from SubContractorEmployees Employee where EmployeeID=:EmployeeID

I am adding .png files to view my settings. The one labeled "Interesting" show 2 Select statements that don't appear in any of the page sources. How do you delete these?

I am using Microsoft SQL Server

I am using version 6 and the 64bit designer.

This is the first single record edit/update for this table. The first page contains a list of Employees to select at which point sets a Persistent attribute equal to the primary key which is used in the select statement.

Hi AFC,
Thanks for the responses. I tried the "dbo" and that did not work. I want to mention I also have several other solutions and pages with the same kind of setup only using different tables and have not used "dbo" and they all work perfectly. This leads me to believe there is something that did not get deleted in the solution when creating and deleting page sources like the ones that were left over even though they were deleted from the page sources window. The very reason for my rant about "buggy software" at the beginning of my post as I have spent hours and hours trying different combinations of the select statements banging my head on the kitchen island (working from home during pandemic). I am going to re-create the solution from scratch, which I'm sure will be fun, to see if it proves my theory.

Hi AFC,

Thank you! You just solved my problem. I went into the schema to look at the tables and there were a handful of "user" tables I've never seen before! Where this came from, I have no idea. It's also interesting how the rest of the solution was using the same data source and was still working?!? Anyway, I created a new one and now it's working. When I try to go back to the old one I get an error "Datasource could not be resolved". Very strange! Now that I've created a new one, how do I delete any of the exsting data sources?

Actually, there is no way to delete an existing Data Source Name that I have found. In the image attached, "Response" is not used in any of the Page Sources and I am not able to get rid of it.