Subject Re: indexing with character numbers
From Ken Mayer <dbase@nospam.goldenstag.net>
Date Mon, 27 Jan 2025 20:39:08 -0800
Newsgroups dbase.getting-started

On 1/27/2025 2:47 PM, Charlie wrote:
> Hi Ken..  I tried  'index on category+val( str( id, 12, 0 ) ) tag test'
>
> But it didn't seem to work.  Although I could have done something wrong.  I am not replacing all.  I am only replacing when the user enters new data.  It seems to work well.  Thanks for your help.

Actually the val() function probably isn't necessary there, that's
getting the numeric value from the string, and you really want just the
string. Too much on my part. ;)

Ken

--
*Ken Mayer*
Ken's dBASE Page: http://www.goldenstag.net/dbase
The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm
dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm
dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm
dBASE DOS to Windows Tutorial:
http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm