Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALLTRIM in a sql expression of cursoradapter
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01457654
Message ID:
01457669
Views:
30
>Thank
>
>
>I try with a UDF function but Error
>
>
>      PRIVATE ab
>      Ab = CREATEOBJECT("cruflaaa.CRUFLaaa")
>WAIT WINDOW  Ab.cAlltrimAmline( "    testg                     ")  Good result
>
>
>      TEXT TO .SELECTCMD NOSHOW TEXTMERGE PRETEXT 15
>			SELECT HDBK, Hid , HDOCNO, HAMOUNT,  STR( HDOCDATE ) AS 'DATEDOC',CREATEDBY,
>			STR(Createdon) AS 'createdon' , hremint  FROM <<.TABLES>>
>			WHERE Ab.cAlltrimAmline( HDBK ) LIKE '<<Vp_in>>'
>      ENDTEXT
>
>
>But here function Ab.cAlltrimAmline NOT defined !

In your query you can only use functions defined inside the Paradox database. You can not use anything external, like you're trying to use an external object - Paradox database has no idea of the objects you create in your custom application.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform