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.lcPhonesI 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
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.lcAddressAnd 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 
