Search results for query: *

Ok, thx, Mike! I appreciate your help very much.

This is the full IIF function, yes, it's nasty, that I need to make work. It's in "pretty"/"readable" format. Normally it would be crammed all on one line. When I run this in a PRG from within the VFP application, I get "Fatal error: Exception code=C0000005". So I'll be hunting down that...

Thank you all for your knowledge! It will be most helpful today as I try to tackle the issue. I'll play around with the suggestions above and see if I can get it working. [morning]

Hello all, I'm working with Visual FoxPro 6. I've learned that I have have to do my SQL statements inside a program because if I use the view or query generator, the various joins get messed up or the field length of my IIF statements are too long. Anyway. Here is a sample SQL (program?) that...

SQLSister: You bring up a valid point. Thank you for your information. AWS

pwise: That code change worked like a charm! Thank you. That worked beautifully. AWS

Thank you for the info. I didn't think about adding the filter data to a linked table; good idea. AWS

I need to make a stored procedure with the WHERE SQL set to a parameter. I've written the SQL to show the point I'm trying to make but of course I can't do what I need. The part I need help on is where I have the "AND (@INFilter)" what the @INFilter will hold is the following SQL statements...

Thanks for your help. I've never heard of Erl before. I'll give it a shot and see what I can find. You've been most helpful!

Do you know how I would go about finding what files are "missing, corrupted, or not registered dll, ocx, or even exe (ActiveX) files, and there associated dependencies"? Thanks for your help/suggestions/ideas.

Ok, I just changed: Me.cmbShipMethod.Text = "None" to Me.cmbShipMethod = "" recompiled and executed the *.exe file. That particular error is gone. I really don't understand it, though. I also get this "Automation Error" when I export a CR report to MS word -...

rorubin: code of program when it bombs - unfortantly when it bombs out (only when it's in *.EXE format) I can't go into BREAK mode and see the exact highlighted error-generating code. I've marked the position with an "===>" where the code begins to execute (strFilterMode =...

Looked on the web for MANY days for any help on this but everyone suggests something else and so far none of it has helped. Ugh. Maybe this site will be better since there is a large "brain trust" :-) here. Ok, I've taken over a VB6 SP5 application that connects to an Access 2000 DB...