General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>When I try it (VFP9):
>
>CREATE SQL VIEW TEST REMOTE AS SELECT * FROM VWBILLREPORT WHERE isalesdocid IN (&inItems) CONNECTION 3PConnect
>
>I get:
>
>Connectivity error: [Sybase][ODBC Driver][Adaptive Server Anywhere]Syntax error near '&' on line 1
>
>Mark
>
>
>It works for me.
>
>PUBLIC inItems
>inItems = '1,2'
>CREATE SQL VIEW TEST REMOTE AS SELECT * FROM TABLE WHERE id IN (&inItems) CONNECTION ....
>USE TEST
Sorry I had forgotten it, VFP have a bug here:
if inItems exists it replace the &inItems into the defined view,
otherwise it leave the &inItems as it is.
Use a CursorAdapter.
Previous
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