UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Controlled Length Value Of Control On Form, Access 2003    
 
   
mr.siro
post Feb 19 2019, 07:23 AM
Post#21



Posts: 149
Joined: 27-January 18



hello cheeky, try this one
Attached File(s)
Attached File  demo.zip ( 140.29K )Number of downloads: 3
 
Go to the top of the page
 
cheekybuddha
post Feb 19 2019, 10:26 AM
Post#22


UtterAccess VIP
Posts: 10,908
Joined: 6-December 03
From: Telegraph Hill


Please can you give me a CREATE TABLE statement for table_1, and also the StoredProc definition for 'test'.

--------------------


Regards,

David Marten
Go to the top of the page
 
mr.siro
post Feb 19 2019, 11:40 AM
Post#23



Posts: 149
Joined: 27-January 18



CODE
CREATE TABLE [dbo].[Table_1](
    [a] [nchar](10) NULL,
    [b] [nchar](10) NULL,
    [c] [nchar](10) NULL,
    [d] [nchar](10) NULL,
    [e] [nchar](10) NULL,
    [f] [nchar](10) NULL,
    [g] [nchar](10) NULL,
    [h] [nchar](10) NULL,
    [i] [nchar](10) NULL,
    [j] [nchar](10) NULL,
    [k] [nchar](10) NULL,
    [l] [nchar](10) NULL,
    [m] [nchar](10) NULL,
    [n] [nchar](10) NULL,
    [o] [nchar](10) NULL,
    [p] [nchar](10) NULL,
    [q] [nchar](10) NULL,
    [x] [nchar](10) NULL,
    [z] [nchar](10) NULL,
    [w] [nchar](10) NULL
) ON [PRIMARY]


CODE
CREATE PROC [dbo].[test]
@para NVARCHAR(10)
AS
BEGIN
    SELECT * FROM dbo.Table_1 WHERE @para IS NULL OR a = @para
END
Go to the top of the page
 
2 Pages V < 1 2


Custom Search


RSSSearch   Top   Lo-Fi    22nd February 2019 - 09:58 AM