Francisco Morosini wrote: > > Hi Folks! > what is bad with this SQL Sentence? i try to create with the > ODBC Driver > (7.3) > > select mmsecure.*, groups.cgrpdesc from mmsecure inner join > groups on > mmsecure.iusrgroupid = groups.iid where mmsecure.icontrolid = > ?vp_icontrolid > and mmsecure.ctype == "g" > > i use Visual Foxpro. i obtain : missing value specification, i create > another views with ?vp_anothervariable without troubles
Often it is helpful to know what is ment with being bad (which error occured and so on). But here at least the == is wrong. This is no SQL for SAP DB. = is the equal-comparison-operator. And an identifier starting with ? is incorrect, too. If you want to specifiy a variable, please use a : in the beginning. May I ask you to check the reference manual: comparison: http://www.sapdb.org/htmhelp/8c/ccce18c71c11d2a97100a0c9449261/frameset.htm identifier: http://www.sapdb.org/htmhelp/04/72c564a93a11d2a97100a0c9449261/frameset.htm and parameter: http://www.sapdb.org/htmhelp/1b/2e97deb42a11d2a97100a0c9449261/frameset.htm Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
