As you suggested I am opening a new post for this issue. I had originally added this information to the end of a post called, “Different results for date routine on web compared to local” in the ‘Report Writer’ section. I will describe the problem again and also respond to your questions that you had in that post. I am using Build 554.
First of all, I have created an application for my user which she has been using for about 5 months. The application uses 7 tables and a number of forms and quite a few reports. I decided to create a new table and form where the user could enter in a date range or a unit number. (You may remember that their internet provider has problems with pop-up forms to enter that information so I decided to use a table and form to enter the values for the parameters.)
I created a table called, ‘parms’ with the following fields:
Code: Select all
parms_id varchar(15) – primary key
parms_unit varchar(6)
parms_from_date date
parms_to_date date
I then wanted to build a form based on the parms table. When I go to the Setup tab and click on the ‘Form Wizard’ button, I immediately get a SQL error that says,
'SHOW COLUMNS FROM `a___nu151e36e1b9492d___`'.
When I enter this SQL into phpMyAdmin, it says that the table ‘nu151e36e1b9492d ‘ does not exist. I have used the Form Wizard before to create forms but this time I do not even get to the screen that allows me to choose a table. The ‘error reference’ that I am supposed to give you changes each time I click on the ‘Form Wizard’ button.
As I mentioned earlier, the application has been in production for months so it has been a long time since I have used the ‘Form Wizard’. Therefore I don’t know if this problem has been there for a long time.
What is the best way to debug this problem?
Thanks,
John Klassen