>>>>Using macro substitution inside a query is a bad idea anyway because it forces SQL to evaluate the macro for every row, and slows the query dramatically. HTH
>>>
>>>Erik, are you sure about this? If yes, then try some quick test.
>>>Actually, this is UDF which might be evaluated for each row.
>>
>>Ed, Thanks, but how can I look at the SQL statement while it is running? I know this isn't the best way to use SQL, but this way give the user more flexablity.
>
>Here, I have to ask you. What do you mean saying 'look at the SQL'. Surely, you can bring SQL command syntax into some Editbox that a user can view it. Is it what you are looking for?
I am converting some pl/1 report programs to VFP 5.0 which use many different variables. I have put made methods that read a lookup table where most of the variables are stored. I want to be able to see the result of the methods in the select statement. I am not getting the results I expect, I want to see what is in the select statement.
Or maybe, is there a better way to debug this problem.
Previous
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