>Dear Programers
>
>Table1 has following column
>
>bonds c(6)
>and data in this column is as under
>
>002348
>125740
>167211
>289262
>874526
>
>now there is PDF file (Prize Bond Draw List) on this location
>
>d:\15-02-2011,%20Rs.1500.pdf
>
>I want to search table1 data from this pdf file.
>
>At last, all matching numbers to a new cursor.
>
>Thanks
To match records between two tables, you can use a JOIN clause with the SQL SELECT command (see help under SELECT - SQL). Example:
select Pdf.*;
from Pdf join Table1 on Pdf.CommonField = Table1.CommonField;
into cursor Temp
An alternative is using a subquery:
select * from Pdf;
where CommonField in (select CommonField from Table1);
into cursor Temp
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
