Write the database connection transaction sqlcode is=0, database is connected, but can not execute the SQL statement

 
If I=1 then 
SELECT COUNT (1) 
INTO: j 
FROM the TEST 
USING hisjk_link; 
End the if 
Messagebox (' ts' j) 

Pop-up prompts j is 0, ah, you PLS help genuflect is begged!

CodePudding user response:

No data in the TEST table?

CodePudding user response:

Test table is built my own test, actually even not the local database, the test list I wrote two records

CodePudding user response:

Make sure no wrong connection?

CodePudding user response:

Breakpoint hisjk_link properties, look at whether the database connection is you want to connect the database

CodePudding user response:

The qing how to return a responsibility?

CodePudding user response:

refer to the original poster xx_shen response:

written by database connection transaction sqlcode is=0, explain the database has been is connected, but can not execute SQL statements

 
If I=1 then 
SELECT COUNT (1) 
INTO: j 
FROM the TEST 
USING hisjk_link; 
End the if 
Messagebox (' ts' j) 

Pop-up prompts j is 0, ah, you PLS help genuflect is begged!

If I=1 then
SELECT COUNT (1)
INTO: j
FROM the TEST.
End the if
Messagebox (' ts' j)

So write to try again