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 just checked on the free disk space on my user's PC and she has 34.9GB free. So I guess that eliminates disk space as a possibility of causing this problem right?
Any other ideas? Would really appreciate any help I can get.
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...
Hi Jonah,
I'm assuming you are using BDE here. You can let the user view the result from your TQuery in a DBGrid or a combination of TDBEdit boxes. You can then drop a TDBNavigator that will let you add, edit or delete records. However, this only works if your data comes from only one table. If...
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...
Hello Simon,
Thanks for replying. I tried giving the user ALL privileges when connecting to the database in the server but it is still not working. How can I rectify the problem if there were no space allocated for temp tables or if the database if full?
qmyung76,
Hi, not sure whether you have solve your problem but sleipnir214 is right, the way you connect to MySQL is media-independent. I have a setup just like yours though I'm not using 10base2 but I'm using MyODBC and it works fine. I have no problem connecting to my server as 'root' but when...
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...
Hello there.
Thanks for your reply. I'm sorry but what are MyISAM tables? Actually I pumped the data from an Oracle database to the mysql database. I've tried Repair, Optimize, Analyze and Check and still it doesnt work they way it used to. I even tried dropping the database and pumping the...
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...
SantaMufasa,
I've corrected all the typing errors in the sql statement. No more errors but it hangs when I try to execute it. Is it because my OrderHistoryDetail file is a really huge file?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.