Search results

  1. L

    SKIP The Record

    beat me to it... ;)
  2. L

    Progress OE DB on Enterprise SSD's ?

    Thanks, Tom. Yes, "enterprise" was there for a reason. ;) As to the AI and BI files... I was initially thinking to put each of those structures on their own disk, unsure whether HDD or SSD.
  3. L

    Progress OE DB on Enterprise SSD's ?

    Could anyone share any experience with installing the Progress DB on enterprise SSD's? In particular is it feasible? Performance issues if any? What about .bi and .ai files? Thanks for any insight/comments/recommendations.
  4. L

    AppServer help with pricing model

    Customer is on per CPU pricing for the database. Whether that remains or we will need to change this for other reasons is undecided at this point. Progress sales rep gave me the impression the AppServer license was up to us to choose.... ah well. If it truly is a choice, my reason for...
  5. L

    AppServer help with pricing model

    Customer is going from 10.0B to 10.2B for the DB server and AppServer, both Enterprise versions. The OE licensing for the database we understand and can deal with. They currently do not have AppServer, so this is a new addtion and we have to choose between the various pricing models for...
  6. L

    AppServer help with pricing model

    One of our customers is going to be integrating with a 3rd party web app that uses ADO .Net . Connections will be to an 10.2B AppServer and state-free/stateless. This is our first use of AppServer, and one of the confusions between talking to Progress tech support and the Progress sales rep is...
  7. L

    SUSE Enterprise Edition V9 SP3 compatibilty with Progress V9.1x

    I know it's compatible with 10.0B since we have a customer on Suse 9 with that version. Is there some reason why you wouldn't upgrade to at least 10.0x (if still available) ?
  8. L

    Which is faster:

    They will likely take the same amount of time. From my understanding, the only time can-find is more efficient is if you use strictly fields in an index and only for equality matches. In that case the can-find will only read the index blocks, and no data blocks need be retrieved. As soon as...
  9. L

    MS Access Table which links to a progress table

    This is from the Progress Kbase: These instructions work with both the Merant 3.60 driver and the SQL-92 ODBC Driver. 1) Create a File DSN (instead of a System DSN or User DSN) through the ODBC Data Source Administrator. 2) Once created, test the connection, and then modify the file just...
  10. L

    ODBC Data Source Drivers are Not Listed

    Not to derail this thread, but wasn't there supposed to b a 64bit ODBC driver as of 10.2B ?
  11. L

    starting a database - .lk error

    Error 13 on *nix is almost always a user permission problem ... in your log above... Server started by user on /dev/pts/2. Server started by overwritetemp on /dev/pts/2.
  12. L

    4GL help - Transaction needs to be undone but one subtransaction needs to be commited

    Re: 4GL help - Transaction needs to be undone but one subtransaction needs to be comm or if you have multiple tables and a few fields to update, you could try the following. say 2 tables, 2 fields from table1 and 1 field in table2 ... don't forget to clear the temp-table if needed. def...
  13. L

    4GL help - Transaction needs to be undone but one subtransaction needs to be commited

    Re: 4GL help - Transaction needs to be undone but one subtransaction needs to be comm I'm making the assumption that the document does print regardless... EDIT: I'd suggest trying the second example, as it is a tad more straighforward... you might want to try something similar to this...
  14. L

    4GL help - Transaction needs to be undone but one subtransaction needs to be commited

    Re: 4GL help - Transaction needs to be undone but one subtransaction needs to be comm There are a few ways to do this besides the obvious one of use no-undo fields and no-undo temp-tables and do the transaction commits at the end.... Can you give us a sample of the code? Is it event driven...
  15. L

    Newbie to web services - how to load indeterminate longchar array

    Obviously not something people have used much.... Well, after much unsuccessful mucking around with code for the past week (which is why I was at the point of giving up and so posted this earlier), I finally just figured it out. I knew that I needed to be able to make the indeterminate array...
  16. L

    Newbie to web services - how to load indeterminate longchar array

    OE10.2B Linux I'm working on my first project using web services (in this case a phone app with Sprint called Telenav) and my first encountering of indeterminate arrays. I've gotten the code from the wsdl, and can successfully send and receive xml from the web service as long as it's not an...
  17. L

    The mysteries of query efficiently

    I think you will want to add some parentheses around your "or" for each sophdr no-lock where sophdr.compNo = syscon.compno and sophdr.ordAck = true and (sophdr.ordstat = "N":u or...
  18. L

    Performance in reading Progress via OpenEdge

    What version of OpenEdge are you using? I'm making a SWAG since you said "OpenEdge" it's OE10.x something? What types of queries? Lots of joins? Are the fields used in the query part of the index(es)? Are you updating statistics on a regular basis? Are you using Type II storage for the...
  19. L

    How do I design a program to own a face with progress

    The simple answer is to just to contact your QAD sales rep so that you can increase the user count for your license(s). Then you can come back and ask your questions. What counts as a user is different kettle of fish.
  20. L

    Process keep running on Linux server after running scripts with "b-pro"

    Use "mbpro" (multi-user database connection batch process). bpro is used for single user, which is what the remote connection (-H -S -N) was used for.. i.e. single user remote connection in batch.
Back
Top