Visual FoxPro SQL Queries - ERROR: Missing file "g

Author

ERROR: Missing file "g_retsdx.prg"

Jeff Tolman

2005-09-27, 8:25 pm

Hi,

I have a .NET application that I'm using to query a VFP table and, after it
has been working, I am getting a "g_retsdx.prg" file does not exist error.

Is there someone who can explain this error to me and tell me how to fix it?

Thanks!

Jeff Tolman

Fred Taylor

2005-09-28, 3:25 am

Sounds like you're using SBT (or maybe ACCPAC) still using an index that has
a user defined function. You need to make that routine available in order
to even be able to sucessfully open your table.

The g_retsdx was nearly a useless function, certainly not worthy of causing
your table to not open.

Here's an improved version of their routine I wrote a long time ago (over a
dozen years ago!) you can use.

* g_retsdx
*
* Build a soundex string based on the words in a source string
*
* Calling sequence:
* sndxstr = g_retsdx(source [, nwords])
*
* Where:
* source - Source string of words
* nwords - # of words to use (optional, default = 3)
*
* Returns:
* sndxstr - Soundex string for each word
*
* Modification History:
* 12/18/92 FBT Based on SBT's routine, but my code
*
FUNCTION g_retsdx
PARAMETERS lc_source, ln_nflds
*
* All variables are PRIVATE
*
PRIVATE ALL LIKE l?_*
*
* See if optional # of words
*
ln_nflds = IIF(PARAMETERS()>1,ln_nflds,3)
*
* Initialize as needed
*
lc_sndx = ''
ln_start = 1
*
* For each word...
*
FOR ln_x=1 TO ln_nflds
*
* Locate a word
*
ln_end = AT(' ',lc_source,ln_x)
*
* Add this word to result
*
lc_sndx = lc_sndx + IIF(ln_end>0,;
SOUNDEX(SUBSTR(lc_so
urce,ln_start,ln_end
-ln_start)),;
SOUNDEX(SUBSTR(lc_so
urce,ln_start)))
ln_start = ln_end
ENDFOR
RETURN lc_sndx

--
Fred
Microsoft Visual FoxPro MVP

"Jeff Tolman" <jeff.tolman@enm.com> wrote in message
news:%23%23nWiq8wFHA
.3188@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> I have a .NET application that I'm using to query a VFP table and, after
> it has been working, I am getting a "g_retsdx.prg" file does not exist
> error.
>
> Is there someone who can explain this error to me and tell me how to fix
> it?
>
> Thanks!
>
> Jeff Tolman
>

Sponsored Links