Search results for query: *

My company has an application that uses MS SQL Server as the database, and Crystal Reports 8.5 as the report engine. I am having difficulty debugging CR problems in this application and I could use some help. Ideally I would like the user of an application to select a SQL Server datasource...

Is it possible to do a Bulk Insert on a table that has a field with the Identity attribute? I have been trying to find a fast way to load data to a table with an autoincrementing field and had no luck. Any suggestions?

Thank you, Cheyney. I had forgotten about DTS. I will give it a try.

I am searching for a rapid way to populate a SQL Server table. I am working in an application that manipulates data in ADO record sets, and then writes the data to disk with a call to UpdateBatch. The ADO code handles this by creating a SQL INSERT statement for every record in the table. This...

A Dutch company called Allround Automations has a nice product called Direct Oracle Access, which is a suite of components for accessing Oracle databases, bypassing the BDE. The weblink is www.allroundautomations.nl/doa.html. I hope this helps! Patrick Manion

The Delphi unit Dialogs contains a number of routines for simple text output. I usually use ShowMessage, which just takes a string parameter; there is also MessageDlg, which has a few extra parameters for adding buttons and such. Both of these require the Dialogs unit to be in one of the...

Paul, Thanks so much. This appears to be the solution I was looking for. I might have searched forever and not stumbled upon it. Jdemmi, what is this utility you are referring to? Patrick

Our company's application has 18 Crystal Reports which access a SQL Server database using the OLE DB driver. However, one of these reports is not working correctly when the program is installed at the user's site. Normally when these reports are created, CR stores the reference to the local...

Bruce, Thanks for the reply. I saw an article in the CR Knowledge Base that made similar suggestions. But this problem doesn't seem to be isolated to stored procedures. I am now pointing the report to a table, and it still fails. I may be on the wrong tack altogether. I think the problem...

Our product uses Crystal Reports as our report designer. Since our customers want to be able to customize these reports, we are requiring them also to purchase Crystal Reports. We have a problem with one of our reports which is causing some difficulty with redeploying the program to another...

That fixed it! I only had to change the CursorLocation from client-side to server-side, since the other properties were already as you recommend. Many thanks. P. Manion

I tried your suggestion but the problem remains. I tried using (1) TADOTable with TableName <tablename>, (2) TADODataSet with CommandType cmdTable and CommandText <tablename>, (3) TADODataSet with CommandType cmdTableDirect and CommandText <tablename>, and (4)...

I am using Delphi 5.0, accessing MS SQL Server 7.0 via the ADO components. On my form I have a TDBGrid, a TDBNavigator, a TDataSource, a TADOTable, and a TADOConnection object. My wish is to add, change, and delete records from the SQL Server table via the grid. However, whenever I attempt to...