Recent content by JNC73

I also tried that, but it didn't work. So I think the solution must be somewhere else.

I already tried it. But when I view the properties of the FoxRun.PIF file there is no text box with the label Memory Required. I use Win2K maybe this will help.

Hi, Can anyone help me to solve this problem? I want to run a dos executable from my FoxPro5 application with the RUN command. But when I run it I can read in the dos box that there isn't enough workmemmory to run the program. Can anyone tell me how to solve this? Thnx, JNC73

I've got VFP5 Does this also have the same solution?

Hi, Can anyone tell me if there is a standard solution to encrypt and decrypt data in VFP? I need to encrypt all data in local DBF files and decrypt them when I show the data in the application and before sending it to a SQL*Server database. Thnx, JNC73

Thnx Mike, The code helped me to understand what caused it and what I had to do to solve the problem in VFP5. The code itself didn't work in VFP5. JNC73

Hello, I have a problem with printing a report on a network printer. When I built my app somewhere in my code (i don't know where) there must be a reference to my network printer. Everybody who uses the program is printing on my printer in stead of the default printer installed on the computer...

Use the query executionplan option. That will give you an indication of how the statement is run and where optimilisation is necessary. JNC73

Make sure that your date value (var3)is in American date format (mm-dd-yyyy) SQL*Server expects an american date format and not the european (dd-mm-yyyy).

Hi, Your where clause should be something like this where instruction.ins_id in (select instruction.ins_id from instruction where instruction.ins_created > '01-Sep-2001' order by client_id having count(ins_id) > 10) Client_id is the Id where you want to count the number of...

First of all When you change a record in a table it is possible that de Delete and Insert trigger are executed and all the checks that are made there will be executed as one transaction. This means that when these triggers take a long time to run even a select statement may not read the content...

Hi Can anyone help me with my OLEDB connections to a SQL6.5 database? I use ColdFusion and make database connections with OLEDB. I allready disabled the parameter Maintain database connection. But my application still keeps a connection open to SQL even when my application is allready closed...

PLEASE HELP ME. I use cf4.5 with SQL*Server6.5 with OLEDB connections. The queries perform great, but my database connections are held open. This means when I reach my max number of connections I can't execute a query on the database. I allready disabled the Maintain database connection...

Hi HoldemFoldem, What you need to do is build a Loop in SQL Server This is a litte with PSEUDO CODE SO YOU have to change it into real SQL code DECLARE @PCDESC VARCHAR(255) DECLARE @COUNTER INTEGER SELECT @PCDESC = "" SELECT @COUNTER = (SELECT MIN(TABLE_ID) FROM TABLE) WHILE...

Yep it's the function IN WHERE fieldname IN (value1, value2, etc.) Hope this helps JNC73