Information générale
Titre:
Problem with view in Foxpro 5.0
I create view with view designer wizard named "Customer Listing" while saving it.
I just select all Field from customer table so it's like
CREATE SQL VIEW AS SELECT * From MyDBC!Customer
Now If I wish to use this view as
OPEN DATABASE MyDBC
USE Customer Listing
then it gives erro; "Command contains unrecognized phrase/keyword." These type of views are
used with drag & Drop method. What am I doing wrong here? Please guide me.
Note: There is a white space between Customer and Listing in the view name "Customer Listing".
If I create view
CREATE SQL VIEW lv_CustomerListing AS SELECT * From MyDBC!Customer
OPEN DATABASE MyDBC
USE lv_CustomerListing
then it's work fine.
Note: There is no white space in the view name.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement