Hi I'm using Firebird 2.0 RC5 server and Firebird .net provider 2.0.1 .
I have this sql statement in dataset (xsd): select * from sys_mu where visible='Y' PLAN (SYS_MU ORDER SYS_MU_NAME INDEX (SYS_MU_VISIBLE)) order by uni_name When is trying to generate select generate error because PLAN word in syntax. I make some wrong or I miss something? PLAN I can use only writing mai own sql statement? Thanks, Paul ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider