Search results

Try this command line: prowin32.exe -pf {pfname.pf} -p {program.p/r} That should take care of connecting to the database and also running the program for you. Also, if you are connection to the database in the PF file there will be no need to runn the CONNECT statement from within your...

Forgot to mention that a solution to connect to the SQL Server 7 datasource form a character client (AIX Unix) would also be gratefully received. Thanx again. James.

Hi Folks, I am using GUI Progress v8.3b and would like to connect from it to an SQL server running MS SQL Server 7 software. What are the minimum software requirements for me to do this the cheapest possible way?? TIA, James.

They appear to be threads that you have made a contribution to. James.

Hi there, You can find the record you are wanting with the NO-LOCK, NO-WAIT and NO-ERROR options, then used the LOCKED function to see if the record is locked. I don't think it is possible to see what user has the record locked (can VST's give you this information?). It would be useful to...

hi Fraser, What version of Outlook is it and is it Outlook or Outlook Express? James.

To specify a username and password that is configured within a database you can use -U and -P command line parameters (both paramaters must be uppercase). Don't know what is causing the no server error though. Are you sure that a server exists and that the other user isn't using the pro...

I personally don't think it is possible then. The key you press to continue will just be another keyboard event but the trick would have been to identify if the key was pressed while in a paused state but I don't think that is possible. The way I would have worked round this would have been...

Hi there Tony, Why don't you just put the code you want to execute after the pause statement that causes the 'Press space bar to continue'? HTH, James.

Hi All, I hope someone can help here. I am wanting to find all unposted transactions linked to PO receipts within a given date range. I work through TR_HIST using the date range for all tr_type = "RCT-PO" and from there I get the PO details and all of the voucher details (if any). The...

Hi All, I thought that I would post a tool that I created in the hope that people will find it as useful as I have. It allows a user to replace an occurance of one character in a file with another character. It is a DOS EXE file and it runs extremely fast. If people find it useful...

Hi there John, the -ld parameter specifies a logical name for the database. This name is used in your programs to refer to databases, for example, the mfgpro database is called mfg.db but you refer to it as qaddb in the progress code because the -ld parameter is set to '-ld qaddb'. You do...

There is also material on Progress's website that may be quite useful. Take a look at the post Chris made a little while ago. HTH, James.

Hi there Maurice, Take a look at the code in the zip file that I have attached. There are three programs but the one you should be interested in is called getinfo.p. You will need to change the table name to something that you can use but basically what it will allow you to do is specify a...

Hi there, The command line you would want to use to run something from a prompt would be: $DLC\prowin32 -db {db name&path} -ld {logical name} {other command line options} -b -p {progname.p/.r} >> {.log file} That should do you. You may need to put more on the redirect to log file...

Hi Ross, The datatype you want will be integer with a format of no more than 99999 as the maximum value time will be is 86399. To assign a value to the field you can use 'assign db_field = time' and to display you can use 'display string(db_field, "HH:MM:SS")' or whatever format you want...

Hi All, I don't think this option is open to users with Outlook Express as it doesn't come with the automation server that is required. I think that you can download it though from somewhere within the depths of Microsoft (if anyone has the time to look!). You can, however, do this with...

Chris, Should there be an attachment to this post? James.

I have been programming in various languages over the last few years and my attitude is that when I am modifying code I would want the original author to comment their code so I can understand at a glance, so why shouldn't I comment my code and help someone else out in the future? I generally...

You mean like this? :chat: