Search results

Use dbtool. That runs online and the cache is also automatically refreshed. And there is not a real relation between display format and needed sql width. It is just an assumption being made by Progress. You can put 30K in a field of format 'X(1)'.

The width column represents the sql width of the column. Progress has variable column widths sql has fixed ones. So if you query with SQL a Progress database and the data in it exceeds the width value for a particular column it raises an error. By default the width column is twice the display...

ah now I understand. This is a Progress (www.progress.com) forum (ergo Progresstalk) so I assumed your question was Progress related.

How do you create the XML? If you use sax-writer, does it help if you set the formatted atribute to true? Regards, casper.

Yeah I totally agree. Would be great to have session:first-dynamic-handle....

There are more then 1 KB articles about this. For instance this one: http://progress.atgnow.com/esprogress/Group.jsp?bgroup=progress&id=p11858 HTH, Casper.

You have to make a dynamic temp-table then. define variable cTT as character no-undo. define variable hTest as handle no-undo. assign cTT = 'temptablename'. run CreateTT (input cTT,output table-handle hTest by-reference). MESSAGE valid-handle(hTest)';' hTest:name VIEW-AS ALERT-BOX...

To find out the query plan use run the query with noexecute so no results are returned and right after that run: This will give you the query plan. Further questions: What Progress version are you running and do you run update statistics periodically? Regards, Casper

Wow, I don't know where to start. There are more issues apart from the 2 you mention. Implicit you ask many questions. Its kinda like asking how does progress work and how to make an appliaction with it. This may not sound helpfull, but it would really help you out if you first took a few...

What driver are you using. Is it by chance a merant 3.60 SQL89 driver? Regards, Casper.

This seems to work: DEFINE VARIABLE dDateTime AS DATETIME NO-UNDO. ASSIGN SESSION:DATE-FORMAT = 'ymd'. ASSIGN dDateTime = DATETIME("2011-03-09T13:02:39.123"). MESSAGE dDateTime VIEW-AS ALERT-BOX INFO BUTTONS OK. ASSIGN SESSION:DATE-FORMAT = 'dmy'. MESSAGE dDateTime VIEW-AS ALERT-BOX INFO...

yes true, we do that all the time. Not on windows though but on linux with apache. You can also install mutiple messengers so you can connect to appservers on different machines.

Yes actually I think most of us always do want to use -rereadnolock or maye better, should use. Only in some cases it is desirable that the cached record is used while most times one wants the most recent version from the database. So I think it would have been better to make this default...

The response was already given: MaximMonin wrote: [quoute] Maybe index can help to extract record in right order. If you need specifically those record then an index is needed to retrieve them in that order. Regards, Casper.

The record is always fetched from the database. -rereadnolock tells the avm to always use the fetched record and not the one cached in memory.

If you tell me the version of Progress I might be able to help you with this. there should be some information regarding the progress version in the <databasename>.lg file, which is the log file. Regards, Casper.

I took the opportunity to change the title back to its original. Seemed more appropiate :)

To add to that: Making your database utf-8 Move as much application data to database tables as posible, so you can make translations there in stead of in the code. (Messages (error-handling) , field labels, window titles etc.) Currency and legislation can become an issue too when selling...

open it and in the status bar at the bottom you will see the data of the last entered kb article.

yeah lol, I found out the same thing. All this fuzz about making it only available to AP's and then create an open link to it.. typical :P