Search results for query: *

Hi, How can I tell if the user has clicked on the Minimise / Maximise button - is there an event that fires? Many thanks.

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

Thanks guys, Ive decided to try and use multidimensional arrays instead, give me a challenge...

I want to do the same thing as this: $$variable = $value but in asp. If the value of $variable was Company then a new variable called Company would be created with the value $value. I cannot find anything that would let me do this in asp. Any help would be appreciated Thanks

Hi, I cant seem to find anything on this subject, but I want to be able to time how long it takes an sql query (whether mysql/postgresql etc.) to run from php. For example time a create database or select * from... Thanks

Thanks to both of you, I ended up using the " + <variable> + " method along with converting it to a string with the vfp variables which are strings and ?<variable> with the vfp variables which are numeric. CURRENT_DATE and CURRENT_TIME are postgres constants so they were fine, postgres really...

I am trying to use the modulus of a number to insert a value into a postgres database table but cant seem to get the code just right. At the moment ive got: lnResult = SQLEXEC(lnConn, "INSERT INTO table1 (tb1_field1, tb1_field2, tb1_field3, tb1_field4, tb1_field5, tb1_field6, tb1_field7)...

Thanks, but ive now figured it out.