WATCH NOW: Informix 14.10 for App Dev
Posted in 2020
Topics: General Discussion
Hey Everybody! Thank you for attending my webcast Informix 14.10 for App Dev. If you have any questions that we did not get to in the Q&A, please leave them below. For those who were unable to attend, watch the full webcast here and download the slides here . Thanks, ------------------------------ Brian Hughes ------------------------------ #Informix
hi Brian, thank you for this very interesting presentation. I would your advice about switching a web application using .net, odbc and sqli to a .net drda without rewriting to many sql statements ? thanks for you reply. regards Jacques Rage jacques.rage@pedab.fr ------------------------------ jack rage ------------------------------
When it comes to actual SQL statements, you usually don't need to rewrite them to switch drivers. The drivers should send the statements to the server for processing so as long as the server remains the same (i.e. Informix), you should not need to do much if any rewriting of SQL statements that I know about. One difference you might see is if you are using any custom types (SET/LIST, user defined types, etc) as the support may very between the two drivers. Some other differences might be the format of date/time values if you request the data back in character form vs an object that you can format yourself. ------------------------------ Brian Hughes ------------------------------