Also "Creating a New Script" tells about syntax coloring and Intellisense. Is it supposed to work only if you have VFP installed on this computer?
After I added SQApplication.DataEngine.Databases.
I'm getting a new error
( 1, 1) C "FNAME"
( 1, 2) C "C"
( 1, 3) N 25 ( 25.00000000)
( 1, 4) N 0 ( 0.00000000)
( 1, 5) L .F.
( 1, 6) L .F.
( 1, 7) C ""
( 1, 8) C ""
( 1, 9) C ""
( 1, 10) C ""
( 1, 11) C ""
( 1, 12) C ""
( 1, 13) C ""
( 1, 14) C ""
( 1, 15) C ""
( 1, 16) C ""
( 1, 17) N 0 ( 0.00000000)
( 1, 18) N 0 ( 0.00000000)
( 2, 1) C "LNAME"
( 2, 2) C "C"
( 2, 3) N 20 ( 20.00000000)
( 2, 4) N 0 ( 0.00000000)
( 2, 5) L .F.
( 2, 6) L .F.
( 2, 7) C ""
( 2, 8) C ""
( 2, 9) C ""
( 2, 10) C ""
( 2, 11) C ""
( 2, 12) C ""
( 2, 13) C ""
( 2, 14) C ""
( 2, 15) C ""
( 2, 16) C ""
( 2, 17) N 0 ( 0.00000000)
( 2, 18) N 0 ( 0.00000000)
( 3, 1) C "CID"
( 3, 2) C "C"
( 3, 3) N 6 ( 6.00000000)
( 3, 4) N 0 ( 0.00000000)
( 3, 5) L .F.
( 3, 6) L .F.
( 3, 7) C ""
( 3, 8) C ""
( 3, 9) C ""
( 3, 10) C ""
( 3, 11) C ""
( 3, 12) C ""
( 3, 13) C ""
( 3, 14) C ""
( 3, 15) C ""
( 3, 16) C ""
( 3, 17) N 0 ( 0.00000000)
( 3, 18) N 0 ( 0.00000000)
LCFIELD Local C "Email" processcursor
LNJ Local L .F. processcursor
LOAFIELD Local O SFRFIELD processcursor
LCASFIELD Local C "Email" processcursor
LCTOTAL Local C "N" processcursor
LCTYPE Local C "C" processcursor
LNLEN Local N 10 processcursor
LNDEC Local N 0 processcursor
LCFORMAT Local C "" processcursor
LCALIAS Local C "PEOPLE" processcursor
LLLOCAL Local L .T. processcursor
LNFIELD Local N 0 processcursor
LCCURSORTYPE Local C "U" processcursor
LCEXPR1 Local C "nvl(cast(GetEMails(cID) as C(10)),'
')" processcursor LCAFIELD Local C "Email" processcursor
LCBLANK Local C "' '" processcursor
LNSELECT Local N 24 processcursor
LLERROR Local L .F. processcursor
LOEXCEPTION Local L .F. processcursor
LCCAPTION Local L .F. processcursor
LCEXPR2 Local C "Full_Name" processcursor
LLALIAS Local L .F. processcursor
LLCALCCOUNT Local L .F. processcursor
LCORDERBY Local L .F. processcursor
LCSUMMARYORDERBY Local L .F. processcursor
LCSQLSELECT Local L .F. processcursor
LNOCCURS Local L .F. processcursor
LNPOS Local L .F. processcursor
LCSTRING Local L .F. processcursor
LALINES Local A processcursor
( 1) L .F.
LNPOS2 Local L .F. processcursor
LCLOGMESSAGE Local L .F. processcursor
LCDIRECTORY Local L .F. processcursor
LASORTS Local A processcursor
( 1) L .F.
LNSORTS Local L .F. processcursor
LCCURSOR1 Local L .F. processcursor
LCCOLLATE Local L .F. processcursor
LCCURSOR Local L .F. processcursor
LCCURSOR2 Local L .F. processcursor
LNRECORDS Local L .F. processcursor
TICUSTOMERID Local C " 147" getemails
LNSELECT Local N 24 getemails
LCSELECT Local C "select Phone, Type from Phones where CID= 1
47 AND Type LIKE 'E-mail%' and Phones.Phone <>
space(60)" getemails LCPHONES Local L .F. getemails
LODATABASE Local O DATABASE getemails
SQLSTATEMENT Local C "select Phone, Type from Phones where CID= 1
47 AND Type LIKE 'E-mail%' and Phones.Phone <>
space(60)" executesqlstatement
PARAMETERSCOLLECTION Local L .F. executesqlstatement
CURSORNAME Local C "TempCursor" executesqlstatement
LLXML Local L .F. executesqlstatement
LCCURSOR Local C "TempCursor" executesqlstatement
LOUTILITY Local L .F. executesqlstatement
LNI Local L .F. executesqlstatement
LOVALUE Local L .F. executesqlstatement
LUVALUE Local L .F. executesqlstatement
LCPARAMETER Local L .F. executesqlstatement
LOEXCEPTION Local L .F. executesqlstatement
LLOK Local L .F. executesqlstatement
LCXML Local L .F. executesqlstatement
TCSELECT Local C "select Phone, Type from Phones where CID= 1
47 AND Type LIKE 'E-mail%' and Phones.Phone <>
space(60)" selectfromanytables TCCURSOR Local C "TempCursor" selectfromanytables
LLRETURN Local L .F. selectfromanytables
TCSELECT Local C "select Phone, Type from Phones where CID= 1
47 AND Type LIKE 'E-mail%' and Phones.Phone <>
space(60)" selectfromanytables TCCURSOR Local C "TempCursor" selectfromanytables
LLRETURN Local L .F. selectfromanytables
TCSELECT Local C "select Phone, Type from Phones where CID= 1
47 AND Type LIKE 'E-mail%' and Phones.Phone <>
space(60)" selectfromanytables TCCURSOR Local C "TempCursor" selectfromanytables
LLRETURN Local L .F. selectfromanytables
TCSELECT Local C "select Phone, Type from Phones where CID= 1
47 AND Type LIKE 'E-mail%' and Phones.Phone <>
space(60)" selectfromanytables TCCURSOR Local C "TempCursor" selectfromanytables
TCSELECT Local C "select Phone, Type from Phones where CID= 1
47 AND Type LIKE 'E-mail%' and Phones.Phone <>
space(60)" selectfromsingletable TCALIAS Local C "" selectfromsingletable
TCCURSOR Local C "TempCursor" selectfromsingletable
LLRETURN Local L .F. selectfromsingletable
TCSELECT Local C "select Phone, Type from Phones where CID= 1
47 AND Type LIKE 'E-mail%' and Phones.Phone <>
space(60)" selectfromsingletable TCALIAS Local C "" selectfromsingletable
TCCURSOR Local C "TempCursor" selectfromsingletable
LCSELECT Local C "select Phone, Type from Phones where CID= 1
47 AND Type LIKE 'E-mail%' and Phones.Phone <>
space(60)" selectfromsingletable LNTABLES Local N 1 selectfromsingletable
LATABLES Local A selectfromsingletable
( 1, 1) C "Phones"
( 1, 2) C "Phones"
LNI Local N 2 selectfromsingletable
LCTABLE Local C "master!Phones" selectfromsingletable
LCDATABASE Local C "master" selectfromsingletable
LCALIAS Local C "Phones" selectfromsingletable
LNPOS Local N 0 selectfromsingletable
LOCURSOR Local O SFRCURSOR selectfromsingletable
LOQUERY Local O SFQQUERYENGINE selectfromsingletable
LCSHOWPLAN Local L .F. selectfromsingletable
LLRETURN Local L .F. selectfromsingletable
LCFILENAME Local C "C:\Documents and Settings\center\My Documents
\error.txt" click TCFILENAME Local C "C:\Documents and Settings\center\My Documents
LCLOG Local C "c:\PROGRAM FILES\STONEFIELD QUERY SDK\Data\ER
RORLOG.DBF" createlogfile
LCFILE Local C "C:\DOCUME~1\CENTER\LOCALS~1\TEMP\_2D4185222.T
XT" getmemvars
Call stack:
1,c:\program files\stonefield query sdk\sfquery.exe,startup,,0,
2,sysmain.fxp,sysmain,,0,
3,,sfqapplication.readevents,,0,
4,,sfapplication.readevents,,0,
5,,sfqreportsmain.cmdedit.click,,0,
6,,sfqreportsmain.editreport,,0,
7,,sfqreportsmain.showwizard,,0,
8,,sfrwizardquick.cmdpreview.click,,0,
9,,sfrwizardquick.runpreviewreport,,0,
10,,sfqreportengine.runreport,,0,
11,,sfreportengine.runreport,,0,
12,,sfqreportengine.createcursor,,0,
13,,sfqdataengine.createcursor,,0,
14,,sfdataengine.createcursor,,0,
15,,sfqdataengine.processcursor,,0,
16,c:\docume~1\center\locals~1\temp\getemails.fxp,getemails,c:\docume~1\center\locals~1\temp\getemails.prg,9,loDatabase.ExecuteSQLStatement(m.lcSelect, , 'TempCursor')
17,shadow.fxp,database.executesqlstatement,,0,
18,,master.selectfromanytables,,0,
19,,sfrdatabase.selectfromanytables,,0,
20,,master.selectfromanytables,,0,
21,,sfrdatasourcevfp.selectfromanytables,,0,
22,,master.selectfromsingletable,,0,
23,,sfrdatasourcevfp.selectfromsingletable,,0,
24,,master.error,,0,
25,,sfcustom.error,,0,
26,,sfqerrormgr.errorhandler,,0,
27,,sfqerrormgr.displayerror,,0,
28,,sferrormgr.displayerror,,0,
29,,sferrormessagedialogemail.cmdsave.click,,0,
30,,sferrormessagedialogemail.createlogfile,,0,
31,,sfqerrormgr.logerror,,0,
32,,sfqerrormgr.getmemvars,,0,
33,,sferrormgr.getmemvars,,0,
>Hi Doug,
>
>I'm getting 'Unknown member databases' using this script:
>
>lparameters tiCustomerID
>
>local lnSelect, lcSelect, lcPhones
>lnSelect = select()
>lcSelect = 'select Phone, Type from Phones ' + ;
> 'where CID=' + transform(m.tiCustomerID) + ;
>" AND Type LIKE 'E-mail%' and Phones.Phone <> space(60)"
>loDatabase = SQApplication.Databases.GetMainDatabase()
>loDatabase.ExecuteSQLStatement(m.lcSelect, , 'TempCursor')
>lcPhones = ''
>scan
> lcPhones = m.lcPhones + iif(empty(m.lcPhones), '', chr(13)) + ;
> trim(Phone) + ' (' + trim(Type) + ')'
>endscan
>select (m.lnSelect)
>return m.lcPhones>
>I also tried to use a script for addresses (I have People table and Address table is related (LEFT JOIN from People to Address), the relation is defined)
>
>
>lparameters tcAddress1, tcAddress2, tcCity, tcZip, tcState
>*ADDRS.Address1,ADDRS.Address2,ADDRS.CITY,ADDRS.ZIP,ADDRS.STATE
>local lcAddress
>if isnull(m.tcAddress1)
> lcAddress = ""
>else
>lcAddress = alltrim(m.tcAddress1)
>if not empty(m.tcAddress2)
> lcAddress = m.lcAddress + chr(13) + m.tcAddress2
>endif
>if not empty(m.tcCity)
> lcAddress = m.lcAddress + chr(13) + m.tcCity
> if not empty(m.tcState)
> lcAddress = m.lcAddress + ", " + m.tcState + " " + m.tcZip
> endif
>endif
>endif
>
>return m.lcAddress
>
>
>And I'm getting
>
>
>Error #:1806
>Message:SQL: Column 'ADDRESS1' is not found.
>Method:master..selectfromsingletable
>Datetime: 5/7/2008 8:13:09 PM
>User: ADMIN
>
>TCSTARTUPPARAMETER1 Local C "ini=N:\stonefield from akiva\Stonefield Query
>SDK\Data\" startup
>LCPARAMETERS Local C "ÿini=N:\stonefield from akiva\Stonefield Quer
>LUVALUE Local C "ini=N:\stonefield from akiva\Stonefield Query
>TCSTARTUPPARAMETER1
>Local tcstartupparameter1
>TCSTARTUPPARAMETER2
>Local tcstartupparameter2
>TCSTARTUPPARAMETER3
>Local tcstartupparameter3
>TCSTARTUPPARAMETER4
>Local tcstartupparameter4
>TCSTARTUPPARAMETER5
>Local tcstartupparameter5
>TCSTARTUPPARAMETER6
>Local tcstartupparameter6
>TCSTARTUPPARAMETER7
>Local tcstartupparameter7
>TCSTARTUPPARAMETER8
>Local tcstartupparameter8
>TCSTARTUPPARAMETER9
>Local tcstartupparameter9
>TCSTARTUPPARAMETER10
>Local tcstartupparameter10
>TCSTARTUPPARAMETER11
>Local tcstartupparameter11
>TCSTARTUPPARAMETER12
>Local tcstartupparameter12
>TCSTARTUPPARAMETER13
>Local tcstartupparameter13
>TCSTARTUPPARAMETER14
>Local tcstartupparameter14
>TCSTARTUPPARAMETER15
>Local tcstartupparameter15
>LCRESOURCETABLE Local C "c:\PROGRAM FILES\STONEFIELD QUERY SDK\Data\SQ
>Resource.dbf" sysmain
>LCSETTINGS Local C "N:\stonefield from akiva\Stonefield Query SDK
>TLNEWREPORT Local L .F. showwizard
>TCREPTYPE Local L .F. showwizard
>LCREPTYPE Local C "Q" showwizard
>LOWIZARD Local O EMPTY showwizard
>LCMODE Local C "Edit" showwizard
>LLOK Local L .F. runpreviewreport
>LOREPORTENGINE Local O SFQREPORTENGINE runpreviewreport
>TOREPORT Local O SFREPORTQUICK runreport
>TOOUTPUT Local L .F. runreport
>LLRETURN Local L .F. runreport
>TOREPORT Local O SFREPORTQUICK runreport
>TOOUTPUT Local L .F. runreport
>LLOK Local L .T. runreport
>LCDISPLAY Local C "Descriptor equals ACTIV and Primary is Yes" runreport
>LCFILTER Local C "ENTITIES.DESCRIP='ACTIV' and PEOPLE.PRIMARY" runreport
>LLHANDLENODISPLAY Local L .F. runreport
>LLQUIET Local L .F. runreport
>LOREPORTENGINE Priv O SFQREPORTENGINE runreport
>LODATAENGINE Priv O SFQDATAENGINE runreport
>LOREPORT Priv O SFREPORTQUICK runreport
>TOREPORT Local O SFREPORTQUICK createcursor
>TLSETUPDATAENGINE Local L .F. createcursor
>LLOK Local L .T. createcursor
>LLQUIET Local L .T. createcursor
>TOREPORT Local O SFREPORTQUICK createcursor
>LCSCRIPT Local C "DataEngine.BeforeResultSetRetrieved" createcursor
>LLSCRIPT Local L .F. createcursor
>LCSELECT Local L .F. createcursor
>LNSELECT Local L .F. createcursor
>LLRETURN Local L .T. createcursor
>LLRESOLVEFILTER Local L .T. createcursor
>TOREPORT Local O SFREPORTQUICK createcursor
>LCSTDFILTER Local C "" createcursor
>LLOK Local L .T. createcursor
>LCSELECT Local C "select dis..." 318 bytes createcursor
>LLRESOLVEFILTER Local L .F. createcursor
>LNI Local L .F. createcursor
>LOCONDITION Local L .F. createcursor
>LCFILTER Priv C "ENTITIES.DESCRIP='ACTIV' and PEOPLE.PRIMARY" createcursor
>TCSELECT Local C "select dis..." 318 bytes executesqlselect
>TCCURSOR Local C "_2D417C4GB" executesqlselect
>LLRETURN Local L .T. executesqlselect
>LCCURSOR Local C "_2D417C4GB" executesqlselect
>LCLOGMESSAGE Local C "SFDataEngi..." 384 bytes executesqlselect
>LNRECORDS Local L .F. executesqlselect
>LCMESSAGE Local L .F. executesqlselect
>TCSELECT Local C "select dis..." 318 bytes performquery
>TCCURSOR Local C "_2D417C4GB" performquery
>TLRECURSIVE Local L .F. performquery
>LCSELECT Local C "select dis..." 318 bytes performquery
>LODATABASE Local O SFQDATABASE performquery
>LNPOS Local N 0 performquery
>LODATASOURCE Local L .F. performquery
>LNI Local L .F. performquery
>LCFIELD Local L .F. performquery
>LCSUBSELECT Local L .F. performquery
>LNPOS2 Local L .F. performquery
>LCALIAS Local L .F. performquery
>LLRETURN Local L .F. performquery
>LACURSORS Local A performquery
>( 1, 1) C "ENTITIES"
>( 1, 2) N 20 ( 20.00000000)
>( 2, 1) C "PEOPLE"
>( 2, 2) N 19 ( 19.00000000)
>( 3, 1) C "_2D417BAJM"
>( 3, 2) N 18 ( 18.00000000)
>( 4, 1) C "_2D417BAI3"
>( 4, 2) N 17 ( 17.00000000)
>( 5, 1) C "_2D417B9TE"
>( 5, 2) N 16 ( 16.00000000)
>( 6, 1) C "SFREPORTS"
>( 6, 2) N 12 ( 12.00000000)
>( 7, 1) C "_2D417B31Y"
>( 7, 2) N 5 ( 5.00000000)
>( 8, 1) C "_2D417B2N6"
>( 8, 2) N 15 ( 15.00000000)
>( 9, 1) C "_2D417B2N7"
>( 9, 2) N 14 ( 14.00000000)
>( 10, 1) C "_2D417B2N8"
>( 10, 2) N 13 ( 13.00000000)
>( 11, 1) C "REPMETA"
>( 11, 2) N 4 ( 4.00000000)
>( 12, 1) C "LOGINS"
>( 12, 2) N 11 ( 11.00000000)
>( 13, 1) C "_USERROLES"
>( 13, 2) N 10 ( 10.00000000)
>( 14, 1) C "_ROLES"
>( 14, 2) N 9 ( 9.00000000)
>( 15, 1) C "_SECURITY"
>( 15, 2) N 8 ( 8.00000000)
>( 16, 1) C "_USERS"
>( 16, 2) N 7 ( 7.00000000)
>( 17, 1) C "SFWIZARDS"
>( 17, 2) N 6 ( 6.00000000)
>( 18, 1) C "_2D417B27F"
>( 18, 2) N 3 ( 3.00000000)
>( 19, 1) C "SFSCRIPT"
>( 19, 2) N 2 ( 2.00000000)
>( 20, 1) C "_2D417B1X7"
>( 20, 2) N 1 ( 1.00000000)
>LNCURSORS Local N 20 performquery
>LCDATABASE Local L .F. performquery
>LLWASCONNECTED Local L .F. performquery
>LLCONNECTED Local L .F. performquery
>LCMESSAGE1 Local L .F. performquery
>LCMESSAGE2 Local L .F. performquery
>LCCURSOR Local L .F. performquery
>LCMESSAGE Local L .F. performquery
>TCSELECT Local C "select dis..." 318 bytes performquery
>TCCURSOR Local C "_2D417C4GB" performquery
>LCSELECTFIELDS Local C "PEOPLE.FNAME,PEOPLE.LNAME,GetFormattedAddress
>(ADDRS.Address1,ADDRS.Address2,ADDRS.CITY,ADDR S.ZIP,ADDRS.STATE) as FullAddress" performquery
>LCSQLCLAUSE Local C "distinct" performquery
>LAQUERYTABLES Local A performquery
>( 1) L .F.
>LCALIAS Local C "ENTITIES" performquery
>LCSELECT Local C "select dis..." 318 bytes performquery
>LATABLES Local A performquery
>( 1, 1) C "ADDRS"
>( 1, 2) C "GetFormattedAddress(ADDRS.Address1,ADDRS.Addr
>ess2,ADDRS.CITY,ADDRS.ZIP,ADDRS.STATE) as Full
>Address,ADDRS.CID" ( 1, 3) C ""
>( 1, 4) N 0 ( 0.00000000)
>( 1, 5) N 0 ( 0.00000000)
>( 1, 6) C ""
>( 1, 7) N 0 ( 0.00000000)
>( 1, 8) N 0 ( 0.00000000)
>( 1, 9) L .F.
>( 1, 10) L .F.
>( 2, 1) C "PEOPLE"
>( 2, 2) C "PEOPLE.FNAME,PEOPLE.LNAME,PEOPLE.CID,PEOPLE.M
>IDNO,PEOPLE.PRIMARY" ( 2, 3) C "PEOPLE.PRIMARY"
>( 2, 4) N 0 ( 0.00000000)
>( 2, 5) N 0 ( 0.00000000)
>( 2, 6) C ""
>( 2, 7) N 0 ( 0.00000000)
>( 2, 8) N 0 ( 0.00000000)
>( 2, 9) L .F.
>( 2, 10) L .F.
>( 3, 1) C "ENTITIES"
>( 3, 2) C "ENTITIES.MIDNO,ENTITIES.DESCRIP"
>( 3, 3) C "ENTITIES.DESCRIP='ACTIV'"
>( 3, 4) N 0 ( 0.00000000)
>( 3, 5) N 0 ( 0.00000000)
>( 3, 6) C ""
>( 3, 7) N 0 ( 0.00000000)
>( 3, 8) N 0 ( 0.00000000)
>( 3, 9) L .F.
>( 3, 10) L .F.
>LNCONDITIONS Local N 2 ( 2.00000000) performquery
>LNI Local N 4 performquery
>LOCONDITION Local O SFQCONDITION performquery
>LCFIELD Local C "PEOPLE.PRIMARY" performquery
>LOFIELD Local O SFRFIELD performquery
>LNJ Local N 0 performquery
>LLRETURN Local L .T. performquery
>LNTABLES Local N 3 performquery
>LOJOIN Local O SFJOINCOLLECTION performquery
>LNJOINMAX Local N 1 performquery
>LNJOIN Local N 1 performquery
>LNJOINS Local N 1 performquery
>LOJOINOBJECT Local O SFJOIN performquery
>LOBESTJOIN Local O SFJOIN performquery
>LCEXPR Local C "PEOPLE.PRIMARY" performquery
>LCTARGET Local C "PEOPLE" performquery
>LALINES Local A performquery
>( 1) L .F.
>LNLINES Local L .F. performquery
>LNK Local L .F. performquery
>LCJOINEXPR Local L .F. performquery
>LNPOS Local N 2 performquery
>LASELECTTABLES Local A performquery
>( 1) L .F.
>LNSELECTTABLES Local L .F. performquery
>LCSTDFILTER Local C "" performquery
>LAQUERY Local A performquery
>( 1, 1) C ""
>( 1, 2) C "Descriptor equals ACTIV"
>( 1, 3) C "ENTITIES.DESCRIP"
>( 1, 4) C "C"
>( 1, 5) C "ENTITIES.DESCRIP='ACTIV'"
>( 1, 6) C "{FIELD}={PAD}{VALUE}"
>( 1, 7) C "ENTITIES.DESCRIP='ACTIV'"
>( 1, 8) N 5 ( 5.00000000)
>( 1, 9) N 0 ( 0.00000000)
>( 1, 10) C "'ACTIV'"
>( 1, 11) L .T.
>( 1, 12) C ""
>( 1, 13) C ""
>( 1, 14) C "Descriptor"
>( 1, 15) C "ENTITIES.DESCRIP"
>( 1, 16) C "equals"
>( 1, 17) L .F.
>( 1, 18) C "sfoperatorequals"
>( 1, 19) C "{FIELD}={PAD}{VALUE}"
>( 1, 20) C "Value"
>( 1, 21) L .F.
>( 1, 22) L .T.
>( 1, 23) C ""
>( 1, 24) C ""
>( 1, 25) L .F.
>( 2, 1) C " and "
>( 2, 2) C "Primary is Yes"
>( 2, 3) C "PEOPLE.PRIMARY"
>( 2, 4) C "L"
>( 2, 5) C "PEOPLE.PRIMARY"
>( 2, 6) C "{FIELD}"
>( 2, 7) C "PEOPLE.PRIMARY"
>( 2, 8) N 1 ( 1.00000000)
>( 2, 9) N 0 ( 0.00000000)
>( 2, 10) C ""
>( 2, 11) L .F.
>( 2, 12) C "and"
>( 2, 13) C ""
>( 2, 14) C "Primary"
>( 2, 15) C "PEOPLE.PRIMARY"
>( 2, 16) C "is Yes"
>( 2, 17) L .F.
>( 2, 18) C "sfoperatorisyes"
>( 2, 19) C "{FIELD}{TRUE}"
>( 2, 20) C "Value"
>( 2, 21) L .F.
>( 2, 22) L .T.
>( 2, 23) C ""
>( 2, 24) C "Y"
>( 2, 25) L .F.
>LLHAVEOR Local L .F. performquery
>LLCALCULATED Local L .F. performquery
>LCFALIAS Local C "PEOPLE" performquery
>LNCONDITION Local N 2 ( 2.00000000) performquery
>LCNALIAS Local L .F. performquery
>LCOALIAS Local L .F. performquery
>LLPOSTWHERE Local L .F. performquery
>LOFIELD2 Local L performquery
>LOFIELD3 Local L performquery
>LLCONVERT Local L .T. performquery
>LCLOOKUPFIELD Local L .F. performquery
>LNCOL Local N 3 performquery
>LCOLDEXPR Local L .F. performquery
>LLEXPRESSION Local L .F. performquery
>LLADDCONNECTION Local L .F. performquery
>LCUFIELD Local C "PEOPLE.PRIMARY" performquery
>LCFIELDS Local C "PEOPLE.FNAME,PEOPLE.LNAME,PEOPLE.CID,PEOPLE.M
>IDNO" performquery LCSFIELDS Local C ",PEOPLE.FNAME,PEOPLE.LNAME,PEOPLE.CID,PEOPLE.
>MIDNO," performquery LAFIELDS Local A performquery
>( 1) L .F.
>LNFIELDS Local L .F. performquery
>LCJOIN Local L .F. performquery
>LODATABASE Local O SFQDATABASE performquery
>LCMAINDATABASE Local C "master" performquery
>LODATASOURCE Local O SFQDATASOURCEVFP performquery
>LLONESELECT Local L .T. performquery
>LOCURSOR Local O SFRCURSOR performquery
>LODATASOURCE1 Local L .F. performquery
>LODATASOURCE2 Local L .F. performquery
>LCDATABASE Local C "master" performquery
>LCLOGMESSAGE Local C "SFDataEngine.PerformQuery
>Performing single
>join" performquery
>LCLASTALIAS Local L .F. performquery
>LLSTRIP Local L .F. performquery
>LCORDERBY Local L .F. performquery
>LCDATE Local L .F. performquery
>LCWHERE Local L .F. performquery
>LAFIELDLIST Local A performquery
>( 1) L .F.
>LCNEWSELECT Local L .F. performquery
>LLUPDATE Local L .F. performquery
>LCAFIELD Local L .F. performquery
>LCLOCALALIAS Local L .F. performquery
>LCCHAR Local L .F. performquery
>LCCURSOR Local L .F. performquery
>LCLEFTDELIMITER Local L .F. performquery
>LCANSI Local L .F. performquery
>LCMESSAGE Local L .F. performquery
>LCCAPTION Local L .F. performquery
>LCTYPE Local L .F. performquery
>LCSTABLE Local L .F. performquery
>LCORIGINAL Local L .F. performquery
>LOEXCEPTION Local L .F. performquery
>LCSHOWPLAN Local L .F. performquery
>TCSELECT Local C "select dis..." 318 bytes selectfromanytables
>TCCURSOR Local C "_2D417C4GB" selectfromanytables
>TCALIAS Local C "ADDRS" selectfromanytables
>LCSELECT Local C "select dis..." 318 bytes selectfromanytables
>LATABLES Local A selectfromanytables
>( 1, 1) C "ADDRS"
>( 1, 2) C "ADDRS"
>( 2, 1) C "PEOPLE"
>( 2, 2) C "PEOPLE"
>( 3, 1) C "ENTITIES"
>( 3, 2) C "ENTITIES"
>LNTABLES Local N 3 selectfromanytables
>LNI Local N 4 selectfromanytables
>LCALIAS Local C "ENTITIES" selectfromanytables
>LOCURSOR Local O SFRCURSOR selectfromanytables
>LCDATABASE Local C "master" selectfromanytables
>LODATABASE Local O SFQDATABASE selectfromanytables
>LCORIGINAL Local C "" selectfromanytables
>LLRETURN Local L .F. selectfromanytables
>LCMESSAGE Local L .F. selectfromanytables
>TCSELECT Local C "select dis..." 318 bytes selectfromanytables
>TCCURSOR Local C "_2D417C4GB" selectfromanytables
>LLRETURN Local L .F. selectfromanytables
>TCSELECT Local C "select dis..." 318 bytes selectfromanytables
>TCCURSOR Local C "_2D417C4GB" selectfromanytables
>LLRETURN Local L .F. selectfromanytables
>TCSELECT Local C "select dis..." 318 bytes selectfromanytables
>TCCURSOR Local C "_2D417C4GB" selectfromanytables
>LLRETURN Local L .F. selectfromanytables
>TCSELECT Local C "select dis..." 318 bytes selectfromanytables
>TCCURSOR Local C "_2D417C4GB" selectfromanytables
>TCSELECT Local C "select dis..." 318 bytes selectfromsingletable
>TCALIAS Local C "" selectfromsingletable
>TCCURSOR Local C "_2D417C4GB" selectfromsingletable
>LLRETURN Local L .F. selectfromsingletable
>TCSELECT Local C "select dis..." 318 bytes selectfromsingletable
>TCALIAS Local C "" selectfromsingletable
>TCCURSOR Local C "_2D417C4GB" selectfromsingletable
>LCSELECT Local C "select dis..." 318 bytes selectfromsingletable
>LNTABLES Local N 3 selectfromsingletable
>LATABLES Local A selectfromsingletable
>( 1, 1) C "ADDRS"
>( 1, 2) C "ADDRS"
>( 2, 1) C "PEOPLE"
>( 2, 2) C "PEOPLE"
>( 3, 1) C "ENTITIES"
>( 3, 2) C "ENTITIES"
>LNI Local N 4 selectfromsingletable
>LCTABLE Local C "master!ENTITIES" selectfromsingletable
>LCDATABASE Local C "master" selectfromsingletable
>LCALIAS Local C "ENTITIES" selectfromsingletable
>LNPOS Local N 0 selectfromsingletable
>LOCURSOR Local O SFRCURSOR selectfromsingletable
>LOQUERY Local O SFQQUERYENGINE selectfromsingletable
>LCSHOWPLAN Local L .F. selectfromsingletable
>LLRETURN Local L .F. selectfromsingletable
>LCSOURCE Local C "SELECT __Parameters
>LCFILENAME Local C "C:\Documents and Settings\center\My Documents
>\error.txt" click TCFILENAME Local C "C:\Documents and Settings\center\My Documents
>LCLOG Local C "c:\PROGRAM FILES\STONEFIELD QUERY SDK\Data\ER
>RORLOG.DBF" createlogfile
>LCFILE Local C "C:\DOCUME~1\CENTER\LOCALS~1\TEMP\_2D417CGVS.T
>XT" getmemvars
>
>
>Call stack:
>1,c:\program files\stonefield query sdk\sfquery.exe,startup,,0,
>2,sysmain.fxp,sysmain,,0,
>3,,sfqapplication.readevents,,0,
>4,,sfapplication.readevents,,0,
>5,,sfqreportsmain.cmdedit.click,,0,
>6,,sfqreportsmain.editreport,,0,
>7,,sfqreportsmain.showwizard,,0,
>8,,sfrwizardquick.cmdpreview.click,,0,
>9,,sfrwizardquick.runpreviewreport,,0,
>10,,sfqreportengine.runreport,,0,
>11,,sfreportengine.runreport,,0,
>12,,sfqreportengine.createcursor,,0,
>13,,sfqdataengine.createcursor,,0,
>14,,sfdataengine.createcursor,,0,
>15,,sfqdataengine.executesqlselect,,0,
>16,,sfqdataengine.performquery,,0,
>17,,sfdataengine.performquery,,0,
>18,,sfqdataengine.selectfromanytables,,0,
>19,,master.selectfromanytables,,0,
>20,,sfrdatabase.selectfromanytables,,0,
>21,,master.selectfromanytables,,0,
>22,,sfrdatasourcevfp.selectfromanytables,,0,
>23,,master.selectfromsingletable,,0,
>24,,sfrdatasourcevfp.selectfromsingletable,,0,
>25,,master.error,,0,
>26,,sfcustom.error,,0,
>27,,sfqerrormgr.errorhandler,,0,
>28,,sfqerrormgr.displayerror,,0,
>29,,sferrormgr.displayerror,,0,
>30,,sferrormessagedialogemail.cmdsave.click,,0,
>31,,sferrormessagedialogemail.createlogfile,,0,
>32,,sfqerrormgr.logerror,,0,
>33,,sfqerrormgr.getmemvars,,0,
>34,,sferrormgr.getmemvars,,0,
>
>Object: OAPP Priv O SFQAPPLICATION
>
>Properties:
>ADATASOURCES A
>( 1) L .F.
>AFORMS A
>( 1, 1) L
>( 1, 2) L
>( 1, 3) L
>( 1, 4) L
>( 1, 5) L
>( 1, 6) L
>( 1, 7) L
>( 1, 8) L
>CAPPDATADIR C "c:\PROGRAM FILES\STONEFIELD QUERY
>SDK\Data\"
>CAPPDIR C "c:\PROGRAM FILES\STONEFIELD QUERY
>SDK\"
>CAPPNAME C "Stonefield Query"
>CAPPTIMERCLASS C ""
>CAPPTI...IBRARY C ""
>CAPPTO...RCLASS C ""
>CAPPTO...IBRARY C ""
>CCOPYRIGHT C "© 1996-2007 Stonefield Software In
>c."
>CDATADIR C "N:\stonefield from akiva\Stonefiel
>d Query SDK\Data\"
>CDATAE...ECLASS C "SFQDataEngine"
>CDATAE...IBRARY C "SFQFramework.vcx"
>CDATAG...IPTION C "Data group"
>CDATAKEY C "Software\Stonefield Software Inc.\
>Stonefield Query\Data"
>CDATAS...IPTION C "database"
>CDATAS...PLURAL C "databases"
>CDATEFORMAT C "SHORT"
>CDEFAU...NGUAGE C "English"
>CDESKTOPIMAGE C "SFQueryLarge.gif"
>CERRORMESSAGE C ""
>CFORME...TRYKEY C ""
>CHELPFILE C "C:\PROGRAM FILES\STONEFIELD QUERY
>SDK\SFQUERY.CHM"
>CICOFILE C "SFQuery.ico"
>CINIFILE C "N:\stonefield from akiva\Stonefiel
>d Query SDK\Data\SFQuery.ini"
>CINVAL...ESSAGE C ""
>CINVAL...ESSAGE C ""
>sdk\source\sfqframework.vcx"
>CLICENSEFILE C "c:\PROGRAM FILES\STONEFIELD QUERY
>SDK\Data\SFQuery.lic"
>CLICEN...RCLASS C "SFQLicenseMgrActivation"
>CLICEN...IBRARY C "SFQLicenseMgr.vcx"
>CLOGINFORMCLASS C "SFQLoginForm"
>CLOGOAPPNAME C ""
>CLOGOCLASS C "SFQLogo"
>CLOGOIMAGE C "SFQuerySmall.gif"
>CLOGOLIBRARY C "SFQFrameworkUI.vcx"
>CMAINDATABASE C ""
>CMENU C ""
>CMENUCLASS C "SFQueryMenu"
>CMENULIBRARY C "SFQueryMenu.vcx"
>CMETADATADIR C ""
>COEMCOMPANY C "Stonefield Software Inc."
>COPTIONSINIFILE C "N:\stonefield from akiva\Stonefiel
>d Query SDK\Data\Data.ini"
>COPTIONSKEY C "Software\Stonefield Software Inc.\
>Stonefield Query\Options"
>COPTIONSKEYINI C "Options"
>CPRODUCTCODE C "SQD"
>CQUERYCLASS C "SFQQueryEngine"
>CQUERYLIBRARY C "SFQFramework.vcx"
>CREGIS...IONKEY C "Software\Stonefield Software Inc.\
>Stonefield Query\Registration"
>CREGISTRYKEY C "Software\Stonefield Software Inc.\
>Stonefield Query"
>CREPOR...ECLASS C "SFQReportEngine"
>CREPOR...IBRARY C "SFQFramework.vcx"
>CSALESEMAIL C "sales@stonefieldquery.com"
>CSALESPHONE C "800-563-1119"
>CSENDEREMAIL C "info@centerforreturn.org"
>CSENDERNAME C "center"
>CSETUP...GCLASS C "SFQSetupDialog"
>CSETUP...IBRARY C "SFQFrameworkUI.vcx"
>CSHORTAPPNAME C "Stonefield Query"
>CSHUTDOWNFILE C "SHUTDOWN.TXT"
>CSUPPORTEMAIL C "support@stonefieldquery.com"
>CSUPPORTFAX C "306-586-5080"
>CTARGETAPPDIR C ""
>CTARGE...PROMPT C ""
>CTARGETAPPNAME C ""
>CTEMPLATENAME C "Standard"
>CTOOLSMENU C "PROGTOOL.MPR"
>CUPDATESFILE C ""
>CUPDAT...SSWORD C ""
>CUPDATESURL C ""
>CUPDAT...ERNAME C ""
>CURL C "www.stonefieldquery.com"
>CVERSION C "3.10.2761"
>DEXPIRYDATE D 1/31/2006
>LADDALIAS L .F.
>LALLOW...SELECT L .F.
>LALLOW...OURCES L .F.
>LBETA L .F.
>LCOMMODE L .F.
>LDEMO L .F.
>LDEVELOPER L .F.
>LDSNLE...ECTION L .T.
>LEXIT L .F.
>LINCLU...NWHERE L .F.
>LMANAG...ABASES L .F.
>LMULTI...EQUERY L .F.
>LNEEDT...APPDIR L .F.
>LNEEDU...TARTUP L .T.
>LNEWMA...ERSION L .T.
>LNEWVERSION L .T.
>LNOTIF...CHANGE L .F.
>LOPEND...TARTUP L .F.
>LQUIET L .F.
>LRELOA...SOURCE L .F.
>LSNAPSHOT L .T.
>LSUPPO...GUAGES L .F.
>LUPDATES L .T.
>LUSEFO...UTMENU L .F.
>LUSEMAPI L .F.
>LUSEREGISTRY L .F.
>LVFPSCREEN L .T.
>NREPOR...HELPID N 0 ( 0.00000000)
>NREQUIREDCOLOR N 65535 ( 65535.00000000)
>NRETURNCODE N -1 ( -1.00000000)
>NSETUP...XSTEPS N 1 ( 1.00000000)
>NWAITINTERVAL N 180 ( 180.00000000)
>OAPPLIC O SQAPPLICATION
>OAPPTIMER 0
>OCONFIG O SFQCONFIGMGR
>OCURRENTFORM 0
>OCURRENTWIZARD O SFRWIZARDQUICK
>ODATA O SFQDATAENGINE
>OPARAMETERS O SFCOLLECTIONONECLASS
>OREPORT 0
>OREPORTENGINE O SFQREPORTENGINE
>OSCRIPTMGR O SFQSCRIPTMGR
>OTOOLBAR 0
>OWIZARDFORM O SFQREPORTSMAIN
>..."
>
>Object: LOWIZARD Local O EMPTY
>
>Properties:
>DESCRIPTION C "This wizard allows you to create a
>quick report, which is a "row and
>column" style report."
>HELPID N 1 ( 1.00000000)
>IMAGE C "sfreports.bmp"
>LIBRARY C "SFREPORTSUI.VCX"
>TYPE C "Q"
>
>Object: LOREPORTENGINE Local O SFQREPORTENGINE
>
>Properties:
>CCOLLE...NCLASS C "SFCollection"
>CCOLLE...IBRARY C "SFCtrls.vcx"
>CDATAE...ECLASS C ""
>CDATAE...IBRARY C ""
>CERRORMESSAGE C ""
>CFIELD...NCLASS C "SFQFieldCollection"
>CFIELD...IBRARY C "SFQFramework.vcx"
>sdk\source\sfqframework.vcx"
>CQUERYCLASS C "SFQQueryEngine"
>CQUERYLIBRARY C "SFQFramework.vcx"
>CREPORTSTABLE C "N:\stonefield from akiva\Stonefiel
>d Query SDK\Data\Reports.dbf"
>CREPOR...BACKUP C "N:\stonefield from akiva\Stonefiel
>d Query SDK\Data\Reports_Recover.db
>f"
>CWIZARDSTABLE C "SFRWizard.dbf"
>LBACKU...STABLE L .T.
>LNOTIF...CHANGE L .F.
>LREPOR...ITABLE L .T.
>LSELEC...APTION L .F.
>LUSEDI...ESSARY L .T.
>LUSEFO...UTMENU L .F.
>NREPORTNAMESIZE N 60 ( 60.00000000)
>ODATAENGINE O SFQDATAENGINE
>OLOGGER O SFLOGGER
>OUSER O SFQUSER
>OXML O SFXML
>..."
>
>Object: TOREPORT Local O SFREPORTQUICK
>
>Properties:
>AREPORTGROUPS A
>( 1) L .F.
>CAFTERDATA C ""
>CAFTERRUN C ""
>CBEFOREDATA C ""
>CCHARTCURSOR C ""
>CCOMMENTS C ""
>CCREATEDBY C "ADMIN"
>CCURRESC C ""
>CCURRESCAPE C ""
>CCURSOR C "_2D417BETW"
>CDATAGROUP C "All"
>CDISPLAY C ""
>CEMAILBODY C ""
>CEMAILCLASS C "SFROutputEmail"
>CEMAILLIBRARY C "SFReports.vcx"
>CEMAILSUBJECT C ""
>CERRORMESSAGE C ""
>CFILTER C ""
>CFOLDERS C "#18#"
>CFONTNAME C "Arial"
>CFOOTER C ""
>CFRXXML C ""
>CHEADER C "All Active"
>"
>CMODIFIEDBY C "ADMIN"
>CONSELECT C ""
>COUTPUT C "PREVIEW"
>COUTPUTCLASS C ""
>COUTPUTFILENAME C ""
>COUTPUTFILETYPE C ""
>COUTPUTLIBRARY C ""
>COUTPUTUSER C ""
>CRECIPIENTS C ""
>CREPOR...LDNAME C ""
>CREPORTALIGN C ""
>CREPORTCOLUMN C ""
>CREPOR...MNEVAL C ""
>CREPOR...LDNAME C ""
>CREPORTDATATYPE C ""
>CREPORTFIELD C ""
>CREPOR...FORMAT C ""
>CREPOR...UTMASK C ""
>CREPOR...LDTYPE C ""
>CREPORTFILENAME C ""
>CREPORTFONTNAME C ""
>CREPORTNAME C "People - Address; Phone; Email"
>CREPOR...ECLASS C "SFRQuickReportOptionsPage"
>CREPOR...IBRARY C "SFReportsUI.vcx"
>CREPORTPICTURE C ""
>CREPORTPROP C ""
>CREPORTTOTAL C ""
>CREPORTUNIQUEID C ""
>CREPTYPE C "Q"
>CRUNBY C "ADMIN"
>CSENDEREMAIL C "info@centerforreturn.org"
>CSENDERNAME C "center"
>CSNAPSHOT Q 0h4749463839...
>CSORTDISPLAY C "Full Name"
>CSORTEXPR C "PEOPLE.[Full Name]"
>CSQLCLAUSE C ""
>CSQLSELECT C ""
>CSTDFILTER C ""
>CTEMPFRXNAME C ""
>DCREATEDAT T 4/8/2008 10:21:51 PM
>DMODIFIEDAT T 5/7/2008 8:12:11 PM
>DREPORTDATE D 5/7/2008
>DRUNAT T 5/7/2008 7:58:55 PM
>LADJUS...CATION L .F.
>LADVANCE L .F.
>LALLOW...ICATES L .F.
>LALLOWFILTER L .T.
>LALLOW...REVIEW L .T.
>LALLOWSORT L .T.
>LDISPLAYFILTER L .T.
>LERASEREPORT L .T.
>LHAVEG...FIELDS L .T.
>LHAVEL...FFECTS L .F.
>LLANDSCAPE L .F.
>LNOTIF...CHANGE L .F.
>LPRINTING L .F.
>LQUIET L .T.
>LREPOR...UTOFIT L .F.
>LREPOR...PCOUNT L .F.
>LREPORTTOTALS L .F.
>LSNAPSHOT L .T.
>LSUMMARY L .F.
>LSUMMARYBAND L .T.
>LSUMMA...MENTED L .F.
>LSUPPORTAUTOFIT L .T.
>LUSEFO...UTMENU L .F.
>LUSEMAPI L .F.
>LUSEOLDENGINE L .F.
>LUSEPRINTER L .F.
>LUSEPR...PROMPT L .F.
>NENDPAGE N 9999 ( 9999.00000000)
>NFONTSIZE N 10 ( 10.00000000)
>NFONTSTYLE N 0 ( 0.00000000)
>NID N 22 ( 22.00000000)
>NLEFTGROUPTOTAL N 0 ( 0.00000000)
>NMARGIN N 0 ( 0.00000000)
>NMAXCOLHEIGHT N 0 ( 0.00000000)
>NMINPAPERWIDTH N 0 ( 0.00000000)
>NNEXTHPOS N 0 ( 0.00000000)
>NNUMBEROFGROUPS N 0 ( 0.00000000)
>NORIENTATION N 0 ( 0.00000000)
>NPAPERWIDTH N 0 ( 0.00000000)
>NREPOR...KCOLOR N 0 ( 0.00000000)
>NREPOR...CIMALS N 0 ( 0.00000000)
>NREPOR...ECOLOR N 0 ( 0.00000000)
>NREPOR...SITION N 0 ( 0.00000000)
>NREPOR...DWIDTH N 0 ( 0.00000000)
>NREPOR...THBOLD N 0 ( 0.00000000)
>NREPORTFONTSIZE N 0 ( 0.00000000)
>NREPORTGROUP N 0 ( 0.00000000)
>NREPORTHPOS N 0 ( 0.00000000)
>NREPORTMINWIDTH N 0 ( 0.00000000)
>NREPORTWIDTH N 0 ( 0.00000000)
>NSTARTPAGE N 1 ( 1.00000000)
>NSUMMA...AXHPOS N 0 ( 0.00000000)
>NTEMPLATE N 8 ( 8.00000000)
>OCOLUM...MPLATE 0
>OFIELD...ECTION O SFQFIELDCOLLECTION
>OFIELDTEMPLATE 0
>OGROUP...BJECTS 0
>OGROUP...MPLATE 0
>OGROUP...MPLATE 0
>OGROUP...MPLATE 0
>OGROUP...BJECTS 0
>OGROUP...MPLATE 0
>OGROUP...MPLATE 0
>OGROUP...MPLATE 0
>OMEMBERDATA O SFREPORTMEMBERDATAXML
>OQUERY O SFQQUERYENGINE
>OSFGDI O SFGDIMEASURESTRING
>OSORTCOLLECTION O SFRSORTCOLLECTION
>OSUMMA...MPLATE 0
>OVIEWER 0
>..."
>
>Object: LODATAENGINE Priv O SFQDATAENGINE
>
>Properties:
>ADATAGROUPS A
>( 1, 1) C "Donations Info
>"
>( 1, 2) N 2186 ( 2186.00000000)
>( 2, 1) C "Members (Bio Info)
>"
>( 2, 2) N 2185 ( 2185.00000000)
>( 3, 1) C "Phones & Emails
>"
>( 3, 2) N 3452 ( 3452.00000000)
>( 4, 1) C "Pledges
>"
>( 4, 2) N 3473 ( 3473.00000000)
>( 5, 1) C "All"
>( 5, 2) N 0 ( 0.00000000)
>ADATASOURCES A
>( 1) C ""
>CCURSOR C "_2D417C4GB"
>CCURSOR2 C "_2D417C4GC"
>CCURSO...NCLASS C "SFQCursorMetaData"
>CCURSO...IBRARY C "SFQFramework.vcx"
>CDATAB...NCLASS C "SFRDatabaseCollection"
>CDATAB...IBRARY C "SFReports.vcx"
>CDATAGROUP C "All"
>CDATAG...CURSOR C "_2D417B31Y"
>CDATASOURCE C "master"
>CERRORMESSAGE C ""
>CFIELD...NCLASS C "SFQFieldMetaData"
>CFIELD...IBRARY C "SFQFramework.vcx"
>CFILTER C ""
>sdk\source\sfqframework.vcx"
>CMETADATAALIAS C "REPMETA"
>CMETADATAFILE C "REPMETA"
>CMETADATAFILTER C ""
>CMETADATATABLE C "N:\STONEFIELD FROM AKIVA\STONEFIEL
>CNAMEDELIMITERS C "[]"
>CORIGI...SOURCE C ""
>CRELAT...NCLASS C "SFQRelationMetaData"
>CRELAT...IBRARY C "SFQFramework.vcx"
>CSORTDISPLAY C "Full Name"
>CSORTEXPR C "PEOPLE.[Full Name]"
>CSOURC...LDNAME C "SOURCEDATABASE"
>CSQLSELECT C ""
>CSTDFILTER C ""
>LADDALIAS L .F.
>LCONNECTED L .T.
>LENVIR...TISSET L .T.
>LNOCONNECTION L .F.
>LNOTIF...CHANGE L .F.
>LPERFORMJOINS L .F.
>LQUIET L .T.
>LREFRESHDATA L .F.
>LSCRIPTFAILED L .F.
>LUSEDATAGROUPS L .T.
>LUSEFO...UTMENU L .F.
>LUSEJOINSYNTAX L .T.
>NDATASOURCES N 1 ( 1.00000000)
>OCURSO...ECTION O SFQCURSORMETADATA
>ODATAB...ECTION O SFRDATABASECOLLECTION
>OFIELD...ECTION O SFQFIELDMETADATA
>OLOGGER O SFLOGGER
>OQUERY O SFQQUERYENGINE
>ORELAT...ECTION O SFQRELATIONMETADATA
>..."
>
>Object: LOREPORT Priv O SFREPORTQUICK
>
>Properties:
>AREPORTGROUPS A
>( 1) L .F.
>CAFTERDATA C ""
>CAFTERRUN C ""
>CBEFOREDATA C ""
>CCHARTCURSOR C ""
>CCOMMENTS C ""
>CCREATEDBY C "ADMIN"
>CCURRESC C ""
>CCURRESCAPE C ""
>CCURSOR C "_2D417BETW"
>CDATAGROUP C "All"
>CDISPLAY C ""
>CEMAILBODY C ""
>CEMAILCLASS C "SFROutputEmail"
>CEMAILLIBRARY C "SFReports.vcx"
>CEMAILSUBJECT C ""
>CERRORMESSAGE C ""
>CFILTER C ""
>CFOLDERS C "#18#"
>CFONTNAME C "Arial"
>CFOOTER C ""
>CFRXXML C ""
>CHEADER C "All Active"
>"
>CMODIFIEDBY C "ADMIN"
>CONSELECT C ""
>COUTPUT C "PREVIEW"
>COUTPUTCLASS C ""
>COUTPUTFILENAME C ""
>COUTPUTFILETYPE C ""
>COUTPUTLIBRARY C ""
>COUTPUTUSER C ""
>CRECIPIENTS C ""
>CREPOR...LDNAME C ""
>CREPORTALIGN C ""
>CREPORTCOLUMN C ""
>CREPOR...MNEVAL C ""
>CREPOR...LDNAME C ""
>CREPORTDATATYPE C ""
>CREPORTFIELD C ""
>CREPOR...FORMAT C ""
>CREPOR...UTMASK C ""
>CREPOR...LDTYPE C ""
>CREPORTFILENAME C ""
>CREPORTFONTNAME C ""
>CREPORTNAME C "People - Address; Phone; Email"
>CREPOR...ECLASS C "SFRQuickReportOptionsPage"
>CREPOR...IBRARY C "SFReportsUI.vcx"
>CREPORTPICTURE C ""
>CREPORTPROP C ""
>CREPORTTOTAL C ""
>CREPORTUNIQUEID C ""
>CREPTYPE C "Q"
>CRUNBY C "ADMIN"
>CSENDEREMAIL C "info@centerforreturn.org"
>CSENDERNAME C "center"
>CSNAPSHOT Q 0h4749463839...
>CSORTDISPLAY C "Full Name"
>CSORTEXPR C "PEOPLE.[Full Name]"
>CSQLCLAUSE C ""
>CSQLSELECT C ""
>CSTDFILTER C ""
>CTEMPFRXNAME C ""
>DCREATEDAT T 4/8/2008 10:21:51 PM
>DMODIFIEDAT T 5/7/2008 8:12:11 PM
>DREPORTDATE D 5/7/2008
>DRUNAT T 5/7/2008 7:58:55 PM
>LADJUS...CATION L .F.
>LADVANCE L .F.
>LALLOW...ICATES L .F.
>LALLOWFILTER L .T.
>LALLOW...REVIEW L .T.
>LALLOWSORT L .T.
>LDISPLAYFILTER L .T.
>LERASEREPORT L .T.
>LHAVEG...FIELDS L .T.
>LHAVEL...FFECTS L .F.
>LLANDSCAPE L .F.
>LNOTIF...CHANGE L .F.
>LPRINTING L .F.
>LQUIET L .T.
>LREPOR...UTOFIT L .F.
>LREPOR...PCOUNT L .F.
>LREPORTTOTALS L .F.
>LSNAPSHOT L .T.
>LSUMMARY L .F.
>LSUMMARYBAND L .T.
>LSUMMA...MENTED L .F.
>LSUPPORTAUTOFIT L .T.
>LUSEFO...UTMENU L .F.
>LUSEMAPI L .F.
>LUSEOLDENGINE L .F.
>LUSEPRINTER L .F.
>LUSEPR...PROMPT L .F.
>NENDPAGE N 9999 ( 9999.00000000)
>NFONTSIZE N 10 ( 10.00000000)
>NFONTSTYLE N 0 ( 0.00000000)
>NID N 22 ( 22.00000000)
>NLEFTGROUPTOTAL N 0 ( 0.00000000)
>NMARGIN N 0 ( 0.00000000)
>NMAXCOLHEIGHT N 0 ( 0.00000000)
>NMINPAPERWIDTH N 0 ( 0.00000000)
>NNEXTHPOS N 0 ( 0.00000000)
>NNUMBEROFGROUPS N 0 ( 0.00000000)
>NORIENTATION N 0 ( 0.00000000)
>NPAPERWIDTH N 0 ( 0.00000000)
>NREPOR...KCOLOR N 0 ( 0.00000000)
>NREPOR...CIMALS N 0 ( 0.00000000)
>NREPOR...ECOLOR N 0 ( 0.00000000)
>NREPOR...SITION N 0 ( 0.00000000)
>NREPOR...DWIDTH N 0 ( 0.00000000)
>NREPOR...THBOLD N 0 ( 0.00000000)
>NREPORTFONTSIZE N 0 ( 0.00000000)
>NREPORTGROUP N 0 ( 0.00000000)
>NREPORTHPOS N 0 ( 0.00000000)
>NREPORTMINWIDTH N 0 ( 0.00000000)
>NREPORTWIDTH N 0 ( 0.00000000)
>NSTARTPAGE N 1 ( 1.00000000)
>NSUMMA...AXHPOS N 0 ( 0.00000000)
>NTEMPLATE N 8 ( 8.00000000)
>OCOLUM...MPLATE 0
>OFIELD...ECTION O SFQFIELDCOLLECTION
>OFIELDTEMPLATE 0
>OGROUP...BJECTS 0
>OGROUP...MPLATE 0
>OGROUP...MPLATE 0
>OGROUP...MPLATE 0
>OGROUP...BJECTS 0
>OGROUP...MPLATE 0
>OGROUP...MPLATE 0
>OGROUP...MPLATE 0
>OMEMBERDATA O SFREPORTMEMBERDATAXML
>OQUERY O SFQQUERYENGINE
>OSFGDI O SFGDIMEASURESTRING
>OSORTCOLLECTION O SFRSORTCOLLECTION
>OSUMMA...MPLATE 0
>OVIEWER 0
>..."
>
>Object: LODATABASE Local O SFQDATABASE
>
>Properties:
>CDATASOURCE C "master"
>CDATAS...NCLASS C "SFQDataSourceCollection"
>CDATAS...IBRARY C "SFQFramework.vcx"
>CDESCRIPTION C "master"
>CERRORMESSAGE C ""
>sdk\source\sfqframework.vcx"
>CMETADATAALIAS C "REPMETA"
>CNAME C "master"
>N
>
>"
>IID N 1 ( 1.00000000)
>LCONNECTED L .T.
>LMAIN L .T.
>LNOTIF...CHANGE L .F.
>LQUIET L .F.
>LSCRIPTFAILED L .F.
>LUSEBU...SOURCE L .T.
>LUSEFO...UTMENU L .F.
>ODATASOURCE O SFQDATASOURCEVFP
>ODATAS...ECTION O SFQDATASOURCECOLLECTION
>..."
>
>Object: LOCONDITION Local O SFQCONDITION
>
>Properties:
>ACVALUES A
>( 1) C ""
>AVALUES A
>( 1, 1) L .F.
>( 1, 2) C ""
>CCONNECTION C " and "
>CDISPLAY C "Primary is Yes"
>CDISPL...ECTION C "and"
>CERRORMESSAGE C ""
>CFIELDDESC C "Primary"
>CFIELDEXPR C "PEOPLE.PRIMARY"
>CFIELDNAME C "PEOPLE.PRIMARY"
>CFIELDTYPE C "L"
>CFILTE...DITION C "PEOPLE.PRIMARY"
>CFORMAT C ""
>CINPUTMASK C "Y"
>CKEY C ""
>sdk\source\sfqframework.vcx"
>COPERATOR C "{FIELD}"
>COPERATORCLASS C "sfoperatorisyes"
>COPERATORDESC C "is Yes"
>CSQLCONDITION C "PEOPLE.PRIMARY"
>CSQLOPERATOR C "{FIELD}{TRUE}"
>CVALUETYPE C "Value"
>LASKATRUNTIME L .F.
>LCASE L .F.
>LEXACT L .T.
>LINCLU...ISPLAY L .T.
>LLOCALDATA L .T.
>LNOTIF...CHANGE L .F.
>LOK L .F.
>LREMOVE L .F.
>LRESOLVED L .F.
>LUPPER L .F.
>LUSEFO...UTMENU L .F.
>NFIELDDEC N 0 ( 0.00000000)
>NFIELDLEN N 1 ( 1.00000000)
>NNEEDVALUES N 0 ( 0.00000000)
>..."
>
>Object: LOFIELD Local O SFRFIELD
>
>Properties:
>ACALCFIELDS A
>( 1) L .F.
>CALIAS C "PEOPLE"
>CALIASCAPTION C "Members (Bio Info) - People"
>CCAPTION C "Primary"
>CCHARTFORMAT C ""
>CCHARTINPUTMASK C ""
>CCHARTTOTALTYPE C "N"
>CCLASS C ""
>CCOMMENT C ""
>CCURSO...LDNAME C ""
>CCURSORPATH C ""
>CDATABASE C "master"
>CERRORMESSAGE C ""
>CFIELDEXPR C "PEOPLE.PRIMARY"
>CFIELDNAME C "PEOPLE.PRIMARY"
>CFIELDTYPE C "L"
>CFINAL...LDNAME C ""
>CFONTNAME C ""
>CFORMAT C ""
>CGETMETHOD C ""
>CHEADING C "Primary"
>CINPUTMASK C "Y"
>CKEY C "STR(MIDNO)+IIF(PRIMARY," ","F")+UP
>PER(FNAME)"
>"
>CLIBRARY C ""
>CMEMBERDATA C ""
>COTHER C ""
>COUTPUTEXPR C ""
>COUTPUTTYPE C ""
>CROLES C ""
>CSETMETHOD C ""
>CTOTALTYPE C "N"
>CVALUESMETHOD C ""
>DUPDATED D 12/24/2007
>IID N 1594 ( 1594.00000000)
>LALLOW...ECTION L .F.
>LAUTOFIT L .T.
>LBOOKMARK L .F.
>LCALCULATED L .F.
>LDESCENDING L .F.
>LEXACT L .T.
>LFILTERABLE L .T.
>LFONTBOLD L .F.
>LFONTITALIC L .F.
>LFONTUNDERLINE L .F.
>LGROUPCOUNT L .F.
>LIGNOR...FILTER L .F.
>LINCLU...NGROUP L .F.
>LNEWPAGE L .F.
>LNOTIF...CHANGE L .F.
>LREPORTABLE L .T.
>LRESETPAGE L .F.
>LSORTABLE L .T.
>LSUPPRESS L .F.
>LUPPER L .F.
>LUSEDE...FORMAT L .T.
>LUSEDE...RCHART L .T.
>LUSEFO...UTMENU L .F.
>NBACKCOLOR N -1 ( -1.00000000)
>NCHART N 99 ( 99.00000000)
>NCHARTORDER N 0 ( 0.00000000)
>NCURSORSTATUS N 1 ( 1.00000000)
>NDATATRIMMING N 1 ( 1.00000000)
>NFIELDDEC N 0 ( 0.00000000)
>NFIELDLEN N 1 ( 1.00000000)
>NFONTALIGN N 0 ( 0.00000000)
>NFONTSIZE N 0 ( 0.00000000)
>NFORECOLOR N -1 ( -1.00000000)
>NGROUP N 0 ( 0.00000000)
>NHPOSITION N -1 ( -1.00000000)
>NORDER N 13 ( 13.00000000)
>NOUTPUTLEN N 0 ( 0.00000000)
>NVPOSITION N -1 ( -1.00000000)
>NWIDTH N 0 ( 0.00000000)
>OCOLLECTION O SFQFIELDMETADATA
>..."
>
>Object: LODATASOURCE Local O SFQDATASOURCEVFP
>
>Properties:
>CDATABASE C "N:\Exceed!\Data\master.dbc"
>CDESCRIPTION C "master"
>CERRORMESSAGE C ""
>sdk\source\sfqframework.vcx"
>CNAME C "master"
>CSELECT C "select dis..."
>CSHOWPLAN C ""
>CTYPE C "VFP"
>LCONNECTED L .T.
>LLOCALDATA L .T.
>LNOTIF...CHANGE L .F.
>LQUIET L .F.
>LSHOWPLAN L .F.
>LUSEFO...UTMENU L .F.
><memberdata name="cshowp
>lan" type="property" display="cShow
>Plan"/>
><memberdata name="lshowplan
>" type="property" display="lShowPla
>n"/>
></VFPData>"
>
>Object: LOCURSOR Local O SFRCURSOR
>
>Properties:
>CALIAS C "ENTITIES"
>CCAPTION C "Members (Bio Info) - Members Info"
>CCURSORPATH C ""
>CDATABASE C "master"
>CDATAGROUP C ",2185,2186,"
>CDATAGROUPTEXT C "Members (Bio Info),Donations Info"
>CERRORMESSAGE C ""
>"
>CORIGINALTABLE C ""
>COTHER C ""
>CROLES C ""
>CSCHEMA C ""
>CSUBTABLEFILTER C ""
>DUPDATED D 4/4/2008
>IID N 48 ( 48.00000000)
>LNOTIF...CHANGE L .F.
>LREPORTABLE L .T.
>LUSEFO...UTMENU L .F.
>LVIRTUAL L .F.
>OCOLLECTION O SFQCURSORMETADATA
>..."
>
>Object: LOQUERY Local O SFQQUERYENGINE
>
>Properties:
>AFIELDLIST A
>( 1) L .F.
>AJOINTABLES A
>( 1, 1) C "PEOPLE"
>( 1, 2) O SFJOINCOLLECTION
>( 1, 3) L .T.
>( 1, 4) N 2 ( 2.00000000)
>( 2, 1) C "ENTITIES"
>( 2, 2) O SFJOINCOLLECTION
>( 2, 3) L .T.
>( 2, 4) N 2 ( 2.00000000)
>AQUERY A
>( 1, 1) C ""
>( 1, 2) C "Descriptor equals ACTIV"
>( 1, 3) C "ENTITIES.DESCRIP"
>( 1, 4) C "C"
>( 1, 5) C "ENTITIES.DESCRIP='ACTIV'"
>( 1, 6) C "{FIELD}={PAD}{VALUE}"
>( 1, 7) C "ENTITIES.DESCRIP='ACTIV'"
>( 1, 8) N 5 ( 5.00000000)
>( 1, 9) N 0 ( 0.00000000)
>( 1, 10) C "'ACTIV'"
>( 1, 11) L .T.
>( 1, 12) C ""
>( 1, 13) C ""
>( 1, 14) C "Descriptor"
>( 1, 15) C "ENTITIES.DESCRIP"
>( 1, 16) C "equals"
>( 1, 17) L .F.
>( 1, 18) C "sfoperatorequals"
>( 1, 19) C "{FIELD}={PAD}{VALUE}"
>( 1, 20) C "Value"
>( 1, 21) L .F.
>( 1, 22) L .T.
>( 1, 23) C ""
>( 1, 24) C ""
>( 1, 25) L .F.
>( 2, 1) C " and "
>( 2, 2) C "Primary is Yes"
>( 2, 3) C "PEOPLE.PRIMARY"
>( 2, 4) C "L"
>( 2, 5) C "PEOPLE.PRIMARY"
>( 2, 6) C "{FIELD}"
>( 2, 7) C "PEOPLE.PRIMARY"
>( 2, 8) N 1 ( 1.00000000)
>( 2, 9) N 0 ( 0.00000000)
>( 2, 10) C ""
>( 2, 11) L .F.
>( 2, 12) C "and"
>( 2, 13) C ""
>( 2, 14) C "Primary"
>( 2, 15) C "PEOPLE.PRIMARY"
>( 2, 16) C "is Yes"
>( 2, 17) L .F.
>( 2, 18) C "sfoperatorisyes"
>( 2, 19) C "{FIELD}{TRUE}"
>( 2, 20) C "Value"
>( 2, 21) L .F.
>( 2, 22) L .T.
>( 2, 23) C ""
>( 2, 24) C "Y"
>( 2, 25) L .F.
>ATABLES A
>( 1) C ""
>CALIAS C "ADDRS"
>CCAPTION C "Reports Explorer - People - Addres
>s; Phone; Email"
>CCOLLATE C "GENERAL"
>CCONDITIONCLASS C "SFQCondition"
>CCONDI...IBRARY C "SFQFramework.vcx"
>CCURSORALIAS C "_2D417C4GB"
>CDISPLAY C "Descriptor equals ACTIV and Primar
>y is Yes"
>CERRORMESSAGE C ""
>CFIELD...NCLASS C "SFFieldCollection"
>CFIELD...IBRARY C "SFQuery.vcx"
>CFILTER C "ENTITIES.DESCRIP='ACTIV' and PEOPL
>E.PRIMARY"
>CFILTERCLASS C "SFGetFilter"
>CFILTE...IBRARY C "SFQueryUI.vcx"
>CFILTERDESCRIP C ""
>CFILTERNAME C ""
>CFILTE...FILTER C "iif(empty(This.cAlias), '', 'upper
>(trim(FILTERS.ALIAS)) == "' + upper
>(This.cAlias) + '"')"
>CFROMLIST C ""
>CGETEXPRCLASS C "SFQGetExpression"
>CGETEXPRLIBRARY C "SFQGetExpr.vcx"
>CGETRE...ECLASS C "SFGetFieldValuesDialog"
>CGETRE...IBRARY C "SFQueryUI.vcx"
>CGETVALUESCLASS C "SFGetValues"
>CGETVA...IBRARY C "SFQueryUI.vcx"
>CGROUPBY C ""
>CHELPFILE C "C:\PROGRAM FILES\STONEFIELD QUERY
>SDK\SFQUERY.CHM"
>CJOINLIST C ""
>sdk\source\sfqframework.vcx"
>CNAMEDELIMITERS C "[]"
>CORDERBY C "1, 2"
>CREGISTRYKEY C "Software\Stonefield Software Inc.\
>Stonefield Query"
>CSAVED...RTABLE C "FILTERS.DBF"
>CSELECTFIELDS C "PEOPLE.FNAME,PEOPLE.LNAME,GetForma
>ttedAddress(ADDRS.Address1,ADDRS.Ad
>dress2,ADDRS.CITY,ADDRS.ZIP,ADDRS.S
>TATE) as FullAddress"
>CSORTEXPR C ""
>CSQLCLAUSE C ""
>CSQLSELECT C "select dis..."
>CTAG C ""
>CTITLE C ""
>CVERSION C "6.0"
>CWHERE C ""
>LADDAL...ATIONS L .F.
>LALLOW...UNTIME L .T.
>LCANSAVEQUERY L .T.
>LCHECK...FIELDS L .T.
>LCLOSECURSOR L .T.
>LDISTINCT L .F.
>LDOSELECT L .F.
>LHANDL...ISPLAY L .T.
>LHAVEA...UNTIME L .F.
>LHAVEQUERY L .T.
>LNOTIF...CHANGE L .F.
>LOPENTABLES L .F.
>LQUIET L .T.
>LRESOLVEFILTER L .T.
>LSAVED L .F.
>LSAVEPOSITION L .T.
>LSELEC...APTION L .F.
>LSHOWALIAS L .T.
>LSHOWA...CHOICE L .T.
>LSHOWC...BUTTON L .T.
>LSHOWFIRSTALIAS L .F.
>LSHOWFULL L .F.
>LSHOWHELP L .T.
>LSHOWTABLES L .T.
>LSORTALPHA L .T.
>LSQL L .T.
>LSQLSHOWPLAN L .F.
>LUSECU...VALUES L .F.
>LUSEDI...ESSARY L .T.
>LUSEFO...UTMENU L .F.
>LUSEJOINSYNTAX L .T.
>LUSEPE...ATIONS L .F.
>LUSETE...ATIONS L .F.
>LUSEUPPER L .F.
>LVALID...FIELDS L .F.
>NCONDITIONS N 2 ( 2.00000000)
>OCURSO...ECTION O SFQCURSORMETADATA
>OFIELD...ECTION O SFQFIELDMETADATA
>OFILTERDIALOG 0
>OMETA 0
>OQUERY...ECTION O SFQFIELDCOLLECTION
>ORELAT...ECTION O SFQRELATIONMETADATA
><memberdata name="getval
>ues" type="method" display="GetValu
>es"/>
></VFPData>"
>
>Object:
>
>oApp.cVersion 3.10.2761
>....
>>
>>>I have another question. I have a Phones table where type identifies the kind of the Phone. Suppose, I'd like to combine two Phones in one field (separated with Chr(13), so it would become Memo field). Is there a way to do so with Stonefield Configuration Utility?
>>
>>As Frank suggested, I'd created a calculated field. I'd do it in the parent table rather than the Phones table. If you do it in the Phones table, because there could be multiple records for each parent record, you'd end up with multiple instances of the same combined phones.
>>
>>For example, suppose Phones is a child of Customers, so there are possibly multiple Phones records for each Customer. Also suppose there's a CustomerID field in Phones that's the foreign key to Customers, which has ID as its primary key. In this case, create a calculated field in Customers called Phones and have the output expression of that field call a script and pass it the ID for the Customer record; for example, GetPhones(Customer.ID). Thee code for GetPhones would be similar to the following:
lparameters tiCustomerID
>>local lnSelect, lcSelect, lcPhones
>>lnSelect = select()
>>lcSelect = 'select PhoneNumber, PhoneType from Phones ' + ;
>> 'where CustomerID=' + transform(tiCustomerID)
>>loDatabase = SQApplication.Databases.GetMainDatabase()
>>loDatabase.ExecuteSQLStatement(lcSelect, , 'TempCursor')
>>lcPhones = ''
>>scan
>> lcPhones = lcPhones + iif(empty(lcPhones), '', chr(13)) + ;
>> trim(PhoneNumber) + ' (' + trim(PhoneType) + ')'
>>endscan
>>select (lnSelect)
>>return lcPhonesThis would display something like this in a report:
Customer A 111-111-1111 (Home)
>> 222-222-2222 (Work)
>>Customer B 333-333-3333 (Home)
>> 444-444-4444 (Cell)
>>Doug
If it's not broken, fix it until it is.
My Blog 
