Search results for query: *

Are there any system tables in InterBase that would give me information about the database itself? I'm looking for something that would help me return data that I can incorporate into a report that would identify the database to the reader. I'm thinking the best thing would be database...

In a stored procedure, we are converting a char field to a numeric. Before conversion, I want to check to see if the field can be converted. Is there a way in Interbase to check this? Maybe something like the "is null" test?

I have a problem that in some of our reports, we end with a group that occasionally will page break after the group header and before the first detail section. We want to eliminate this group header from printing at the bottom of the page, either by suppressing it or moving the page break to...

Dynamically change ODBC driver / datasource for the report? We are using Delphi, Interbase and Crystal Reports 9. In our Win32 product, we use a Crystal VCL which passes the report parameters and the database connection string to the report. This way we develop our reports using an ODBC...

I want to add a record to a table (through a sql stmt/script) and one of the fields is a blob field. I want to put text in the blob field that has multiple lines. How do I break the lines? E.g. if only one line, my insert would look like: INSERT INTO TABLE1(ID, BLOBFIELD) VALUES...

Is there a way, in a script, to check if a stored procedure already exists? What I want to do is either create or alter a stored procedure. Create, if it does not already exists. Alter, if it does exists. So I'm thinking if the script can see if it exists then it can drop it. Then I can use...

I have a strange problem. We are using Delphi 5, CR9 and the CR9 crpe32.dll with a VCL wrapper. Delphi temporarily overrides the ODBC settings for the ODBC datasource that the reports use. This normally works fine. However, in this case the program calls the same report multiple times with...

Environment: Application written in Delphi Crystal 9 Datasource is Interbase stored procedure The Delphi application passes parameters to the report, which passes them to the InterBase stored procedure. After a reboot of the PC, the first time the user chooses this report in the Delphi app...

Hi, I had posted in a Crystal forum, but I think it's more of a Delphi or Interbase issue (not sure if I should post here or in the Interbase forum, so I'm trying here first). Sorry for reposting, but I think this is the better place to post (One person has been trying to help from the other...

Hi, I hope this is the right forum (wasn't sure if it should be here, in the Interbase forum or in the Delphi forum). Here is the situation: I have a Crystal report (v9) that calls a stored procedure in Interbase 7.5. If I run the stored procedure in IB Expert, it runs fine. If I run the...

I have done this in the past with SQL Server and it works on IB7, but does not work on IB6. Can someone help me with the correct method to do this in IB6? I have: select field1, (case field2 when 1 then 'Text1' when 2 then 'Text2' when 3 then 'Text3' else...

I've been using MS SQL Server for a while and am quite comfortable doing complicated stored procedures. I am now required to do similar work in InterBase. I am running into some problems since the syntax is often different and many of the functions and command available to me in SQL Server are...

In 8.5, you could choose/highlight multiple fields. Then right click on one of the fields and choose format. All the fields would then end up with the same format settings (e.g. font, number format, etc.). I found this to be extremely useful for getting a consistent look. I am now working with...

I want to find out the position number of a particular record (Me.BindingContext(objCorpHO, "Corp_ho").Position). I have a form that I created with the "Data From Wizard". It is based on one table and shows some of the fields in that table (like ClientID, ClientName, etc). The form shows the...

I'm new to VB, so bear with me if this is a stupid question. I created a form using the Data Form Wizard. I used a single table and choose the option to have "single record in individual controls" for the display. Thus I have controls for add/delete/etc as well as controls for moving next...

Can an Interbase 7.1 database be replicated/synchronized to a MS SQL database? We have a new application that used Interbase 7.1. We use MS SQL for our database and do all of our reports and analysis from MS SQL. I want to have a copy of the Interbase database in MS SQL for reporting and...

I am looking for help with SQL Server Analysis Manager. In the past I have used Cognos Transformer (off of Access) for creating cubes. They had a feature to create "running time dimension", such as 12 month running totals, or 3 month running totals. I am now trying to change over to...

I am looking for help with SQL Server Analysis Manager. In the past I have used Cognos Transformer (off of Access) for creating cubes. They had a feature to create "running time dimension", such as 12 month running totals, or 3 month running totals. I am now trying to change over to...

I am trying to plot a cumulative sum over time (Access Chart - Line graph), but cannot figure it out. I've seen the question posted by others on different forums - but have never seen an answer. I'll simplify what I am trying to do in order to focus on the problem. I am using Access 2002 and...