Subject spinbox
From Charlie <tm@tc.com>
Date Tue, 18 May 2021 21:33:03 -0400
Newsgroups dbase.getting-started

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.