Re: Manually Adding a Row to a Resultset

Potter said: > > I am querying an Informix database via Sequelink and I want to manually > add a > row to my recordset. In SQL Server, I would use a UNION clause like > this: > > > SELECT > Field1 as ValueField > ,Field2 as DescField > FROM TableA > UNION > SELECT > Null as ValueField > ,'All' as DescField > > Is there similar syntax for Informix? Version? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ` dire qu'il faut fermer sa gueule" - Coluche did i mention i like nulls? heck, i even go so far as to say that all columns in a table except the primary key could/should be nullable. this has certain advantages, for example, if you need to insert a child record and you don't have a parent row for it, just do an insert into the parent table with the primary key value (everything else null), and voila, relational integrity is preserved. but this is, admittedly, a bit controversial among modellers. --r937, dbforums.com sending to informix-list