Thanks a lot, everybody - Craig in particular, for the links. It's good to know we're thinking along the right lines. I will digest, and more than likely come back with further questions. Much appreciated.
Thanks for the responses. I'm away for the weekend, now, but will reconvene on Monday and respond to any input from over the weekend. Hope you all have a good 'un.
Thanks, Dave. I should have given a bit more info in my first post. We have a stock control app that allows users to take orders, despatch goods and the like. At the moment, I specifically need to write some code that will create a sales order using parameters we have passed, which I could do...
Hi,
I'm using Fox 8, and I'm looking into the possibility of writing an Automation Server, but I'm not sure whether it is best to go down the in-process(dll) or out-of-process(exe) route. From reading the Fox Help, I initially thought that the dll would be the one to go for since the in-process...
Thanks to everyone, But it seems it may have been a network problem or my computer was ready was for a holiday. I havent touched the script since before christmas but now its decided to run in just over second when it took 12 before! Slightly confused but I hope to figure it out soon!
Thanks again
Thanks, I was using that script but from a different source and have now midifed it in order to do what I want. I have to get a directory listing for my project so I have to run the script once to store an ftp "conversation" (dont have a clue if that is a real term!) to a file then split the...
Its depends, Im not writing it for personal use so people may have the asp on the same physical server as the ftp area but I don't know. As Im trying to make the script as accessible as possible I dont want to limit users to having that setup available to them.
Thanks anyways
Thanks Mike, I shall definitely give that a go. If I were to do two tests like this where I followed the above method for one then did:
-start timing
-call sqlconnect()
-send query
-stop timing
-start timing
-send query
-stop query
would it show if sqlconnect is the reason why its taking so...
Hi, I am pretty new to asp and have found some ways of using ftp but they all involve creating a text file that is run all at once.
Is there any way of using asp and ftp on the fly, i.e. I issue a command to the ftp server, it is executed and any information sent back to me. I just want to be...
Thanks, Mike I shall have a look at this soon.
Would issuing an sqldisconnect at the end of the code force a re-establishment to the database?
So I could restart the database between tests and as VFP has disconnected no data should be cached anywhere and it should take the same time for each...
Thanks but I am sure its VFP. After each time running the same query I restarted the postgres database, but the runtime figures I was getting suggested VFP was caching the data, so I restarted VFP after running the query each time aswell. My figures jumped 6 fold, which definitely showed that...
Hi,
Is there any way I can stop VFP from caching SQL queries with SQLEXEC? I am trying to time how long it takes an SQL query connecting to a PostgreSQL database via ODBC takes and really dont want to have to restart my pc every time I change a setting. Are there any general speed issues when...
Hi, I'm trying to convert my current vfp dbf tables into posgtres and have done this successfully with one table. However I keep getting this error message when I try to convert another table:
The # of binded parameters < the # of parameter markers
What does it mean?
Im using postgres 8.1 on...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.