General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using a UDF in a SQL Select
I want use a UDF to create a new variable in a SQL select statement to crate a cursor for a
report. The UDF would also be used to update a table using SCAN/ENDSCAN latter on.
Calculation depends on 4 fields. I tried something like
SELECT a,b,c,d,e,f,udf() as name from table
to test it. Only one value is return (one calculated for first record). Do I have to pass
all the fields to the UDF and use local variables? Did look at documentation, It is not
clear on how to do this.
TIA.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only