Viewing 7 posts - 1 through 7 (of 7 total)
Update: I exchanged "EmployeeID=@PMID" for "EmployeeID = @PMID". The error message has gone but I still get the blank paging with no sign of my footnote "This information is..."
Robin
September 3, 2007 at 3:40 am
Thanks for your input Steve, I tried the following:
SET LANGUAGE British
GO
DECLARE @msgstr VARCHAR(80)
DECLARE @cmd VARCHAR(80)
DECLARE @PMID INT
DECLARE @forename VARCHAR(30)
CREATE TABLE ##texttab (c1 text)
SET @msgstr = 'THE FOLLOWING QUOTES ARE CURRENTLY...
September 3, 2007 at 3:35 am
SET QUOTED_IDENTIFIER solved my problem.
thanks
Robin P
November 25, 2005 at 7:42 am
SET LANGUAGE works just fine, thanks - though I notice that ADO throws out an error message, code 0 which I can test for and avoid.
Robin P
November 25, 2005 at 2:05 am
There are null values all over the place, before and after where Import decides it has a problem. Just for grins I redid all four dates in record 2867, but...
October 11, 2005 at 10:35 am
David.....I have been having problems posting, so I will try again, picking up the thread where left off:
David,
Thanks for your response, I managed to lose my reply this morning (hit...
October 11, 2005 at 8:21 am
Thanks for your reply. I'm afraid I don't know the procedure for either using the Access Documentor or scripting my table.
There is definitely something wrong with a data cell...
October 10, 2005 at 7:54 am
Viewing 7 posts - 1 through 7 (of 7 total)