Are you sure that value stored in thisform.dcno is correct? Try
csql = [Select * from Accounting!datacenter where dcno = nnn]
where nnn is an existing value in dcno field.
>Hi Sergey,
>
>I also tried this command but does not work either
>
>nHandle = Sqlconnect("bbfsdsn")
>>csql = [Select * from Accounting!datacenter where dcno = ] + Alltrim(Str(thisform.dcno))
>>nResult = Sqlexec(nHandle, cSQL, 'cur_result')
>>Select cur_result
>>Browse
>
>this command displays no records...
>
>but when i change the csql to [Select * from Accounting!datacenter]
>There records are displayed perfectly.
--sb--