Search results

You mean something like NOW or SYSDATE?

It works :D got it to "export the sql-output" and import it in a temp-table which i can show in a browse.

OK from the beginning. My collegues are developing reports with Crystal Reports. Sometimes it is neccesary to write the sql-query themselves for performence. Because they are lazy :biggrin: and because we have a "logical" db-scheme with very long but very clear/self-explanatory table/field-names...

So I must disect the sql-explorer or Access or Crystal... see how it does it... then step outside Progress with com-handles or whatever... let the engine of the external program issue the sql-query... and find a way to get the dataset back in... Hmmm..., I think I'll let my colleges cut and...

I mean figured out the exact syntax for a "send-sql-statement" stored procedure. I reckon this is something more people would want.

OK, so I can have stored procedures, but I'm no Java-programmer. I thought maybe someone has this already figured out?

In some of the documentation the mention a stored procedure "send-sql-statement" which should be there by default. But... Is it only available in an Oracle-db? Can i even have stored-procedures on an progress-db? If so, how can i create a stored-procedure in a progress-db which allows me to...

In some of the documentation the mention a stored procedure "send-sql-statement" which should be there by default. But... Is it only available in an Oracle-db? Can i even have stored-procedures on an progress-db? If so, how can i create a stored-procedure in a progress-db which allows me to...

In some of the documentation the mention a stored procedure "send-sql-statement" which should be there by default. But... Is it only available in an Oracle-db? Can i even have stored-procedures on an progress-db? If so, how can i create a stored-procedure in a progress-db which allows me to...

Yes, it can be done. Yes, i'm probably "a serious glutton for punishment" whatever that means. I did it because we were creating a datawarehouse and weren't happy about the tools available. It had to be tied in with the production- db's logical and fysical db-scheme, batchjob scheduling...

Did it help? Because now I also see you have: CRViewer = chctrlFrame:ITEM(1). and I had: CRViewer = chCtrlFrame:CONTROLS:ITEM(1). maybe that causes the wrong com-handle to be set?

I'm not sure, but in my prototype i had two extra lines: CRViewer = chCtrlFrame:CONTROLS:ITEM(1). CRViewer:ReportSource = ichDocument. CRViewer:REFRESH. CRViewer:ViewReport. Since we're not yet on OE10, i haven't tested much with the viewer. So this is the only help I can give.

I'm having a problem with an updateble (static) browse. When I come to the last row in the view-port. I press enter (enabeling the row for update) update the record. leave again by pressing enter (only one field is enables so this equals go) After completion of the row-leave (=assign changes...

Joey, as Lee has stated "Who's all-or-nothing approach?" My only comment was about comments. Again as Lee stated (boy are we in agreement) "...any program without proper commenting is incomplete and arguably badly written." Anyone taking over someone elses project won't always go read every...

Mmm, lets see what the next reply is.

checkout the dump and reload routines in the progress help/KB you should probably want to "procopy empty" or "procreate something" from the ST-file from the original db and then load the df (and perhaps _users).

My smile just gets wider

joey.jeremiah wrote: Don't you just love that. :D

So you still have a problem reassigning the values? From what I read, you have a write-trigger on the table ptmstr, that fires and that gives you the "global shared global_user_lang_dir error". Because of this error, everything you try to do (assign) will be undone (the transaction is undone)...

I'm not familiar with Stored Procedures, but have had a SQL-statement gone wrong through an ; too much. Maybe you should ommit a last one in a section?