- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
USE [DIAMDBF] GO /****** Object: StoredProcedure [dbo].[STOCKREPORT] Script Date: 01/21/2011 11:32:40 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[JEWELLSTOCKREPORT] @SELDBNM SYSNAME, @FILENO1 nvarchar(7), @FROMCODE nvarchar(20), @TOCODE nvarchar(20), @START nvarchar(12), @LAST nvarchar(12), @DATE1 nvarchar(12), @DATE2 nvarchar(12), @DATEFORMAT varchar(12), @GROUPCODE char(10), @FROMLOT nvarchar(10), @TOLOT nvarchar(10) AS Declare @execstring … |
|
Re:
hi. HAPPY NEW YEAR! :) I'm making a system that uses ms access2003 and vb6. My problem is how to search the database with two field names (namely: Lastname, Firstname) and yet I can still search them one by one. Ex. the Lastname field = "Smith" while the Firstname field … |