General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Then REMOTE view should help. Something like:
create data hi
create connection vfphello connstring (;
'Driver={MICROSOFT VISUAL FOXPRO DRIVER};'+;
'SourceDB=C:\Foxwork\Vfpapps\;'+;
'SourceType=DBF')
CREATE SQL VIEW hello REMOTE connection vfphello share aS;
SELECT *;
FROM RECLIST;
WHERE nIDnumber = 1234567
use hello && table is not open
>We choose the specific record based on a field name nIDnumber; the table is indexed on this field.
>
>This is what I tried:
>
>OPEN DATABASE DBNAMES
>
>CREATE SQL VIEW ViewOneRecord AS;
>SELECT *;
>FROM DBNAMES!RECLIST;
>WHERE nIDnumber = 1234567
>
>
>However, if I "DISPLAY STATUS", I find that the big table is open (as well as the database).
>
>CM
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only