Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PManion

    Why does a deployed report need local database connection?

    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...
  2. PManion

    Can Bulk Insert work on a table with Identity field?

    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?
  3. PManion

    Fastest way to populate a table?

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

    Fastest way to populate a table?

    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...
  5. PManion

    Delphi and Oracle!

    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
  6. PManion

    Does Delphi have the equivalent of a VB inputbox?

    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...
  7. PManion

    How do you enable a report to change its MS SQL server and database?

    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
  8. PManion

    How do you enable a report to change its MS SQL server and database?

    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...
  9. PManion

    Report states "No rowset was returned..." after deployment

    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...
  10. PManion

    Report states "No rowset was returned..." after deployment

    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...
  11. PManion

    Deleting record from ADO/SQL Server table raises exception

    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
  12. PManion

    Deleting record from ADO/SQL Server table raises exception

    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)...
  13. PManion

    Deleting record from ADO/SQL Server table raises exception

    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...

Part and Inventory Search

Back
Top