Foreign access to the database established a DBLINK can be connected to the internal database, outside the SID for SALES, the company in the SID for KMSALES, two machines on a table have the same ZZ_CLI, here in PB to statistical KMSALES a column to specify conditions and,
Select sum (czfy) into: SCZ from ZZ_CLI @ KMSALES perform error, do not add @ KMSALES can, but that of the query is the SALES of the above table, and put the ZZ_CLI @ KMSALES in an SQL string, associated with the data window is no problem, check the help file also can not find the reason, PB VB - MS SQL in operation before [] can, don't know what to do here, please expert advice,
CodePudding user response:
To establish two connected yao sqlca1 sqlca2