SELECT WHERE causes DROP TABLE error

SELECT WHERE causes DROP TABLE error

Postby ckurlinski » Fri Mar 14, 2014 10:17 pm

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: Thu Feb 27, 2014 6:30 am

Re: SELECT WHERE causes DROP TABLE error

Postby ckurlinski » Sat Mar 15, 2014 5:46 am

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.
ckurlinski
 
Posts: 9
Joined: Thu Feb 27, 2014 6:30 am

Re: SELECT WHERE causes DROP TABLE error

Postby massiws » Sat Mar 29, 2014 8:48 am

.
massiws
 
Posts: 503
Joined: Thu May 24, 2012 9:38 am
Location: Milan, Italy


Return to General



cron