Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
What's the proper syntax for SQL select in CREATE SQL VIEW?
Hi,
Stuck again!
I created a remote view. All output fields are fine except that an SQL field varbinary(3) is being converted to VFP MEMO(Binary). I need it to be converted to VFP CHAR(Binary). I tried the View Designer - got the FVP CHAR(Binary) but I can't get my filter to work. Hard coded the CREATE SQL VIEW; filtered worked but crested VFP MEMO(Binary). Could not how to tell the SELECT to Output VFP CHAR(Binary).
As I tried to explain I can't seem to find a way to accomplish it.
How would you HARD CODE the CREATE SQL VIEW for the remote connection;
SELECT sql.field as new_field vbinary(6) ;
Thanks in advance!
Roland
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