Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

SELECT WHERE causes DROP TABLE error

Locked
ckurlinski
Posts: 9
Joined: Wed Feb 26, 2014 10:00 pm

SELECT WHERE causes DROP TABLE error

Unread post by ckurlinski »

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.
ckurlinski
Posts: 9
Joined: Wed Feb 26, 2014 10:00 pm

Re: SELECT WHERE causes DROP TABLE error

Unread post by ckurlinski »

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.
massiws
Posts: 503
Joined: Thu May 24, 2012 2:08 am
Location: Milan, Italy
Contact:

Re: SELECT WHERE causes DROP TABLE error

Unread post by massiws »

.
Locked