Sybase Connector about sqlpp11 HOT 8 CLOSED

How you implement those "bind" calls is up to the requirements of the database.

What you write about Sybase sounds like the way that sqlite does it, too. Can you take a look at the sqlilte3 connector and see if that matches? You might also take a look at the two different result types in the mysql connector. The bind_result, which is used for prepared statements, could be similar (in fact, the basic idea is pretty much the same as with the sqlite3 connector).

Let me know :-)

Regards,

Roland

from sqlpp11.

Currently I have looked at SQLITE3 and there I found out, that there is no real binding. SQLITE3 extecute the statement, gets the row and THEN gets the value from the result set column into the variable seperately ... as far as I have understood this.

In Sybase I have to bind the variables BEFORE any row is read. Therefore infact, there is no need to do anything when a row is fetched.

But I will try to get the MySQL stuff tomorrow to see, if it different there.

BR Michael

from sqlpp11.

I think I understand the idea better now. The MySQL stuff is a bit different from sqlite3, but still not exactly what you are looking for.

But it should be possible, though. You could do the binding when the first row is fetched and do nothing for all following rows...

Best,

Roland

from sqlpp11.

Going through the current issues, I wondered if you are still interested in creating a connector to Sybase? It should certainly be possible and might be even more interesting now, with that pull request that will allow compilation with MSVC.

Let me know if I can help.

Cheers,

Roland

from sqlpp11.

Well, I have created the connector within a project in a company, so it is up to them to upload this connector. Their development network have had no access to the WWW for me, so I could not upload it here, sorry. Works fine, added new error handling instead of raising exeptions which speeds up the processes.

BR
Michael

from sqlpp11.

OK, the good news is: It is definitely possible :-)

Alternative error handling sounds interesting, too, of course.

Best,

Roland

from sqlpp11.

This is also on my wishlist.

from sqlpp11.

I am compiling a wish list. This goes onto it.

Closing the ticket.

from sqlpp11.