Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2000 Server
I am using the modify data command of the DBC and then select add remote view.
Where do I put the CAST(TableA.Vendor_number) as int
I thought I would try to change it in the JOIN tab by going to the bottom of the fields and building an expression.
I use cast( Original_ap_invoices.VENDOR_NUMBER) as int
and then hit verify and it says expression OK.
When I try to save the view it says incorrect syntax near expression ‘CAST’, expected ‘AS’
If I use cast( Original_ap_invoices.VENDOR_NUMBER as int)
then it tells me missing )
I am getting CLOSE, but close only counts in horse shoes, hand grenades and atomic bombs. With the SQL syntax it is 100% or ZERO.
Précédent
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