Tracy, thanks for response It seems to me, if the input data does not exist, it always returns blank Therefore, neither append, nor insert will work
On Thu, Oct 2, 2014 at 11:30 AM, Tracy Pearson <[email protected]> wrote: > Sytze de Boer wrote on 2014-10-01: > > I have a combo box > > Controlsource=wintemp.pcode (temporary table) > > Rowsource=winpcodes (free standing table) > > Rowsourcetype=2 - alias > > BoundTo=.t. > > > > In the valid event, i have > > > > mPcode=wintemp.pcode > > > > SELECT winpcodes > > SEEK mpcodes > > IF !FOUND() > > trt=MESSAGEBOX(ALLTRIM(mPcode)+' does not exist in the analysis > > table. Do you want to ADD this?',4+32,'Good idea') IF trt=6 > > APPEND BLANK > > REPLACE code WITH mPcode > > ENDIF > > endif > > sele wintemp > > > > My problem is > > If mPcode is not found in the winpcodes table, it places a BLANK item in > > the winpcodes file > > > > It seems not to matter if BoundTo is True or False > > > > Any ideas anyone? > > > > Sytze, > > Why not use an Insert command instead of the Append/Replace? > Since the table is attached to a control, the row may or may not be moving > to the appending record. > > Tracy Pearson > PowerChurch Software > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cag1nny9snuttidodbpot0fruex6tsg3rmevk-whe7r5btym...@mail.gmail.com ** 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.
