General Command Settings
Command Type:	Text
Object Type:	System.Data.SqlClient.SqlCommand
Connection String:	Data Source=APOLLO\sql2005;Initial Catalog=payroll;Integrated Security=True;Persist Security Info=False;Asynchronous Processing=True
Transaction:	False
Command Settings
CommandText:	SELECT TOP 1000 [cu_pk_id], [cu_fk_sm_id], [cu_id], [cucode], [cutype], [cuname], [cuaddr], [cuadl2], [cucity], [custat], [cuzipc], [cubaddr], [cubadl2], [cubcity], [cubstat], [cubzipc], [cucraprvd], [cuterms], [cutdays], [cubuconame], [cubucophon], [cubucoextn], [cuapconame], [cuapcophon], [cuapcoextn], [cuauthot], [cuauthfone], [cufaxfone], [cu800fone], [cunextjo], [cufrstused], [culastused], [cucurbalnc], [cuo30balnc], [cuytdbilng], [cu90dbilng], [cucredlim], [cucredopn], [cucomment], [custateid], [sm_id], [cudispcnt], [cudisdays], [cuactid], [culastupdt], [cu_Use_Main] FROM [dbo].[customer] WHERE [cuname] LIKE @PARAM0;
Command Parameters
@PARAM0:	A% (AnsiStringFixedLength)

If you create a query through the Enterprise Manager or SQL Management Studio, do you get any data back?  Are there any records that begin with "A"?  To prove this you can manually open your table and look or execute the query directly on the server.

To prove it you can copy the SELECT statement that is created and paste into the SQL Enterprise Manager or SQL Management Studio query window and replace the @PARAM0 with 'A%' and see if you get any results.  There is nothing wrong with the SELECT statement, so we need to investigate the server and the data a little more closely.

Let me know what you get.  Thanks

exec sp_executesql N'SELECT TOP 1000 [cu_pk_id], [cu_fk_sm_id], [cu_id], [cucode], [cutype], [cuname], [cuaddr],
[cuadl2], [cucity], [custat], [cuzipc], [cubaddr], [cubadl2], [cubcity], [cubstat], [cubzipc], [cucraprvd],
[cuterms], [cutdays], [cubuconame], [cubucophon], [cubucoextn], [cuapconame], [cuapcophon], [cuapcoextn], [cuauthot],
[cuauthfone], [cufaxfone], [cu800fone], [cunextjo], [cufrstused], [culastused], [cucurbalnc], [cuo30balnc],
[cuytdbilng], [cu90dbilng], [cucredlim], [cucredopn], [cucomment], [custateid], [sm_id], [cudispcnt], [cudisdays],
[cuactid], [culastupdt], [cu_Use_Main] FROM [dbo].[customer] WHERE [cuname] LIKE @PARAM0;
',N'@PARAM0 char(40)',@PARAM0='A%                                      '

exec sp_executesql N'SELECT TOP 1000 [cu_pk_id], [cu_fk_sm_id], [cu_id], [cucode], [cutype], [cuname], [cuaddr],

[cuadl2], [cucity], [custat], [cuzipc], [cubaddr], [cubadl2], [cubcity], [cubstat], [cubzipc], [cucraprvd],

[cuterms], [cutdays], [cubuconame], [cubucophon], [cubucoextn], [cuapconame], [cuapcophon], [cuapcoextn], [cuauthot],

[cuauthfone], [cufaxfone], [cu800fone], [cunextjo], [cufrstused], [culastused], [cucurbalnc], [cuo30balnc],

[cuytdbilng], [cu90dbilng], [cucredlim], [cucredopn], [cucomment], [custateid], [sm_id], [cudispcnt], [cudisdays],

[cuactid], [culastupdt], [cu_Use_Main] FROM [dbo].[customer] WHERE [cuname] LIKE @PARAM0;

',N'@PARAM0 char(2)',@PARAM0='A%'

Or

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

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.

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.