David Crooks <> wrote: > On Thursday, September 28, 2006 2:07 AM Chet Gardiner wrote: > >> Can you concatenate? > >> SQLEXEC(field1 + field1) ??? > >> Just a guess > > No, I don't see how that can work. I just want to update a couple > fields but there are other fields that are setup to not allow Nulls. > I am using the following code: > TRANSFORM(IIF(ISNULL(m.somefield),'',m.somefield)) > > Maybe I should just update the fields with a blank field and not deal > with the TRANSFORM? > Thanks!
You have to send back a full SQL statement. CRUD based in some way. You can append multiple parts of the statement in the pass back, but it has to be the whole complete syntax. Stephen Russell DBA / Operations Developer Memphis TN 38115 901.246-0159 http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.407 / Virus Database: 268.12.9/458 - Release Date: 9/27/2006 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
