Search results

  1. B

    Problem with dynamic temp-table. Exceeding temp-table limit 32762

    Thank you. I have now found some of the buffers and deleted them. Do you know if it is possible to find all buffers/queries/prodatasets and then delete them all at once at the end of the program. It could be neat to just run a "Clean" procedure at the end. I tried with this //Delete dynamic...
  2. B

    Problem with dynamic temp-table. Exceeding temp-table limit 32762

    Tnx. It seems like I have some memoryleaks, bacause after running checkleak i am left with some buffers. But i am having a hard time to delete these. In you add create another table, but dont add it to the dataset. How do you deletete that buffer and table ???
  3. B

    Problem with dynamic temp-table. Exceeding temp-table limit 32762

    Hi all. I have a program that is called from an appserver routine. It fetches data from multiple tables (specified by user) and returned data as xml to a .net program. I have recently received an error that number of active temp-tables have reached a limit 32762. Am i not deleting objects...
  4. B

    Fill a temp-table using sql statement. Is it possible

    I am not talking about sql-89 but sql-92
  5. B

    Fill a temp-table using sql statement. Is it possible

    Hi all Quick question. I am working on a c#/appserver "GetRecords" test project Is it possible to fill a temp-table using sql-select statement (that i pass in as parameter ? For instance: def temp-table tt like customer. select * from customer where c-name like 'Nor%'. create tt...
  6. B

    Question Progress Application Server

    Thank you. I am beginning to understand this. So basically all I have to change is my current connection that uses classic appserver to a new connection that uses the new application server. We dont't use proxy in our solution, we just connect direct to appserv and run the procedure directly...
  7. B

    Question Progress Application Server

    Yea, we use these dll's today and call appserver directly with "AppServerDC://xx.xx.xx.xx:yyyy/name etc etc but this is not what I am after. If you look at the attachment in my first post I want to test/learn about the new Progress Application Server. I am getting confused here. Is Appserver and...
  8. B

    Question Progress Application Server

    But how to we set it up server side ? Do we need to install something etc etc ? I can't find good documentation on this.
  9. B

    Question Progress Application Server

    Hi all So I have been reading this "Progress - keys to success pasoe.pdf" which says that progress application server is the way to go. We currently use both odbc and classic appserver in our .NET solution. I would like to explore the new progress application server, but I can't find out what...
  10. B

    Question Linked Server Sql - Get Sequence Value

    Hi all We have an external program that inserts data into one of our progress database. They have set up linked server within Microsoft sql-server. Today we can connect and insert records into the progress database (10.2b). But we would like to take use of a sequence that is defined in our...
  11. B

    Question Read File (img) Binary

    Wow. Thank you very much for trying to get this to work. I have used days now to try different things. By using zebra desig program i can get it to work, but i have no luck when i try to read that pcx file from a procedure. The size/length when i try to read the pcx file is so much larger than...
  12. B

    Question Read File (img) Binary

    Thank you for this tip. Unfortunately my label writer is old and only supports epl code. I have spent too many hours trying to get this to work with epl, much cheaper to buy a new labelwriter that supports zpl and use that for the future
  13. B

    Question Read File (img) Binary

    Not possible in my state. I must build up text barcodes based on input values.
  14. B

    Question Read File (img) Binary

    Hi all I have a problem that mr. Google can't help me with. I am trying to print a label on a zebra labelwriter with a logo (image in pcx file format). According to epl2 programming guide i must send imange as "Raw binary data without graphic file formatting. Data must be in bytes" How do i...
  15. B

    Question Connect to progress from BizTalk

    Hi all Is it possible to send messages from a BizTalk Server (version 2013 R2) to an Progress AppServer (Progress version 10.2B) over a TCP/IP connection? Is it possible to use IP and port to connect to the AppServer? We have a BizTalk server on a windows platform, and the AppServer is on a...
  16. B

    Question Index on datetime fields ?

    so you suggest to only create a new index containing "CloseCode, GroupName and StartTime" ? Using this new index, will it give better performace ?
  17. B

    Question Index on datetime fields ?

    Hi all I have a rather large table that and i want to use as many indexes i can in order to get performance. I have the following indexes: -iClosecode -iGroupName -iFromDateTime -iToDateTime if i use: def var dtStart as datetime no-undo. def var dtEnd as datetime no-undo. assign dtStart =...
  18. B

    Answered For each using only lookup = no index

    Ok. I also had the idea with temp-tables, but that means i have to rewrite so much :-) My queries are buildt up based on 30-40 input fields, but i guess that i can rewrite and use temp-tables on my most used fields. I did a small test and my seach went from 40 sec to around 7. I am aiming at 3...
  19. B

    Answered For each using only lookup = no index

    Hi all We have a rather complex search site that searches in multiple tables. The query for this search is buildt up dynamiclly, then executed and the result is returned to a .NET site as xml. (I use appserver for calling the search and returning the search result). Sometimes a user creates a...
  20. B

    Resolved smtpMail and creating email

    Hi guys I am trying to get smtpMail to create and send me a email with text in multiple columns/formatted text. I do not want my "text" in a attachment. I am simply trying to fill out body in a email This works fine if all text start from left, but if i try to build up text in 2 columns the...
Top