Search results for query: *

I have a program to display a few Quick Reports based on user selections. It gets its data from a mysql database residing in the server. I tested and the program works fine on 5 PCs. However, on 2 other PCs I get the error 'Invalid handle to the function'. I don't understand how this error come...

I set one of my QRGroup's ReprintOnNewPage property to true but that particular group is still not being reprint on a new page. I have many TQRGroup in that QuickRep but I only want one particular QRGroup to repeat on a new page. Can anyone help?

I have a Quick Report that gets its data from a few TQuerys and although the report is only 19 pages long, it takes me 2 hours to see the preview of all the pages! I have some complicated computations in the report and I use quite a few variables to do achieve this. My report doesnt merely...

I have a Delphi program to print out reports from my data in a mysql database residing in the server. One of my user gets the error message "Access violation at address 007CESS2. Read of addrress FFFFFFFF." when executing a report and the error "Temporary table resource...

I have a Delphi program to print out reports from my data in a mysql database residing in the server. One of my user gets the error message "Access violation at address 007CESS2. Read of addrress FFFFFFFF." when executing a report and the error "Temporary table resource...

select count(*) from order_header, order_detail where order_header.ORDER_NO = order_detail.ORDER_NO and order_header.ORDER_STATUS = '14' I have checked and there are 19556 records from the header file whose status = 14 and and there are a total of 96920 records in the detail file. From what I...

I have a form with a button that can be clicked to show the preview of my quick report residing in another form: procedure TReport1Query.Button1Click(Sender: TObject); begin rpt1.Report1.QuickRep1.Page.PaperSize:=A3; rpt1.Report1.QuickRep1.Preview; end; However, when the user clicks on the...

I'm trying to activate a query in one of my Delphi forms and it is not working. It is connected to a mysql database in my server. The query was working perfectly when I tested it with the mysql data from my own pc. However now that I am trying to connect to the mysql data in the server, I get an...

I'm trying to activate a TQuery in one of my Delphi forms and it is not working. It is connected to a mysql database in my server. The TQuery was working perfectly when I tested it with the mysql data from my own pc. However now that I am trying to connect to the mysql data in the server, I get...

My database was working fine and then suddenly this morning I noticed that the performance is very much slower than before when I try to view my data through the mySQL Control Center. I didnt change anything. I also noticed that now some fields of some tables have a little grey color triangle...

Normally, if I want to filter according to a range, for example according to a range of dates, I would write the code like the following: rpt1.Report1.sql.Filter := ('[date]>=' + QuotedStr(Edit1.Text) + 'and [date]<=' + QuotedStr(Edit2.Text)); Now, what if I want to filter, for example, all...

I'm new to Oracle and I have the data I need linked together in 8 tables. Region (RegionCode, RegionDesc) Customer (CustomerNo, CustomerName, RegionCode) OrderHeader (CustomerNo, OrderNo, OrderDate) OrderDetail (OrderNo, ProdNo) OrderHistoryHeader (CustomerNo, OrderNo, OrderDate)...