Search results

you can try this as you probably need the header records to only appear once anyway... beware, depending on the indexes and number of records in header table that might or might not work very well :) OPEN QUERY {&SELF-NAME} FOR EACH mov_hdr WHERE CAN-FIND (FIRST mov_line OF mov_hdr...

are you sure about that input-output parameter? if it's a handle it really doesn't have to be input-output, the memory pointer will be passed along. to gave a valid memory pointer you need to use a memptr which if it need to be initialized you have to call set-size() and optionally put something...

Re: -SQLTempStoreDisk / -SQLTempDisk? Where to place this command for Merant ODBC con...

Re: -SQLTempStoreDisk / -SQLTempDisk? Where to place this command for Merant ODBC con Afraid those are performance related settings that you need to set on the database server, has nothing to do with the ODBC driver itself... if needed those can be added when you start the database broker (the...

Come on Stefan, the guy even uploaded the complete XML file... couldn't you just finish your example and make him happy? :)

you can't... only methods are allowed in there but it's not the only place where we still need to decorate OO ABL with (persistent) procedures.

Not really, it sees that the there are records having fields with more data that the column max length... the (in)famous SQL_WIDTH issue, the SQL engine of Progress DBMS uses the column FORMAT as base for maximum column length but the FORMAT in ABL affects only how data is displayed (by default)...

use simply LEN(LogText) not LEN(ChgLog.LogText)... and you don't need to quote everything, unless it has non-friendly SAL characters (like '-' for instance)

Re: Pro 2 sql Can't tell you anything about PRO2SQL solution but I'll venture to make a few comments on the subject... In a typical data warehouse environment you don't need real-time replication, the usual suspects there are ETL tools (extract-transform-load). You probably worry about...

As others already said the best way to go is probably Open Client, this is if you use AppServer... most important is your BL must be able to work like that (aka: BL and UI to be separated). The only thing that might bother you when using Open Client is that on every update of api signatures you...

I don't have any samples that can be shared, I think Rares had some replication solution that used sonic mq as middle-layer... but if I remember correctly he had to take of the project from sourceforge as he was at the time an employee of PSC :( But the base idea is to use the replication...

well, looks like you really have a few things to learn and that's not only language syntax :) anyway... glad to see you found the answer yourself, after all wasn't that hard isn't it?

a database trigger is hardly a place where one should attempt to connect to another database (in not connected already)... why do you want to hard-link the two systems, what if the other database is down, is your write trigger return an error and roll-back everything? that's definitively the...

The UML2ABL code generator module is using the Acceleo Model to Text Transformation component which is part of Eclipse Modelling and can be applied to standard UML2 models to generate OpenEdge ABL code. First implementation offers support for OpenEdge Object Oriented constructs for the...

Raw data level integration might look like the easiest way to do but it implies at least two drawbacks that I better avoid if all possible: - it creates a tightly-coupled system, hard to maintain and you need deep knowledge of application internal data-storage - you simply miss all the...

tables, fields with illegal characters (in that case '-') should be quoted... SELECT ord_0.onum, ord_0.cdate, ord_0.completed, ord_0.posted, ord_0.sid, ord_0."sup-id" FROM PUB.ord ord_0 WHERE (ord_0.cdate>={d '2011-06-01'}) AND (ord_0.completed Is Null) AND (ord_0.sid=1)

Well, we use Mercurial for all projects but not much UI going on so we don't have any issues with it... however this isn't really related to Mercurial and as the file actually change content any SCM will spot that and mark it for commit. The issue seems to be that for a (probably small) change...

be sure you specify the encoding info when setting the content type... output-content-type('text/html; charset=utf8')

one thing you should look out is dynamic buffer/query operations: - dynamic query: query-prepare:'for each table where field = <some value>') - buffer assign: [buffer-field]:buffer-value = <some value> used in dynamic query/assign <some value> can always be quoted (as string) and run-time...

That looks like a web-based reporting solution you have there... is that using PHP, ASP in conjunction with ODBC connection? You might want to consider using a java reporting engine instead and use a JDBC driver that use the ABL engine of Progress database and even allows you to get the report...