By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,105 Members | 1,040 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,105 IT Pros & Developers. It's quick & easy.

Problems sorting forms in Access 2003

P: n/a
In Access 2003 when the user right clicks and selects sort ascending or
sort descending they get the following message, Data shape command text
contains a syntax error at or near position 98 in the command. The text
near the error is: "::]) AS "dbo"."spselSyQueryFieldList".*".

The form is in an ADP file that is linked to a SQL Server 2000
database. The stored procedure that is the source for the form is
spselSyQueryFieldList. The content of that stored procedure is shown
below. Can anyone help us so that we do not have this error?

ALTER PROCEDURE dbo.spselSyQueryFieldList
@pQueryId int
AS

SELECT QueryFieldID,
QueryId,
FieldName,
FieldNameIsValidYesNo,
CriteriaFieldName,
CriteriaFieldNameIsValidYesNo,
DisplayName,
DisplaySeq,
ColumnHeading,
EntryMask,
TypeId,
Lookup,
Width,
AttachedTable,
LinkFieldName,
AggregateType,
AutoAddedYesNo,
FieldExpression,
UserName,
UserDateTime
FROM SyQueryField
WHERE QueryId = @pQueryId

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.