| 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.
|
|