Paul Hall | 2006-12-03 10:03:32.0 | |
| Thanks for your answers!
Yes, putting the quotes around the file with path worked! (select * from "lookupf/lookup")...thanks. Much of our work involves stored routines...with parameters. Since DBF v3.0 does not support stored procedures, is there any other way we can run those routines? Perhaps a pass-through command...Can we pass VFP commands through ColdFusion?...for example: " Do TestMessage.prg ", or " Do TestMessage.exe ", or " Run TestMessage.exe ".... is there any other work around you can suggest? I saw in a note somewhere that your Access driver supports Stored Procedures...is that correct? If so, can that driver fire off an EXE that we build with VFP? | ||
HXTT Support | 2006-12-03 16:01:45.0 | |
| >I saw in a note somewhere that your Access driver
>supports Stored Procedures... Yeah. Because MS Access's stored procedures can be translated into SQL. But VFP is a complicate languag at all. >is there any other work around you can suggest? Yeah. You can use System.exec function to call some bat files, which will set enviroment and call your VFP program. | ||
Paul Hall | 2006-12-04 05:58:46.0 | |
| Thanks for your response.
Sorry, I can't seem to find documentation on "System.exec" function. How would I run this command through ColdFusion to execute a bat file? | ||
HXTT Support | 2006-12-04 06:16:34.0 | |
| Sorry. It's in Runtime class, not in System class.You should use
Runtime.getRuntime().exec(...) | ||
Paul Hall | 2006-12-04 07:19:56.0 | |
| Thanks.
I don't find Runtime.getRuntime().exec(...) in the documentation. How can I run this function from ColdFusion? thanks Paul Hall phall@masterymg.com | ||
HXTT Support | 2006-12-04 07:22:57.0 | |
| It's at Java API document for java.lang.Runtime class. | ||
Paul Hall | 2006-12-04 07:59:16.0 | |
| Thanks.
Sorry, I was looking in the DBF v3.0 documentation. I now see you meant java documentation. I am now searching on google etc. for coder sites that referencing implementing this java function within ColdFusion. Thanks, you've given me helpful direction! I will let you know my results, so you can pass on to others. Do you know any other licensees of DBF v3.0 using ColdFusion? Thanks again, Paul Hall phall@masterymg.com | ||
HXTT Support | 2006-12-04 17:24:02.0 | |
| Many user is using ColdFusion, and one Adobe employee is using HXTT DBF, HXTT Access, and HXTT Excel with ColdFusion.
If you wish to use VFP at the same time, please use jdbc:dbf:/yourdbpath?lockType=VFP to let HXTT DBF and VFP can see each other. BTW, please check whether you hava many stored procedures, and if there's few stored procedures, and maybe the better way is to use sql to replace it since HXTT DBF supports transaction. I copy a sample code, which is using all version of javac to compile our products:
| ||
Paul Hall | 2006-12-09 04:24:05.0 | |
| Thank You for all your help.
I am new to ColdFusion and do not know how to code Java. However, I discovered that ColdFusion has a command that uses Runtime.getRuntime().exec called I can use this to run a VFP exe. (I will have to be careful to set up the user environment the right way.) I would prefer to run the PRG in VFP so that it is running in the same process space as my queries...but, the EXE approach will get me by. Thanks again for pointing me in the right direction! Paul Hall phall@masterymg.com | ||
HXTT Support | 2006-12-09 06:03:36.0 | |
| Anyway, I don't think that it's a good idea to call VFP program in Java. If your VFP program is simple, please consider to use Java and SQL to replace it. | ||