Search results

Hi there Thomas, I have taken a look in the help files that are supplied with the GUI editor and you should be able to retrieve the userid of the current user if there are no _user records available and the user logs into the network usering a unique username. I suppose thats not much help...

Hi there Ray, Try finding the record within a 'do transaction' block with exclusive-lock then assign the new value so it should read something like: <HR>do transaction: &nbsp;&nbsp;&nbsp;&nbsp;find order_ref EXCLUSIVE-LOCK. &nbsp;&nbsp;&nbsp;&nbsp;assign order_ref.order_num = new_num...

Hi there Vic, I have never used the parts renumbering utility. If it actually changes the part number then you might want to consider archives and reloads. If you archive data from MFG/Pro that contains part numbers and you need to reload after using the utility you will have problems...

To add to this, I have noticed that I can see them all if I don't log into the board and I use the default scheme. The problem only arises when I log in.

Hello Folks, I am having a little bit of difficulty when running GUI programs. The program is a little report criteria screen that accepts two values, then goes away and pulls information from a database. The report is sent only to a text file but while the program is querying the...

Chris, I seem to be having problems seeing pictures in the forums. When I enter a forum I can't see any picture that should be on the board. This makes it impossible for me to see which are new posts etc. I have attached a zip file with a picture of what I am actually seeing...

Thanks Chris. I had a go at creating this myself but I did a do while v_counter < 100 instead of a repeat loop and I ended up not getting the last 57 records as the transaction wasn't commited (as the counter never went > than 100)!. this took me a little while to figure out but I have taken...

Chris, I had my reservations about the new look when you changed to vBulletin but now that I have had a good dig around I have found that I have a lot more control over my profile than before. I also like the way that I can choose my own colour scheme for the boards (all though I must say...

Sorry if I was a little vague to begin with. I am connecting directly to the DB that is on my own machine and yes I will be wanting to clear down the file everytime I get a new CSV file (like today the new file is just over 202,000 lines long). I used to use the temp table option but it...

Sorry if I was a little vague to begin with. I am connecting directly to the DB that is on my own machine and yes I will be wanting to clear down the file everytime I get a new CSV file (like today the new file is just over 202,000 lines long). I used to use the temp table option but it...

Howdy Folks, I have a quick question about the speed differences in creating records in temp tables and in the DB itself. I have got a CSV file that I need a suite of progress apps to have access to. The first idea I had was to create a temp table and share it which works fine but once my...

I don't think it is possible. There is always a way round stopping people from seeing html/java* source code for example, you can create a hyperlink to a webpage and right click and "Save Target As", this will allow me to save the page without ever loading the javascript to disable the cut...

I think that you are stuck on this one unless you can find out the encryption algorythm that PSC uses! The best way I think that this can be done is to take a string and encode it, then try and work backwards to converting the encrypted version back to its original. I gave this half an hours...

Chris, Have you started taking feed from the PEG e-mail lists? It seems to have made my reading of the posts extremely more labour intensive when I have loads of them to surf through! (especially when I am also subscribed to PEG and I seem to be reading the same thing twice). James.

Hi there Maurice, I always store time information in the database as an Integer. this is so that when I report on the time I can use the standard progress commands and manipulate it as necessary. BTW, if anyone reading this doesn't know: Progress time is always an integer and is the...

Problem solved folks. I have found some info on Jurjens API website. Thanks.

Good morning folks, Does anyone have any information about getting file information? If I submit a directory path to a progress application, I would like to search that directory (and all of its sub-directories) and build up a list of files and file sizes. Could someone possibly pass on...

Although you are writing a background app you must still be including the datasource object if you are accessing an external data source. If you are you should be able to change the properties of this and assign the datasource a username and a password. (this is going back to my...

Hi there, do you have the source for the c++ program? If it is in GUI (where I have used it before) you can assign the datasource with a default login name ans password and tell it not to show the login dialog box. If you don't have the source then I don't think I can help. HTH, James.

Hi there, Perhaps you might want to keep a copy of the promsgs file somewhere on your propath? HTH, James.