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: *

  • Users: skss
  • Order by date
  1. skss

    'Invalid handle to the function' error

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

    Quick Report's ReprintOnNewPage property not working

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

    How to speed up Quick Report processing?

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

    Need help on access violation and temp table resource limit errors

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

    Need help on access violation and temp table resource limit errors

    If yes, then how can I solve the memory limit problem? The strange thing is, it works just fine on other PCs.
  6. skss

    Need help on access violation and temp table resource limit errors

    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...
    • skss
    • Thread
    • Replies: 1
    • Forum: MySQL
  7. skss

    Need help on access violation and temp table resource limit errors

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

    MySQL and Delphi, need help

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

    So simple but it is not working! Help!

    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...
    • skss
    • Thread
    • Replies: 1
    • Forum: MySQL
  10. skss

    Help! Quick Rpt previews in Landscape but printing in Portrait

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

    Error when trying to activate TQuery

    Thank you anyway. Is there anyone else who can help? Thanks
  12. skss

    Error when trying to activate TQuery

    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?
  13. skss

    Query to mysql works in mysqlcc but not in Delphi prog

    Hello Dave, Thanks for replying. I tried letting the user from my program have ALL privileges but it is still not working.
  14. skss

    Cannot Connect to Mysql Server using MyOdbc

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

    Query to mysql works in mysqlcc but not in Delphi prog

    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...
    • skss
    • Thread
    • Replies: 2
    • Forum: MySQL
  16. skss

    Error when trying to activate TQuery

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

    Help! I dont know what's wrong!

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

    Help! I dont know what's wrong!

    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...
    • skss
    • Thread
    • Replies: 4
    • Forum: MySQL
  19. skss

    TQuery: How to filter this?

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

    How to write the SQL for this?

    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?

Part and Inventory Search

Back
Top