Jump to content

display memo field


Wilton Ergon

Recommended Posts

unigui  1.90.0.1547

delphi 10.4

sdac

sql server 2019

I have a problem that is making me sleepy.
in a form I display the contents of a varchar (max) sql server field.
when I run the application locally, the content is displayed correctly, when I run the same application on the server (hyperserver) some data is overlaid.
I've tried everything and nothing works.

it is not some hidden character that is causing this behavior.

the only difference and the place of execution.

remembering that both on my server and locally, and the exe that is running.

 

I tried to make a test case to demonstrate this, but locally it works, so there is no way for me to send a sample to demonstrate the problem.

this did not happen in the old version using sencha 6.7

 

image.thumb.png.4911f8c340255bb9a8f1cb62aac055eb.png

 

Running my server

 

image.thumb.png.2fdf23cce48324bb97de8f0442906184.png

 

 

text post in database.

image.thumb.png.054a135ee92cab183c835e5070f10f3a.png

 

display value in notepad++

image.thumb.png.1943c4d11774addee3c6c9e964c43255.png

 

 

 

 

Link to comment
Share on other sites

Sherzod, I already tried this, but the application running locally (localhost) does not have this problem
the problem only occurs when I publish it on my server.
it runs on the hyperserver
here I have windows 10
on server windows server 2019
so if I do an example it will not show the problem.

Link to comment
Share on other sites

  • 6 months later...
On 4/28/2021 at 3:14 PM, wilton_rad said:

unigui  1.90.0.1547

delphi 10.4

sdac

sql server 2019

I have a problem that is making me sleepy.
in a form I display the contents of a varchar (max) sql server field.
when I run the application locally, the content is displayed correctly, when I run the same application on the server (hyperserver) some data is overlaid.
I've tried everything and nothing works.

it is not some hidden character that is causing this behavior.

the only difference and the place of execution.

remembering that both on my server and locally, and the exe that is running.

 

I tried to make a test case to demonstrate this, but locally it works, so there is no way for me to send a sample to demonstrate the problem.

this did not happen in the old version using sencha 6.7

 

image.thumb.png.4911f8c340255bb9a8f1cb62aac055eb.png

 

Running my server

 

image.thumb.png.2fdf23cce48324bb97de8f0442906184.png

 

 

text post in database.

image.thumb.png.054a135ee92cab183c835e5070f10f3a.png

 

display value in notepad++

image.thumb.png.1943c4d11774addee3c6c9e964c43255.png

 

 

 

 

Hello wilton,

In your Server PC, did you update also your build 1547  :   hyper_service.exe (or hyper_service.dll)   ?

Or simply deployed your new release app.exe

 

Solution :

Try to stop your service (or iis) on your server and copy the new files 1547 :

hyper_service.exe  (if service)   +    hyper_service.cfg

or

hyper_service.dll   (if ISAPII)   +   hyper_service.cfg

 

Keep in mind that  each new Unigui Build, you have to update theese files  !

 

From Farshad :

"The new version is not fully compatible with older HyperServer builds.

So you need to upgrade Hyperserver too."

Link to comment
Share on other sites

o problema foi resolvido, nos servidores de aplicativos, necessários para instalar a biblioteca de acesso ao sql server 2019, MSOLEDB, em versões anteriores do servidor SQL, cliente nativo usado, cliente nativo não e totalmente compatível com sql 2019, gerando problemas na busca em campos de varchar (max), isso me fez relacionar com a versão do sencha, pois foi na mesma data que eu fiz a troca também sql servidor

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...