-
ChatterFeed
-
0Best Answers
-
0Likes Received
-
0Likes Given
-
10Questions
-
18Replies
A way to do this
Hi,
Is it possible to achieve this below?
http://boards.developerforce.com/t5/General-Development/Retrieve-data-records/m-p/602511#M92122
-
- Edward_chan
- April 09, 2013
- Like
- 0
- Continue reading or reply
Need more help
Hi,
Any help to this please?
http://boards.developerforce.com/t5/General-Development/Retrieve-data-records/m-p/602511#M92122
-
- Edward_chan
- April 09, 2013
- Like
- 0
- Continue reading or reply
Retrieve data/records
Hi,
I have several Custom Tabs below
http://dl.dropbox.com/u/40211031/t9.png
and I've already created the relevant Data link to my cloud. How to directly data from the above 3 Custom Tabs? Why do I get this?
Select * from MERCH...Merchandise;
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" does not contain the table "Merchandise". The table either does not exist or the current user does not have permissions on that table.
-
- Edward_chan
- April 08, 2013
- Like
- 0
- Continue reading or reply
Need some help
Hi,
Any help to this?
http://boards.developerforce.com/t5/General-Development/Need-more-help/m-p/601851#M92024
Do you have any ideas that I get this error below?
Select * from MERCH...mt_name_denorm;
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" does not contain the table "mt_name_denorm". The table either does not exist or the current user does not have permissions on that table.
-
- Edward_chan
- April 08, 2013
- Like
- 0
- Continue reading or reply
-
- Edward_chan
- April 05, 2013
- Like
- 0
- Continue reading or reply
Need clear definitions
Hi,
Can I have the clear definitions of these tables?
campaign
,task
,profile
,opportunity
-
- Edward_chan
- April 03, 2013
- Like
- 0
- Continue reading or reply
Table inside Developerforce
Hi,
I see there are many tables inside
Salesforce Field Reference Guide
but is "User" one valid table there?
-
- Edward_chan
- April 03, 2013
- Like
- 0
- Continue reading or reply
Need help
Can you please help on these?
http://boards.developerforce.com/t5/General-Development/Need-more-details-of-it/td-p/594703
http://boards.developerforce.com/t5/General-Development/No-change-are-applied-to-the-figures/td-p/59...
http://boards.developerforce.com/t5/General-Development/Which-this-front-end-is-designated-for/td-p/...
http://boards.developerforce.com/t5/General-Development/Need-more-details-of-it/td-p/594703
http://boards.developerforce.com/t5/General-Development/Check-the-option/td-p/594685
-
- Edward_chan
- April 03, 2013
- Like
- 0
- Continue reading or reply
Problems with the scripts
Hi,
Is there one table called "AccountTeamMember" in Developer force, or not? I've got this problem below, why?
Select * from MERCH...AccountTeamMember;
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" does not contain the table "AccountTeamMember". The table either does not exist or the current user does not have permissions on that table.
And how to resolve the problem with this script as well?
Select * from MERCH...ActivityHistory;
OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" returned message "Error 1 : INVALID_TYPE_FOR_OPERATION: entity type ActivityHistory does not support query".
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT "Tbl1002"."AccountId" "Col1004","Tbl1002"."ActivityDate" "Col1005","Tbl1002"."ActivityType" "Col1006","Tbl1002"."CallDisposition" "Col1007","Tbl1002"."CallDurationInSeconds" "Col1008","Tbl1002"."CallObject" "Col1009","Tbl1002"."CallType" "Col1010","Tbl1002"."CreatedById" "Col1011","Tbl1002"."CreatedDate" "Col1012","Tbl1002"."Description" "Col1013","Tbl1002"."DurationInMinutes" "Col1014","Tbl1002"."EndDateTime" "Col1015","Tbl1002"."Id" "Col1016","Tbl1002"."IsAllDayEvent" "Col1017","Tbl1002"."IsClosed" "Col1018","Tbl1002"."IsDeleted" "Col1019","Tbl1002"."IsReminderSet" "Col1020","Tbl1002"."IsTask" "Col1021","Tbl1002"."IsVisibleInSelfService" "Col1022","Tbl1002"."LastModifiedById" "Col1023","Tbl1002"."LastModifiedDate" "Col1024","Tbl1002"."Location" "Col1025","Tbl1002"."OwnerId" "Col1026","Tbl1002"."Priority" "Col1027","Tbl1002"."ReminderDateTime" "Col1028","Tbl1002"."Status" "Col1029","Tbl1002"."Subject" "Col1030","Tbl1002"."SystemModstamp" "Col1031","Tbl1002"."WhatId" "Col1032","Tbl1002"."WhoId" "Col1033" FROM "ActivityHistory" "Tbl1002"" against OLE DB provider "DBAmp.DBAmp" for linked server "MERCH".
-
- Edward_chan
- April 02, 2013
- Like
- 0
- Continue reading or reply
Need help
Hi,
Can you please help on these?
http://boards.developerforce.com/t5/General-Development/Need-more-details-of-it/td-p/594703
http://boards.developerforce.com/t5/General-Development/No-change-are-applied-to-the-figures/td-p/594731
http://boards.developerforce.com/t5/General-Development/Which-this-front-end-is-designated-for/td-p/594729
http://boards.developerforce.com/t5/General-Development/Need-more-details-of-it/td-p/594703
http://boards.developerforce.com/t5/General-Development/Check-the-option/td-p/594685
-
- Edward_chan
- April 02, 2013
- Like
- 0
- Continue reading or reply
- Edward chan
- April 08, 2013
- Like
- 0
- Continue reading or reply
Retrieve data/records
Hi,
I have several Custom Tabs below
http://dl.dropbox.com/u/40211031/t9.png
and I've already created the relevant Data link to my cloud. How to directly data from the above 3 Custom Tabs? Why do I get this?
Select * from MERCH...Merchandise;
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" does not contain the table "Merchandise". The table either does not exist or the current user does not have permissions on that table.
- Edward_chan
- April 08, 2013
- Like
- 0
- Continue reading or reply
Want to show the ID
Hi,
How can I adjust the below column to show the current OrganizationId of my cloud?
<apex:column headerValue="test">
<apex:outputText > value="getOrganizationId()"</apex:outputText>
</apex:column>
- Edward chan
- April 08, 2013
- Like
- 0
- Continue reading or reply
Need some help
Hi,
Any help to this?
http://boards.developerforce.com/t5/General-Development/Need-more-help/m-p/601851#M92024
Do you have any ideas that I get this error below?
Select * from MERCH...mt_name_denorm;
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" does not contain the table "mt_name_denorm". The table either does not exist or the current user does not have permissions on that table.
- Edward_chan
- April 08, 2013
- Like
- 0
- Continue reading or reply
- Edward_chan
- April 05, 2013
- Like
- 0
- Continue reading or reply
Table inside Developerforce
Hi,
I see there are many tables inside
Salesforce Field Reference Guide
but is "User" one valid table there?
- Edward_chan
- April 03, 2013
- Like
- 0
- Continue reading or reply
Problems with the scripts
Hi,
Is there one table called "AccountTeamMember" in Developer force, or not? I've got this problem below, why?
Select * from MERCH...AccountTeamMember;
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" does not contain the table "AccountTeamMember". The table either does not exist or the current user does not have permissions on that table.
And how to resolve the problem with this script as well?
Select * from MERCH...ActivityHistory;
OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" returned message "Error 1 : INVALID_TYPE_FOR_OPERATION: entity type ActivityHistory does not support query".
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT "Tbl1002"."AccountId" "Col1004","Tbl1002"."ActivityDate" "Col1005","Tbl1002"."ActivityType" "Col1006","Tbl1002"."CallDisposition" "Col1007","Tbl1002"."CallDurationInSeconds" "Col1008","Tbl1002"."CallObject" "Col1009","Tbl1002"."CallType" "Col1010","Tbl1002"."CreatedById" "Col1011","Tbl1002"."CreatedDate" "Col1012","Tbl1002"."Description" "Col1013","Tbl1002"."DurationInMinutes" "Col1014","Tbl1002"."EndDateTime" "Col1015","Tbl1002"."Id" "Col1016","Tbl1002"."IsAllDayEvent" "Col1017","Tbl1002"."IsClosed" "Col1018","Tbl1002"."IsDeleted" "Col1019","Tbl1002"."IsReminderSet" "Col1020","Tbl1002"."IsTask" "Col1021","Tbl1002"."IsVisibleInSelfService" "Col1022","Tbl1002"."LastModifiedById" "Col1023","Tbl1002"."LastModifiedDate" "Col1024","Tbl1002"."Location" "Col1025","Tbl1002"."OwnerId" "Col1026","Tbl1002"."Priority" "Col1027","Tbl1002"."ReminderDateTime" "Col1028","Tbl1002"."Status" "Col1029","Tbl1002"."Subject" "Col1030","Tbl1002"."SystemModstamp" "Col1031","Tbl1002"."WhatId" "Col1032","Tbl1002"."WhoId" "Col1033" FROM "ActivityHistory" "Tbl1002"" against OLE DB provider "DBAmp.DBAmp" for linked server "MERCH".
- Edward_chan
- April 02, 2013
- Like
- 0
- Continue reading or reply
Way to directly check Back-end data
Hi,
I know there should be one Back-end place in which the records are stored. Is there one direct way to retrieve the records?
Many Thanks & Best Regards,
Edward Chan
- Edward chan
- March 26, 2013
- Like
- 0
- Continue reading or reply