Viewing 6 posts - 1 through 6 (of 6 total)
oops
insert into forms
select 1 , 'Login' union
select 2 , 'Main Form'
thats what happens when you rush
October 6, 2005 at 8:59 am
#595509
should be
select 1 , 'Main Form'
and
select
f.FormName
, b.buttonName
, '' as LabelName
from forms f
inner join buttons b on b.fid = f.fid
union
, ''...
October 6, 2005 at 8:57 am
#595508
Hi,
is this what you want ?
drop table forms
drop table labels
drop table buttons
go
create table forms ( fid int , formName varchar(20))
create table buttons ( fid int , bid int , buttonName...
October 6, 2005 at 8:51 am
#595506
All,
thanks for your input.
I will work on a variation of Lee's stored proc and stick with the trigger until I get it working
Thanks for everything
gareth
October 6, 2005 at 8:33 am
#595493
Phil,
yes, brilliant idea unfortunatelty the schema is locked down and cant be changed ( well at least for next 12 months).
Lee,
I am unable to lock the table because it is...
October 6, 2005 at 7:32 am
#595459
ok, I'm not sure this would work, if two users were both executing procedure and filling table at same time then this
SELECT new.cntr
FROM myTable new
WHERE...
October 6, 2005 at 7:08 am
#595440