function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Edward_chanEdward_chan 

Table inside Developerforce

Hi,
I see there are many tables inside
Salesforce Field Reference Guide

but is "User" one valid table there?

Madhan Raja MMadhan Raja M

Yes, Edward. User has a table in Salesforce.

 

Regards,

Madhan Raja M
Edward_chanEdward_chan

But why do I get this fine
Select * from MERCH...contact;

and am having this error
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'User'.

with this,
Select * from MERCH...User;

while MERCH is pointing to the current DB side of our Developerforce cloud?
Madhan Raja MMadhan Raja M

Edward,

 

The error message says "Incorrect syntax near the keyword 'User'". Post the compete SQL query used.

 

Regards,

Madhan Raja M
Edward_chanEdward_chan

This is the complete script I have used to run

Select * from MERCH...User;

 

BTW, is "ActivityHistory" one valid table inside DeveloperForce or not?