Hi, Yes, it's a solution but I want to test the two approachs (in VB and in SQLite with an extension) to choice the faster. Before, I worked with VB6 and Access and the faster way is to use the calculation possibilities of Access. I want just try it with VB .Net and SQLite. But I'm not able to build the extension and thus test the 2 approachs.
Best regards, Thibaut. 2009/4/9 John Machin <[email protected]> > On 10/04/2009 12:34 AM, Thibaut Gheysen wrote: > > Hi, > > > > I develop a windows mobile application in VB .Net (compact framework 2.0) > > with SQLite and the ADO.net provider. In this application, I must > calculate > > the distance between 2 points for all items of a table. For this I need > > "power" and "sqrt" function but these functions doesn't seem to be > include > > in SQLite core functions. > > That's why it has "Lite" in the name. > > > I have found the "extension-functions.c" in the > > contrib page of the SQLite website but I'm not able to build it for > windows > > ce. Anybody can help me ? > > > > DBMSs are for storing data and doing *elementary* calculations on the data. > > Why don't you do the calculation in VB? > > Cheers, > > John > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
