Tadeu,
If you are using a version of SQL Server you could use the attached script to create a SQL View, then create an ARS View form for the SQL View. Here is how my screen looks: HTH Stephen Remedy Skilled Professional -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Monday, April 07, 2008 10:34 AM To: arslist@ARSLIST.ORG Subject: RES: How to know when a table is full ?? Hi John, Thanks for your reply... But I would like to create this in a AR Sytem Form... (like Alert Events, AR System Email Messages) Could I create new Fields in these kind of forms without any worry about modify AR System Forms??? Att, Tadeu Augusto Dutra Pinto _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<<image001.png>>
CREATE VIEW dbo.udv_ARS_FormRowCounts
AS
SELECT a.schemaId, b.Name FormName, CONVERT(VARCHAR,a.TableName) TableName,
a.TotalRows, CHECKSUM(a.TableName) RequestID
FROM (SELECT so.Name TableName, MAX(si.rows) TotalRows,
CASE ISNUMERIC(SUBSTRING(so.Name, 2, 99))
WHEN 1 THEN SUBSTRING(so.Name, 2, 99)
ELSE
CASE ISNUMERIC(SUBSTRING(so.Name, 3,
1))
WHEN 0 THEN SUBSTRING(so.Name, 2, 1)
ELSE
CASE
ISNUMERIC(SUBSTRING(so.Name, 4, 1))
WHEN 0 THEN SUBSTRING(so.Name,
2, 2)
ELSE
CASE
ISNUMERIC(SUBSTRING(so.Name, 5, 1))
WHEN 0 THEN
SUBSTRING(so.Name, 2, 3)
ELSE
CASE
ISNUMERIC(SUBSTRING(so.Name, 6, 1))
WHEN 0 THEN
SUBSTRING(so.Name, 2, 4)
ELSE
CASE
ISNUMERIC(SUBSTRING(so.Name, 7, 1))
WHEN 0
THEN SUBSTRING(so.Name, 2, 5)
ELSE
CASE ISNUMERIC(SUBSTRING(so.Name, 8, 1))
WHEN 0 THEN SUBSTRING(so.Name, 2, 6)
END
END
END
END
END
END
END schemaId
FROM sysobjects so
JOIN sysindexes si
ON si.id = OBJECT_ID(so.name)
WHERE so.xtype = 'U'
AND LEFT(so.Name,1) IN ('T','B','H')
AND ISNUMERIC(SUBSTRING(so.Name,2,1)) = 1
GROUP BY so.Name) a
JOIN arSchema b
ON a.schemaId = b.schemaId
