Search results

In OpenEdge I think it can be done simpeler. You have to convert PM into + 12 Hours, but this seems to work: def var dt as datetime no-undo. dt = DATETIME("01-01-0001 00:01:03"). disp mtime(dt) / 1000.

Why is everybody a saint on the internet? :( get real bye

Thanks a lot, that will do the trick. This happens because we build a release-based application, and at some time we "close" the db-scheme. So not all the code needs to be recompiled all the time etc. When a developer needs to build new functionality for which he would normally need a...

U mean like this? http://www.progresstalk.com/showthread.php?t=110527

Is it possible to select an entry of a db-column as a view-column? We have a field that contains a delimited list in the db and I want to present these as separate values to the customer in a view. What I would like to do is: SELECT TABELALGEMEEN . CODE, TABELALGEMEEN . IDTABELALGEMEEN...

:awink: How do you know I am usually missing something? Since I didn't miss the thing you mention

I know what the compiler thinks: display exclusive-lock. display share-lock. display no-lock.

Am I missing something or... If this is the only thing in the file: procedure ... ... end procedure. The easiest way to use it then would be to treat is as an include. Insert this line in your code: {(pro)path_to_file/createversion.p} After that you can use the procedure in your code...

This is the piece of code we use to load the df into our different environments (ie this piece of code is repeated several times with different dwh-db's in a program): message "dbname something". disconnect dwh no-error. connect -1 e:\database\something\dwh. run Login. create alias appldb for...

Then I don't know, as I wrote, I never have a problem through odbc

Yes. From windows/systemconfig/odbc or from syteline or from Progress SQL explorer or from a progress client/editor or ... From windows, sql-explorer or editor I never have a problem (except when I explicitely supply the -1) From syteline, I don't know from ... I don't know either ;-)

How do you connect?

How do you connect? All the ways I know either have an option "multi-user" (toggle-box) or do it automatically. Except: connect xxx -1. in the editor, then you should remove the -1

From syteline, I don't know. From a Progress-client (editor): create _user. assign _user._userid = "something" _user._password = encode("somethingelse"). Or from the dataadministration-tool: Admin -> Security -> edit user list Beware, that as soon as you add any user, some...

To be honest, I don't know Syteline 5, but if you are using an ODBC-connection to access a Progress-database you have to grant SQL-rights. When you create an _user "sysprogress" with password "sysprogress" (encode("sysprogress) in 4GL) and log-on to the db with that user, you should be able to...

Post the query, so we can have a look at it. When you perform grouping on the server there might be a problem with temp-space, which is crashing the query? Does the query run with a simpeler select statement? That is, no group-by's, calculated fields, sums, counts etc.

Eh? Open query isn't dynamic. Isn't "self" in this trigger the column? So you can do: query-prepare("... by " + self:name). or something like that.

Are you connected to the db? Are you logged in to the db? Does the user have sql-rights to see any table/data?

I would like to reset the sql-92-rights on a database. I would like to start with the command: revoke all on pub.ACCOUNT from *; And after that grant to specified users. But the * is not recognized. "from public" still leaves a user granted with rights, I think it's the creator or owner or...

So the year can't be greater than 32767 (2^15). DATE(13689326) returns 12/31/32767. Higher returns ?????.