[Uwe Smidt]

Dear Minh Phuong,

I recently had a mis-mapping between a Postgres Servertable and an Omnis Schema on the primary key property.

I don’t know if it was a problem of the Postgres-DAM or of Postgres itself. But when I recreated the Postgres Object (via PGAdmin), in this case the table, the mis-mapping stopped, and primary was primary on both sides.

This is only a workaround, but it could help you to isolate the problem.

Best regards

Uwe

• This reply was modified 2 years, 9 months ago by  Uwe Smidt.

[Uwe Smidt]

Dear Marten,

Thank you for your answer!

My wish to do it in just one line of code seems to be like ‘sawing off the tree branch on which you sit’ – so I’ll do it in 2 lines as proposed by you 😉

Best regards!

[Uwe Smidt]

Dear Andreas,

Thank you for your prompt and comprehensive answer!

I assume your solution works fine for an isolated problem in one form.

But if the problem is more complex or difficult to locate in an application/library, it may become more economic to include the whole database for the troubleshooting, as opposed to rebuilding parts of an application into a stand-alone prototype to reproduce the problem.

Therefor I look for an approach to include the database structure & data along with the library.

But I assume there is no such easy way with little effort on the sending and receiving side. Instead, probably doing a database dump and sending it along side, plus a dialog to edit connection parameters, is the better way…

Thank you anyway

Best regards

Uwe

• This reply was modified 2 years, 11 months ago by  Uwe Smidt.

[Uwe Smidt]

Thanx for your response, Paul!

I am using 10.2, and quite honestly, I don’t know how many concurrent users my developer license allows for – I’ll check.

But even so, there seems no way to log in to the headless server when I’m the n+1’th user, in order to kick out users as admin.

I assume your command kills all processes, as opposed to resetting client connections. Then I’d rather restart the container with ‘docker restart <containerID>

But instead of using a sledge hammer I was looking for a way to check & kick out client connections…

[Uwe Smidt]

Dear Götz,

Thanks for your answer.

I had hoped for an easier and more general way to display previews of any kind of file, as in MacOS’s Finder…

But this should work for PDFs!

[Uwe Smidt]

Hi Götz,

Thank you for your help! I tested it, and yes, it works fine for all(?) image formats as jpg, png, svg etc, also for PDF, and even for special formats like NEF (Nikon RAW format).

But it does not preview text files, XML, CSV, Docs etc – which would be great for what I want to do – a small Document Management system. Maybe that needs a special tool / external site etc …?

With

Begin statement
Sta: <div>
Sta: <h2>Pictures</h2>
Sta:

You can embed pictures.

Sta:
Sta: </div>
End statement
Get statement lcHTML
Calculate $cinst.$objs.ctrHTML.$html as lcHTML

I could display all these image files, but I needed to put them to a directory on my Web server first.<div>Is there a way to display test.pdf in ctrHTML when the file is stored in irData.File?</div><div>

Sta: irData.File] width=”200″ height=”176″ alt=”Test” />

did not work!

Thanks in advance!</div><div>Uwe</div>

• This reply was modified 2 years, 10 months ago by  Uwe Smidt.