This code works fine when I use a desktop application. All I did was point it to the CubeSQL instance and it’s giving me a Nil for the Prepared Statement.
I’m using the USE DATABASE command. That was my first suspect. At any rate the CubeSQL seems to work with SQL commands just fine. I was doing some performance testing comparing Desktop(SQL only) to CubeSQL(SQL only) to CubeSQL(using ORM classes). For what it’s worth there’s a slight penalty using the CubeSQL. The desktop comes to .006 seconds while CubeSQL is .008. That’s for a simple query bringing back 2500 rows without an index.
Obviously I haven’t gotten the ORM to run but I expect a significant lag.