Hi there Has anyone done (or tried doing) ODBC in an MB application using the SQLPrepare + SQLExecute technique? If so, could you let me / us know how you got on? Any hints, or examples? To explain, from reading various documentation on ODBC it looks like there are two ways to "do" odbc. (Feel free to correct me if I have mis-understood anything here). One is to compose your sql and execute it on the server (using a ODBC API function SQLExecDirect). The appears to be how MI/MB does it behind the scenes, although standard MB puts nice wrappers around the ODBC API. The other way is to compose a statement effectively with variables in it, the server creates a temporary stored procedure to perform your SQL, and the values for the variables are retrieved at run time. This is apparently heaps faster if you are doing a statement repeatedly, and I can see some other potential advantages. I would like to try this, but I'm feeling my way through Great Darkness (including the msdn web site through a very thin internet connection). Any help much appreciated. Cheers Mark O. ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
