Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Funny behaviour of Locate
Message
From
11/03/2002 05:38:42
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
11/03/2002 05:09:07
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00630851
Message ID:
00630858
Views:
25
>I would like to ask for hints connected with following problem.
>
>The part of code listed below searches for filepath in the table.
>Type of field SrcFile is Memo, field Backup_Id is Integer.
>Variable tcFileName has type Character, and iCurrentBackupId is declared
>as Integer.
>Search is made on unindexed table opened in default datasession as shared.
>
>Lparameters tcFileName
>
>If Vartype(tcFileName) # "C"
> Return .F.
>Endif
>
>Local llSuccess, lcFileName
>
>Select t_ExFile
>
>lcFileName = Alltrim(tcFileName)
>Locate For t_ExFile.SrcFile = Alltrim(tcFileName) And ;
> t_ExFile.backup_id = This.iCurrentBackupId
>llSuccess = Found()
>
>Select t_File
>
>Return llSuccess
>
>The problem is, that the method works properly, when running in FoxPro environment, as a part of an applicaton. After compiling the application into *.exe, Locate finds nothing.
>What should I do?

Rafal,
I would put a messagebox displaying passed tcFileName. I suspect passed tcFileName is not what you expect between app and exe (including case).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform