Subject Re: spinbox From Charlie <tm@tc.com> Date Tue, 18 May 2021 21:38:04 -0400 Newsgroups dbase.getting-started One other thing...  the findkey may look backwards but I have tried it both ways and it doesn't work correctly either way. Another question..  Where is the ini file for dbase located?  Having a stupid problem I need to fix..... Charlie Wrote: > I am having problems withe the following code: > > function PUSHBUTTON1_onClick() >         a = form.auctopen1.rowset >         m = form.master1.rowset >         cEbay = form.spinbox1.value >         if lennum(form.spinbox1.value) > 11 >            a.findkey(cEbay) >                 msgbox( ""+cEbay ) >                 if not a.findkey(cEbay) >                    //a.first() >               msgbox( "success" )//do stuff >                 else >                    msgbox( "Failed entry! "+cEbay+ " is a duplication." ) >                    return >                 endif >         else   >            msgbox( "Failed entry! "+form.spinbox1.value+" entry must have 12 digits in Ebay number." ) >            return >         endif > > I don't think I have ever done a findkey on a numeric field before.  Seems like it comes back with decimals.  I am trying to force idno to not duplicate.  The problem is this isn't working correctly.  Seems to force decimals where the field doesn't allow decimals.  Is there a secret to findkey using numbers?  The code isn't finished yet.  I just want to get past this before giving it finishing touches.  Thanks for any help.