Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there something like EVALUATE() fox function ?
Message
 
 
To
26/06/2006 12:29:33
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01131426
Message ID:
01131749
Views:
23
You're welcome.

>Perfect!
>I will use it.
>Thanks.
>
>>
>>You can build something similar to VFP TEXRMERGE
>>
>>DECLARE
>>	@expr 		varchar(100),
>>	@sql 		nvarchar (200),
>>	@yUsaAmt 	money,
>>	@ySpecialChrg 	money,
>>	@yResult 	money;
>>	
>>SET @expr = '(<<@yUsaAmt>> * 0.05) + <<@ySpecialChrg>>';
>>
>>SET @yUsaAmt 	  = 150.00;
>>SET @ySpecialChrg = 3.00;
>>
>>SET @expr = REPLACE(@expr, '<<@yUsaAmt>>', CAST(@yUsaAmt AS varchar(20)));
>>SET @expr = REPLACE(@expr, '<<@ySpecialChrg>>', CAST(@ySpecialChrg AS varchar(20)));
>>
>>SET @sql = N'SET @yResult = ' + @expr;
>>EXECUTE sp_executesql @sql,
>>		N'@yResult money OUTPUT',
>>		@yResult OUTPUT;
>>
>>SELECT @yResult;
>>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform