Report abuse. Details required :. Cancel Submit. I would try: Format [DailyOrders]. What are your data type of your fields? How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. In reply to dhookom's post on August 21, Right now this part of query is working Format [DailyOrders. Bill Mosca. You use a table that contains some fields whose names begin with double-byte arabic numbers.
Then, you create a query to select all the data for the field names that begin with double-byte arabic numbers. When you run this query, you receive the following error message:. Note The TableName placeholder represents the name of the table that you are querying. The FieldName placeholder represents the name of the field name that you are querying.
Is PalletBarcode the same data type in every query? How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. In reply to dhookom's post on May 15, Duane: Yes, PalletBarcode is the same data type in all queries An example of one would be: P Any help you can offer is appreciated greatly. In reply to DarrenLightfoot's post on May 15, Do all the users have the same permissions to the SQL Server tables?
Are there any parameters in the earlier queries? Duane: I don't believe it Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.
Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled.
0コメント