Browse


Author
Message
Nikki Chase
Nikki Chase
StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)
Group: Forum Members
Posts: 13, Visits: 18
Hi all,

I am having a problem with the browse object not seeming to work properly.

It will return ALL records just fine, however I never seem to get any records returned when I try to search by any of the search fields.

For instance if I launch the browse dialog and hit Enter it returns all rows however if I try to filter by name starts with A it returns no results. Any ideas on what i mat be missing?

Thanks

Replies
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Nikki,

I see the problem.  This issue has been fixed and can be downloaded in the pre-release or if you wait another day we will have the "official" 1.4 released.  The problem that you are having is that your field is a fixed length string instead of a variable length field (i.e. VarChar).  When this happens, the field contents actually has spaces at the end, which produces a search that doesn't match.

We have already fixed this issue to take into account fixed length character fields.  If you want to fix to day, you can download the Pre-Release.  But it has been resolved and this is why we have been chasing our tails BigGrin

Nikki Chase
Nikki Chase
StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)
Group: Forum Members
Posts: 13, Visits: 18
Well at least I know I'm not crazy Smile Well at least not about this.

After looking at the trace i thought the issue was because of the Field type so changed it to see what would happen and bingo it worked as advertised. Glad it is resolved in the new build.

By the way great framework glad to see something like this in .Net. I have been showing it off like a new car. I plan on re-writing / converting a  fox 2.6 app with this so talk about bells and whistles to the current users.

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
I never thought for a minute that you were "crazy" Smile.  I know exactly where you are coming from though.  It is always nice to find out that it's not you BigGrin.

Nikki, I am truly excited about having you as a new user.  Thank you for your kind words.  We too are excited about the framework and its future.  It is users like you that makes it all worth while!

StrataFrame is a great tool to migrate forward for VFP users.  Let me know if you need any help on that front.  Thanks again.

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Nikki Chase - 19 Years Ago
     Hi Nikki
Gary C Wynne - 19 Years Ago
     Hi Nikki
Gary Wynne - 19 Years Ago
Gary Wynne - 19 Years Ago
Gary Wynne - 19 Years Ago
Trent L. Taylor - 19 Years Ago
Nikki Chase - 19 Years Ago
Trent L. Taylor - 19 Years Ago
                         That is exactly how it is set. Just to make sure here is a shot of...
Nikki Chase - 19 Years Ago
                             You can turn on SQL debugging to see what the actual SQL statement is...
Trent L. Taylor - 19 Years Ago
                                 Here is the result General Command Settings Command Type:...
Nikki Chase - 19 Years Ago
                                     Next question :) If you create a query through the Enterprise Manager...
Trent L. Taylor - 19 Years Ago
                                 Here what i get in Sql Profiler. exec sp_executesql N'SELECT TOP 1000...
Nikki Chase - 19 Years Ago
                                     Trent I can manualy retireve data if I change the @param to char(2)...
Nikki Chase - 19 Years Ago
                                         Nikki, I see the problem. This issue has been fixed and can be...
Trent L. Taylor - 19 Years Ago
                                             Well at least I know I'm not crazy :) Well at least not about this....
Nikki Chase - 19 Years Ago
                                                 I never thought for a minute that you were "crazy" :). I know exactly...
Trent L. Taylor - 19 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search