I have a form that works perfectly with some custom code in Before Browse, Before Open and Before Save. However it only works when I use
SELECT * FROM table
The table has a column with only 3 different values so I wanted to make 3 different forms. When I add a WHERE statement like
SELECT * FROM table WHERE column = "value"
The browse page shows the correct records, but when I select a record I get
(nuBuilder Before Open) of formname : Error Reference: 757e7c5
An error occurred while running the following query:
DROP TABLE IF EXISTS ;
If I remove the WHERE statement from the form SQL all works well. What am I missing? Is there a better place to put the WHERE, or a filter? I've only been using nuBuilder for a couple weeks but I really like it so far.
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
SELECT WHERE causes DROP TABLE error
-
- Posts: 9
- Joined: Wed Feb 26, 2014 10:00 pm
Re: SELECT WHERE causes DROP TABLE error
I have found the problem by searching thru the forms. I cloned the form but had taken the easy way out and neglected to clone each form object and assign it to the new form. Once this was completed the form works properly with the WHERE statement included.
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact: