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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by pwesson

  1. pwesson

    Why is PERVASIVE ODBC performance so slow with Crystal Reports..?

    I've been using Crystal for years and personally I think most of the problems are with Crystal. It just sucks at running queries on large dbs. What we've had to do to make it not so unpleasant is use our application, in our case Delphi, to do all the querying and write the results out to a CSV...
  2. pwesson

    Action Scripting - ComboBox Load Values at start-up

    I have a panel that is closed be default but then animates and opens at a certain keyframe and stays open. I want to put a combo box on that panel that loads a list of values (from a php script). How do I get the combo box to load its results when that panel is fully open? Where do I put the...
  3. pwesson

    Pass info from visible textbox to hidden textbox?

    Yes, do exactly the same as if it were visible. document.getElementById("fieldname").value = something Paul Wesson, Programmer/Analyst www.ipaw.net
  4. pwesson

    PHP MySQL insert

    Do you have a typo in your example, because you have not end quote and comma after $home_address1. Also check your date definitions... you don't need quotes around numeric fields... ie $accountid or the zero at the end. Paul Wesson, Programmer/Analyst www.ipaw.net
  5. pwesson

    Opening and Displaying PDF Files from Delphi Application

    uses ShellAPI; ShellExecute(Handle,'open',PChar('filename.pdf'),'', '', SW_SHOWNORMAL); Paul Wesson, Programmer/Analyst www.ipaw.net
  6. pwesson

    Crystal Reports 5.0, anyone?

    I have a copy of 5, 6, 7 & 8. My version 5 is an upgrade install. I think my original CRW was 3.0 which came with my VB 4.0. If I remember correctly the 5 upgrade asks for the location of the previous crw exe, which can exist on a cd and doesn't have to be installed. If you want to send me...
  7. pwesson

    passing vaiables between external php files

    You could also use session vars $_session["var_name"] = "something"; Just put a start session at the top of each page. Paul Wesson, Programmer/Analyst www.ipaw.net
  8. pwesson

    Populate multiple combo boxes with same info

    combox1.items := combox2.items; Paul Wesson, Programmer/Analyst www.ipaw.net
  9. pwesson

    GROUP BY Problems

    I have two tables, say Customers and Invoices and I want a query to show some customer information along with the # of invoices they have... From what I understand a group by fields list must also be included in the GROUP BY ... So this works fine: SELECT c.cust_no, COUNT(*) FROM "customers"...
  10. pwesson

    insert into MySQL via email and PHP?

    I've written such a script though it has to be installed on your server and you have to have your mail application execute the script when new e-mail is received. If you are trying to do this from your Desktop e-mail client, then you need to write a windows application to do the work. Paul...
  11. pwesson

    Error accessing via Crystal Reports

    I discovered a problem when I was creating the new report using a CSV file to report from. I could do everything but save my report. When I tried to save I got an "invalid file handle error"???? ya, I know, hugh? Anyway after doing some searching on the web for this problem someone mentioned...
  12. pwesson

    Error accessing via Crystal Reports

    Connecting using the FILE.DDF did the trick, thank you very much. I'm still going to try and find out why it doesn't work using the Pervasive ODBC driver. If/when I find anything I'll post it here. Paul Paul Wesson, Programmer/Analyst www.ipaw.net
  13. pwesson

    Error accessing via Crystal Reports

    The db is local and I also tried re-creating the ODBC connection from within Crystal, but no luck. Paul Wesson, Programmer/Analyst www.ipaw.net
  14. pwesson

    Error accessing via Crystal Reports

    Pervasive SQL 8.7 Crystal Reports 8.5 When I try and connect via Crystal Reports I get the following error: Crystal Reports: Database Error ODBC error:[Pervasive][ODBC Client Interface][Client LNA]Connection attempt timed out. The SQL Connection Manager may be inactive or using a different...
  15. pwesson

    How to get data into Crystal report from .CSV file?

    Just create an ODBC entry (Microsoft txt,csv) that points to the folder where your CSV file resides and then have Crystal connect via the ODBC. Paul Wesson, Programmer/Analyst www.ipaw.net
See more

Part and Inventory Search

Back
Top