I need to call some Stored Procedures from Delphi and because they are related I have to use transactions.
I have an accuracy problem with a reporting tool that I\'m using. The issue is that it is reading in data from a TADODataset on the fly but converting the ftBCD fields into doubles.
Final answer: This was not a Delphi problem, just configuration. I use Xampp to provide the MySql server.
Ok so this is a really complicated problem, I will try my best to explain. We have a c++ application which communicates with Sql Connection like so:
I have a application with working in acces开发者_StackOverflows (.mdb) my connection is madeusing Microsoft.Jet.OLEDB.4.0 and i nead to export a MasterTable and detailtables (1,2,3) to XML is it possi
I have an Access 2003 project in which all data is stored in SQL Server 2008. I am using ADO to view/update data via forms that are completely unbound. For example, a form has several textboxes and co
I\'m referencing the following dll in a VB6 dll I\'m creating: Microsoft ActiveX Data Objects 2.8 Library
One of my users wants to get data into Excel from SQL 2008 query/stored proc. I never actually did it before.
I want to empty a temporary table, load it via bcp, and then modify its rows before moving to a production table. The commands would look something like this:
I have a stored procedure on SQL Server 2000. It contains: select ... into ##Temp ... ... drop table ##Temp