4D v15
I run the following code: The SQL Login goes to the database that is running.
DA_SQL_Login2
C_TEXT(tLookFor)
tLookFor:="%Mc%"
ARRAY TEXT(aFoundNames;0)
ARRAY TEXT(aFoundPhones;0)
Begin SQL
Select FullName, Phone FROM PatientBase WHERE (FullName like :tLookFor) INTO
:aFoundNames, :aFoundPhones ;
End SQL
DA_SQL_Logout
//TRACE
OpenWindow (530;345;Regular window;"")
set window title("Records found "+string(size of array(aFoundNames)))
DIALOG("NamesAndPhonesFound")
CLOSE WINDOW
`TRACE
QUERY([PatientBase];[PatientBase]FullName="@mc@")
SELECTION TO
ARRAY([PatientBase]FullName;aFoundNames;[PatientBase]Phone;aFoundPhones)
OpenWindow (530;345;Regular window;"")
set window title("Records found "+string(size of array(aFoundNames)))
DIALOG("NamesAndPhonesFound")
CLOSE WINDOW
The SQL Login goes to the database that is running.
The SQL select returns 34 records. The 4D Query returns 404.
So what is wrong?
_________________________________________
Bob McKeever http://www.mswl.com <http://www.mswl.com/>
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@mac.com
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************
