Messages

1

Web Server - Ask For Help / Re: Signature

« on: April 15, 2015, 04:06:33 PM »

Yes that is the correct length.  I don't use fm3, but in the backend I use a varchar(max).  I think you can override fm3 though to specify the datatype.

2

Web Server - Ask For Help / Re: Signature

« on: April 15, 2015, 12:36:05 PM »

I think I got that number from memo field settings from DMC.

3

Web Server - Ask For Help / Re: Signature

« on: April 15, 2015, 07:48:17 AM »

Hi Kevin,

In SQL I use a varchar(max) datatype, and in Clarion a string 1650000

HTH

Debra

4

Web Server - Ask For Help / Multi-Host, and mixed SSL \ Non SSL sites

« on: October 15, 2014, 04:20:28 AM »

Hi All,

I have a webserver that I would like to do multi host on.  But my web  server is both secure and non-secure.
Do I have add another web server to multi host to handle mixed sites, or will the dll site with mixed handle  the mixed servers?
And if I do have to modify Multi-Host is there anything that I need to watch out for?
Thanks
Debra

5

Web Server - Ask For Help / Re: SQL Sleeping Connections

« on: January 22, 2014, 05:17:26 PM »

I have it on each table in my dictionary in the driver options /verifyviaselect.  I tried setting in at the connection in my web handler - process link embed but it does not seem to do the trick there...  but the dictionary does. 
This also made a significant performance increase when opening forms for one of my wider (many columns) tables.

6

Web Server - Ask For Help / Task Panel Menu Level 2 - Start Closed?

« on: January 22, 2014, 02:50:12 PM »

Hi All,
I have a Task Panel Menu, and I want to have a second level of menu items within level 1.  But how can I set the level 2 menu to start as closed rather than opened?  Pic attached for illustration.

Thanks
Debra


[attachment deleted by admin]

7

Web Server - Ask For Help / Re: Mobile Form, Always goes to next field

« on: January 22, 2014, 08:28:10 AM »

Thank you Bruce!

8

Web Server - Ask For Help / Re: SQL Sleeping Connections

« on: January 22, 2014, 07:14:31 AM »

If a sleep connection is blocking, that indicates that the transaction is still active.  I had the same issue and it took a lot of digging and frustration.  I looked for where I had opened files and not closed them in my code, make sure you are not doing auto-inc in clarion as this can cause a new connection to start and not close properly, and last but not least make sure if you are using MSSQL that you are using verifyViaSelect.  In the end, even after I made sure all my files were getting closed and the auto inc was on the server... the verifyViaSelect solved the last of the issue for me.  It seems that when it was using the stored procedure to validate the file structure clarion did not always close the connection after it was done with that task.

To troubleshoot these issues I added a few admin pages that displayed the "Active Transactions", and the "Cursors" with the last statement that generated both.  Following is the code for that. 

Active Transactions
-----------------------------------------------
Create View v_ActiveTransactions
as
SELECT
       [s_tst].[session_id],
       [s_es].[login_name] AS [Login Name],
       DB_NAME (s_tdt.database_id) AS [Database],
       [s_tdt].[database_transaction_begin_time] AS [Begin Time],
       [s_tdt].[database_transaction_log_bytes_used] AS [Log Bytes],
       [s_tdt].[database_transaction_log_bytes_reserved] AS [Log Rsvd],
       [s_est].text AS [Last T-SQL Text],
       [s_eqp].[query_plan] AS [Last Plan]
   FROM
       sys.dm_tran_database_transactions [s_tdt]
   JOIN
       sys.dm_tran_session_transactions [s_tst]
   ON
       [s_tst].[transaction_id] = [s_tdt].[transaction_id]
   JOIN
       sys.[dm_exec_sessions] [s_es]
   ON
       [s_es].[session_id] = [s_tst].[session_id]
   JOIN
       sys.dm_exec_connections [s_ec]
   ON
       [s_ec].[session_id] = [s_tst].[session_id]
   LEFT OUTER JOIN
    sys.dm_exec_requests [s_er]
   ON
       [s_er].[session_id] = [s_tst].[session_id]
   CROSS APPLY
       sys.dm_exec_sql_text ([s_ec].[most_recent_sql_handle]) AS [s_est]
   OUTER APPLY
       sys.dm_exec_query_plan ([s_er].[plan_handle]) AS [s_eqp]
   ORDER BY
       [Begin Time] ASC;

GO


Cursors
-------------------------
CREATE View [dbo].[dv_CursorSessions]
as
select  login_time,status,last_request_start_time,last_request_end_time,
ses.transaction_isolation_level, ses.lock_timeout,row_count, c.*, t.text
from sys.dm_exec_sessions ses
cross apply sys.dm_exec_cursors(ses.session_id) c
CROSS APPLY sys.dm_exec_sql_text (c.sql_handle) t
where ses.is_user_process=1  and ses.session_id <> @@SPID

GO

9

Web Server - Ask For Help / Mobile Form, Always goes to next field

« on: January 21, 2014, 12:50:16 PM »

Hi All

In the newer releases of nettalk (i.e. >7.25) not sure which version this started in, but 7.25 does not do this but 7.32 & 7.33 do.  In longer forms in mobile mode no matter where you click or press with your finger it always goes to the next field, not where you selected.
Attached is a demo app and a short video to see it in action.
 
This example was done with C8.9759 and NT 7.33

Thanks

Debra

[attachment deleted by admin]

10

Web Server - Ask For Help / Re: Popup Form on Child Browse no longer working?

« on: December 16, 2013, 06:35:53 AM »

I just recently went through all my pages converting the forms to popups.  And I found that popups are not forgiving at all with custom xHTML slip ups, as where pages are very forgiving. 
And the trick I found to firebug to get it to tell me what the HTML error in the form was, is to look at the console, open the form, find the link to the form it was trying to use.  Copy the location, open it in a different tab, and the browser will tell you there is invalid code and where to find it.  My version of firebug does not tell me the html errors in a popup unless I follow these steps.

Looking at your HTML I think the extra < on your <b> tag would cause the problem.

HTH
Debra

11

Web Server - Ask For Help / On Session Expire, go to index page?

« on: December 11, 2013, 01:08:36 PM »

Hi All,

When a session expires, it takes me to the loginForm.  But when you go to log back in, it takes to the index page, then you have to click the login page button... and press the login button on the login form again before you can login successfully.
How can I make it so that on session expire it takes you to the indexPage rather than the login form?  Or some other solution so you don't have this process of login form to index page and back to login form happening?
Thanks
Debra

12

Web Server - Ask For Help / Re: How to prevent wide page from wrapping in Content mode

« on: December 08, 2013, 06:46:28 AM »

Thanks Urayoan, I found it.... its nt-contentpanel-l

13

Web Server - Ask For Help / How to prevent wide page from wrapping in Content mode

« on: December 07, 2013, 04:04:57 PM »

Some of my browses can be pretty wide, and when I try to open the page as Content it puts the browse under the left menu, rather than to the right of the left menu.  When I open the page as a Link it opens as it should to the right of the left menu...  how can I make Content behave like Link in this respect.

14

Web Server - Ask For Help / Re: Cryptonite - SHA256 Hashing with a Key

« on: November 27, 2013, 06:04:33 AM »

Hi Bruce.

Is this the correct usage?  outData = Clip(inData)

Code: [Select]

dataLen = Len(Clip(outData))         ! Text data, so we are clipping it. For binary data it would not be clipped
st.SetValue(outdata)
Crypto.MakeHMAC(st,clip(password),cs:CALG_SHA_256)

outData =st.GetValue()
Also is it a correct assumption that this is hex, so I need to follow it up with a

Code: [Select]

st.Base64Encode()

15

Web Server - Ask For Help / Re: Cryptonite - SHA256 Hashing with a Key

« on: November 27, 2013, 05:16:53 AM »

As always, Thanks Guys!