Search results for query: *

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

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

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

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

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

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

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

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

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"...

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

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

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

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

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

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

Easy... Make sure you have the JVCL installed (http://homepages.borland.com/jedi/jvcl/) and use the JvMail component... JvMail1.Recipient.AddRecipient('email@mail.com', 'Mr. Smith'); JvMail1.Subject := 'My Subject'; JvMail1.Body.Append(txtMESSAGE.Text); JvMail1.SendMail(True); There are many...

I'll give it a try. Do you know the layout/format of your binary database file? Send me an e-mail (paul at ipaw.net) if you'd like me to try. Paul Paul Wesson, Programmer/Analyst www.ipaw.net

Have you tried "FlashMyAdmin.org"... pretty cool Paul Wesson, Programmer/Analyst www.ipaw.net

Option 1: Create a front-end desktop app (with necessary dlls) to run the reports from a shared repository? Option 2: Create a client/server app where your server app actually executes the report and exports it to html for the client to then view. Paul Wesson, Programmer/Analyst www.ipaw.net

I use DAC for MySQL from: http://www.microolap.com/products/connectivity/mysqldac/ Paul Wesson, Programmer/Analyst www.ipaw.net