Now run under Windows 7, seem to view the SQL statements in the program has a problem, can not get the data results under Windows xp, is there a way to make up for it? xie

CodePudding user response:

Should not, should be the network connection problem,

CodePudding user response:

reference 1st floor apple_8180 response:

should not be, should be network connectivity issues,

All under the Windows 7 is the same, all the data in the table can be obtained by the view, if access to part of the just is not successful, get zero data.
Do not have this problem under Windows xp

CodePudding user response:

View
the condition ofThe unit code=? The user to select the code
If customer choose code "is the primary unit of code, and then success
If customer choose code "is a subsidiary unit code, not success

Under the same program in Windows xp without any problems

CodePudding user response:

1.=and==
2. The problem of space
In the XP system, look up table data, field="value", as the condition, can find out data, but in Windows 7, no data, the solution is ALLT (field)="value" as the condition, it is ok.
Such as;
Select the name of the table 1
LOCATE the FOR field 1=ALLT (THISFORM. TEXT1. VALUE) & amp; & In the XP system can check the data, but won't find it in the Windows 7 system.
LOCATE the FOR ALLT fields (1)=ALLT (THISFORM. TEXT1. VALUE) & amp; & It can check the Windows 7.

CodePudding user response:

Thank you, this system is compiled, can't modify the source code, can modify the SQL statement in the view?

CodePudding user response:

I tried it on
View the SQL
Fields where ALLT (1)=(VALUE) THISFORM. TEXT1. An operation requires the input parameters of view, not do
Where field (1)=allt (VALUE) THISFORM. TEXT1. This doesn't work