Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Textmerge is recursive
Message
From
10/04/2006 13:31:41
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
10/04/2006 13:00:13
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01111919
Message ID:
01112085
Views:
14
>>>>Are you using
<<lcSql>>
inside TEXTMERGE?
>>>
>>>
>>>TEXT TO lcSql TEXTMERGE NOSHOW
>>>	select * from udf_Function(<<parameter>>)
>>>ENDTEXT	
>>>This.mExecuteSqlCommand(lcSql, 'curCursor', '')
>>>
>>
>>What is the exact code and the value of the 'parameter' in case when you get the errror?
>That's the exact code. Parameter value is an integer. But it might have a problem. So, why would it cause recursive problem?

Mark,
1) Replace parameter with m.parameter
2) You don't need text...endtext there
lcSQL = "select * from udf_Function("+trans(m.parameter)+")"
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform