Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Syntax to read a sql server used defined function in VFP
Message
 
 
À
07/04/2010 08:58:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Divers
Thread ID:
01459132
Message ID:
01459148
Vues:
41
One thing which is missing is the schema name. You should always preface calling UDFs with the schema name, so it would be

select dbo.ReadValue(@Key)

>Hello all.
>
>Can anyone help with the syntax to read a value from a sql server function?
>
>Problem:
>
>i have a Sql server function like this;
>
>
>CREATE FUNCTION ReadValue
>(
>	@Key char(10)
>)
>RETURNS decimal(16,3)
>AS
>BEGIN
>  DECLARE @Value decimal(16,3);
>  select @Value = field from table where key = @key;
>  RETURN @Value;
>END
>GO
>
>
>I can get the value in sql server using the following expression:
>
>print readValue('1234567890');
>
>
>No i want to use the returned value fom this function in VFP.
>It should be something like this:
>
>m.paramValue = "1234567890"
>m.hConn = GetSQLConnection()
>m.value2 = Sqlexec(m.hConn, "ReadValue(@Key = ?m.paramValue)")
>wait window m.value2
>
>
>Can anyone help me with this?
>
>TIA,
>Joaquim
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform