Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Function in an SQL
Message
 
 
To
30/08/2001 12:45:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00550952
Message ID:
00551010
Views:
24
>I have a function in an SQL statement that sends two numeric parameters to my procedure. I want to return a string value but I keep getting a data type mismatch error. Please help.

Steven,
If building a cursor, VFP will execute the SQL statement one initial time passing the first record's values (if using any). Because of the initial call, the parameter values may not be the type you are expecting. You may have to validate the paramters first before doing anything. If they aren't valid, return some default value.

HTH.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform