RE: [ADMIN] Testing new mail relay
+1 -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Koen Piller Sent: Sunday, January 13, 2019 5:23 PM To: profoxt...@leafe.com Subject: Re: [ADMIN] Testing new mail relay Test successfull Op za 12 jan. 2019 om 23:05 schreef roger tremblay > got it > > On 1/10/2019 5:39 AM, Jerry Wolper wrote: > >> If someone can confirm that they can see this email it will help me in > confirming I am not going mad and that I am sending correctly. > > You're sending correctly. > > > > -Jerry > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/01d4ab4c$30374620$90a5d260$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Calling (sending) parameters from command line call
I use as: g:\Apps\MyApp.exe me.ini .F. .T. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, June 29, 2011 10:13 PM To: profoxt...@leafe.com Subject: Calling (sending) parameters from command line call I need to send 3 parameters with the call of this VFP executable. I'm having a brain fart and forgot how to do this! I'm creating a shortcut on the desktop and this doesn't work in the command: g:\Apps\MyApp.exe me.ini,.F.,.T. I just get back a Syntax error! Can you remind me of how to pass parms to the exe from the Windows call? tia, --Mike [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000601cc37e6$a5dd20c0$f1976240$@galaksi.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Zenburn for VFP
Thanks for this short way. Ali -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Tuesday, May 03, 2011 11:43 AM To: profoxt...@leafe.com Subject: RE: Zenburn for VFP Hi Ali, To restore the default colours, in VFP select the Tools menu, then Options, then the Editor tab. There you will see a 'Reset All' button. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/004301cc0973$778e5f50$66ab1df0$@galaksi.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Zenburn for VFP
I also enjoy. If I want to return original colors later, how can I do? Ali Ihsan -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Friday, April 29, 2011 5:58 PM To: profoxt...@leafe.com Subject: Re: Zenburn for VFP On Fri, 29 Apr 2011 09:39 -0400, Ted Roche tedro...@gmail.com wrote: I've been trying to find the ideal color scheme for me and vim for a while. It seems like it varies by season, room brightness and how tired my old eyes are. I don't use Vim, but Eclipse and derivatives like Aptana have it also. With me it varies based on how much prevaricating I'm doing. Lately I've been using 'solarized' which looks very similar: http://ethanschoonover.com/solarized Very nice ... I like the dark one. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/001201cc08ad$d05e57f0$711b07d0$@galaksi.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Zenburn for VFP
I have restored Zenburn. I don't know also how the registry exported? Can you give more information please? Ali Ihsan -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Monday, May 02, 2011 3:31 PM To: profoxt...@leafe.com Subject: RE: Zenburn for VFP Export the registry for your current settings and use that to restore as needed. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ali Ihsan Türkoglu Sent: Monday, May 02, 2011 5:46 AM To: profoxt...@leafe.com Subject: RE: Zenburn for VFP I also enjoy. If I want to return original colors later, how can I do? Ali Ihsan [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000301cc08c7$49da0200$dd8e0600$@galaksi.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Zenburn for VFP
Thanks. I will look to internet. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Monday, May 02, 2011 3:53 PM To: profoxt...@leafe.com Subject: RE: Zenburn for VFP You should be able to find information on how to work with the Windows registry out there on the internet. It's a little different for different versions of Windows. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ali Ihsan Türkoglu Sent: Monday, May 02, 2011 8:49 AM To: profoxt...@leafe.com Subject: RE: Zenburn for VFP I have restored Zenburn. I don't know also how the registry exported? Can you give more information please? Ali Ihsan -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Monday, May 02, 2011 3:31 PM To: profoxt...@leafe.com Subject: RE: Zenburn for VFP Export the registry for your current settings and use that to restore as needed. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000f01cc08e7$63418e50$29c4aaf0$@galaksi.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: XMLAdapter vfp9
Mr.Copquin,
Thanks for your reply.
With VFP, Produce XML from cursor and returning back is easy and no problem.
But my xml is not produced by Vfp. My xml is gotten from asmx web service as
datatable type (.Net datatable)
When I try as just you described, I get only an empty cursor, although xml have
data rows.
Ali Ihsan
-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On
Behalf Of Rafael Copquin
Sent: Monday, October 26, 2009 1:37 PM
To: profoxt...@leafe.com
Subject: Re: XMLAdapter vfp9
With these statements you create a XML adapter and populate it with two
cursors:
oXML=CreateObject('XmlAdapter')
oXML.AddTableSchema('curWeeks')
oXML.AddTableSchema('curSemanas')
oXML.ToXML('cXML')
You can send the cXML variable to another form, with a private data session
thus:
do form form2 with cXML
with these statetements you retrieve the two cursors from the XML adapter,
but in form2
** init event form 2
lparameters tcXML
local cXML
cXML = tcXML
oXML=CreateObject('XmlAdapter')
oXML.LoadXML(cXML)
oXML.Tables.Item(1).ToCursor() name of the first cursor ie: curWeeks
oXML.Tables.Item(2).ToCursor() name of the second cursor ie: curSemanas
the above are taken from an actual application I am just building
Be careful, pay attention to the quote marks and how to use them. In the
first snippet, you use the quotes and create the xml variable (cXML).
In the second snippet, you use the variable cXML, but without the quotes.
Regards
Rafael Copquin
- Original Message -
From: Ali İhsan Türkoğlu aih...@galaksi.com
To: profoxt...@leafe.com
Sent: Sunday, October 25, 2009 1:25 AM
Subject: RE: XMLAdapter vfp9
Mr. Russell,
Sorry for my poor english. I don't understand what you mean.
My question is: Although xml file has 4 records, I can not get them with
xmladapter.
-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]
On Behalf Of Stephen Russell
Sent: Saturday, October 24, 2009 10:30 PM
To: profoxt...@leafe.com
Subject: Re: XMLAdapter vfp9
You may need to populate this XML obj and then use it to run a query
that will give you data.
Sent from my iPhone
Stephen Russell
901.246-0159
On Oct 24, 2009, at 2:51 PM, Ali İhsan Türkoğlu aih...@galaksi.com
wrote:
I can get only an empty cursor from this xml.
What is missing?
My code is:
public oXMLAdapter AS XMLADAPTER
oXMLAdapter = NEWOBJECT('XMLAdapter')
oXMLAdapter.LOADXML('D:\mkys\xml\ntKodGet2.xml', .T.)
?oXMLAdapter.tables.Count prints 1
oXMLAdapter.tables(1).ToCursor() kod cursor is created just
defined in
schema but, EMPTY !!!
My XML is:
?xml version=1.0 encoding=utf-8?
ntKodGetResult
xs:schema
id=NewDataSet
xmlns= xmlns:xs=http://www.w3.org/2001/XMLSchema;
xmlns:msdata=urn:schemas-microsoft-com:xml-msdata
xs:element
name=NewDataSet msdata:IsDataSet=true msdata:MainDataTable=kod
msdata:UseCurrentLocale=true
xs:complexType
xs:choice minOccurs=0 maxOccurs=unbounded
xs:element name=kod
xs:complexType
xs:sequence
xs:element name=KOD_ID type=xs:long minOccurs=0/
xs:element name=KOD_ADI type=xs:string minOccurs=0/
xs:element name=DEGER type=xs:string minOccurs=0/
xs:element name=TANIM type=xs:string minOccurs=0/
xs:element name=ACIKLAMA type=xs:string minOccurs=0/
xs:element name=AKTIF type=xs:string minOccurs=0/
/xs:sequence
/xs:complexType
/xs:element
/xs:choice
/xs:complexType
/
xs:element
/xs:schema
diffgr:diffgram
xmlns:msdata=urn:schemas-microsoft-com:xml-msdata
xmlns:diffgr=urn:schemas-microsoft-com:xml-diffgram-v1
DocumentElement
xmlns=
kod
diffgr:id=kod1 msdata:rowOrder=0
KOD_ID8893/KOD_ID
KOD_ADITASINIR_HAREKET_TURU/KOD_ADI
DEGERC1/DEGER
TANIMDEVİR- AMBARLAR ARASI DEVİR/TANIM
ACIKLAMATaşınır Hareket Türleri/ACIKLAMA
AKTIFE/AKTIF
/kod
kod
diffgr:id=kod2 msdata:rowOrder=1
KOD_ID8894/KOD_ID
KOD_ADITASINIR_HAREKET_TURU/KOD_ADI
DEGERC2/DEGER
TANIMFİRE, ZAYİAT/TANIM
ACIKLAMATaşınır Hareket Türleri/ACIKLAMA
AKTIFE/AKTIF
/kod
kod
diffgr:id=kod3 msdata:rowOrder=2
KOD_ID8895/KOD_ID
KOD_ADITASINIR_HAREKET_TURU/KOD_ADI
DEGERC3/DEGER
TANIMDEVİR-DİĞER BİRİMLERE ÇIKIŞ/TANIM
ACIKLAMATaşınır Hareket Türleri/ACIKLAMA
AKTIFE/AKTIF
/kod
kod
diffgr:id=kod4 msdata:rowOrder=3
KOD_ID8896/KOD_ID
KOD_ADITASINIR_HAREKET_TURU/KOD_ADI
DEGERC4/DEGER
TANIMTÜKETİM/TANIM
ACIKLAMATaşınır Hareket Türleri/ACIKLAMA
AKTIFE/AKTIF
/kod
/DocumentElement
/diffgr:diffgram
RE: XMLAdapter vfp9
I attached xml file. In xml, not dataset but datatable is being. And datatable schema is in first part of the file. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Monday, October 26, 2009 3:43 PM To: profoxt...@leafe.com Subject: Re: XMLAdapter vfp9 On Mon, Oct 26, 2009 at 7:39 AM, Ali İhsan Türkoğlu aih...@galaksi.com wrote: Mr.Copquin, Thanks for your reply. With VFP, Produce XML from cursor and returning back is easy and no problem. But my xml is not produced by Vfp. My xml is gotten from asmx web service as datatable type (.Net datatable) When I try as just you described, I get only an empty cursor, although xml have data rows. -- Can you verify that the xml returned has multiple rows? Are there multiple nodes within the XML? The term DataSet from .NET could contain multiple tables. This may be your problem from the VFP side. Do you have access to the schema? -- Stephen Russell Sr. Production Systems Programmer SQL Server DBA Web and Winform Development Independent Contractor Memphis TN 901.246-0159 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000301ca5648$c66e4570$534ad0...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: XMLAdapter vfp9
Sorry, profox is preventing the attached file. When I put the xml to this message, format is break down. How can I send my xml to you without corruption? -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ali İhsan Türkoğlu Sent: Monday, October 26, 2009 4:30 PM To: profoxt...@leafe.com Subject: RE: XMLAdapter vfp9 I attached xml file. In xml, not dataset but datatable is being. And datatable schema is in first part of the file. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Monday, October 26, 2009 3:43 PM To: profoxt...@leafe.com Subject: Re: XMLAdapter vfp9 On Mon, Oct 26, 2009 at 7:39 AM, Ali İhsan Türkoğlu aih...@galaksi.com wrote: Mr.Copquin, Thanks for your reply. With VFP, Produce XML from cursor and returning back is easy and no problem. But my xml is not produced by Vfp. My xml is gotten from asmx web service as datatable type (.Net datatable) When I try as just you described, I get only an empty cursor, although xml have data rows. -- Can you verify that the xml returned has multiple rows? Are there multiple nodes within the XML? The term DataSet from .NET could contain multiple tables. This may be your problem from the VFP side. Do you have access to the schema? -- Stephen Russell Sr. Production Systems Programmer SQL Server DBA Web and Winform Development Independent Contractor Memphis TN 901.246-0159 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000701ca5649$b2ec9190$18c5b4...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: MySql query speed
I don't understand. What is to give a nint to index? -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Wednesday, October 07, 2009 6:10 PM To: profoxt...@leafe.com Subject: Re: MySql query speed On Wed, Oct 7, 2009 at 9:29 AM, Paul McNett p...@ulmcnett.com wrote: Stephen Russell wrote: You will need a compound index kabul_cikis basvuru_fk and devrkurum and iptal and cikis_zmn CREATE INDEX kabul_cikis_fk_devrkurum_iptal_cicis_zmn ON kabul_cikis (fk, devrkurum, iptal, cikis_zmn); In MySQL can you give a nint to the index you want used? It may still pick up the plain Jane index on FK and not consider the new one. -- Stephen Russell Sr. Production Systems Programmer SQL Server DBA Web and Winform Development Independent Contractor Memphis TN 901.246-0159 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/001201ca4975$e6002190$b20064...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
MySql query speed
I am new on MySql. I run the below query in MySql Query Browse. Althought I wait more than 10 minutes, not reached the result. Please help what is wrong with my guery. select k.*, b.sgk_statu from kabul_cikis k, basvuru b where k.basvuru_fk = b.id and k.sosguvsnf = 1 and k.iptal 1 and b.id between 1 and 50655 and b.id in( select basvuru_fk from kabul_cikis where iptal 1 group by basvuru_fk having MIN(cikis_zmn) ' ') and k.devrkurum '4'; --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000601ca4756$89ce2af0$9d6a80...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: MySql query speed
In kabul_cikis, there are 47000 rows. I have indexes on those fields. I just added compaund index also. Result is same. When I run queries one by one: I mean in(...) query: select basvuru_fk from kabul_cikis where iptal 1 group by basvuru_fk having MIN(cikis_zmn) ' ' Result is : 44048 rows fetched in 0,08s select k.*, b.sgk_statu from kabul_cikis k, basvuru b where k.basvuru_fk = b.id and k.sosguvsnf = 1 and k.iptal 1 and b.id between 1 and 50655 and k.devrkurum '4'; Result is : 40867 rows fetched in 1,36s. But when together, infinite time. Same query run in vfp and mssql in few seconds. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Wednesday, October 07, 2009 5:24 PM To: profoxt...@leafe.com Subject: Re: MySql query speed On Wed, Oct 7, 2009 at 9:00 AM, Ali İhsan Türkoğlu aih...@galaksi.com wrote: I am new on MySql. I run the below query in MySql Query Browse. Althought I wait more than 10 minutes, not reached the result. Please help what is wrong with my guery. select k.*, b.sgk_statu from kabul_cikis k, basvuru b where k.basvuru_fk = b.id and k.sosguvsnf = 1 and k.iptal 1 and b.id between 1 and 50655 and b.id in( select basvuru_fk from kabul_cikis where iptal 1 group by basvuru_fk having MIN(cikis_zmn) ' ') and k.devrkurum '4'; -- You will need a compound index kabul_cikisbasvuru_fk and devrkurum and iptal and cikis_zmn How many rows are in kabul_cikis? You are probably getting hit hard here MIN(cikis_zmn) ' ' HTH -- Stephen Russell Sr. Production Systems Programmer SQL Server DBA Web and Winform Development Independent Contractor Memphis TN 901.246-0159 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/01ca475d$50f5ff30$f2e1fd...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: MySql query speed
I added compound index and tried without limit. Result is: 40867 rows fetched in o.71s. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul McNett Sent: Wednesday, October 07, 2009 5:27 PM To: profoxt...@leafe.com Subject: Re: MySql query speed Ali İhsan Türkoğlu wrote: I am new on MySql. I run the below query in MySql Query Browse. Althought I wait more than 10 minutes, not reached the result. Please help what is wrong with my guery. select k.*, b.sgk_statu from kabul_cikis k, basvuru b where k.basvuru_fk = b.id and k.sosguvsnf = 1 and k.iptal 1 and b.id between 1 and 50655 and b.id in( select basvuru_fk from kabul_cikis where iptal 1 group by basvuru_fk having MIN(cikis_zmn) ' ') and k.devrkurum '4'; Try this one that doesn't get all fields, that puts the join in a join clause, (temporarily) does away with the subquery, and adds a limit clause, and see if it performs better: select k.iptal, k.sosguvsnf, k.devrkurum, b.sgk_statu from kabul_cikis k inner join basvuru b on b.id = k.basvuru_fk where k.sosguvsnf = 1 and k.iptal 1 and b.id between 1 and 50665 and k.devrkurum '4' limit 1000; If this one still takes forever, you need to look at your indexes. If this one performs quickly, start adding back the things I took away to find out where the bottleneck is. If there are a ton of fields coming over a slow net for over 50K records, that will definitely slow it down. Perhaps it is the subquery. HTH Paul [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000101ca475e$de9a6a00$9bcf3e...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: MySql query speed
When I write EXPLAIN keyword to the beginning of the select statment, I get: select `k`.`id` AS `id`,`k`.`kayit_fk` AS `kayit_fk`,`k`.`kabul_yeri` AS `kabul_yeri`,`k`.`kabul_zmn` AS `kabul_zmn`,`k`.`kabul_sekl` AS `kabul_sekl`,`k`.`sevk_trh` AS `sevk_trh`,`k`.`geld_polk` AS `geld_polk`,`k`.`vaka_turu` AS `vaka_turu`,`k`.`sgk_takipn` AS `sgk_takipn`,`k`.`cikis_sekl` AS `cikis_sekl`,`k`.`cikis_zmn` AS `cikis_zmn`,`k`.`svkedl_plk` AS `svkedl_plk`,`k`.`hekim_fk` AS `hekim_fk`,`k`.`sgk_yknlk` AS `sgk_yknlk`,`k`.`sigortturu` AS `sigortturu`,`k`.`sosguvsnf` AS `sosguvsnf`,`k`.`devrkurum` AS `devrkurum`,`k`.`kurum_fk` AS `kurum_fk`,`k`.`ozkurum_fk` AS `ozkurum_fk`,`k`.`takipturu` AS `takipturu`,`k`.`sorguturu` AS `sorguturu`,`k`.`taburcukod` AS `taburcukod`,`k`.`istisnadrm` AS `istisnadrm`,`k`.`tdv_sekli` AS `tdv_sekli`,`k`.`basim_zmn` AS `basim_zmn`,`k`.`kabul_mik` AS `kabul_mik`,`k`.`ilktakipno` AS `ilktakipno`,`k`.`takiptipi` AS `takiptipi`,`k`.`tedavi_tur` AS `tedavi_tur`,`k`.`tedavitipi` AS `tedavitipi`,`k`.`donortckno` AS `donortckno`,`k`.`basvuruno` AS `basvuruno`,`k`.`basvuru_fk` AS `basvuru_fk`,`k`.`icmal_fk` AS `icmal_fk`,`k`.`sgk_tutar` AS `sgk_tutar`,`k`.`hzmkayit` AS `hzmkayit`,`k`.`evrak_trh` AS `evrak_trh`,`k`.`evrak_no` AS `evrak_no`,`k`.`iptal` AS `iptal`,`k`.`kullanc_fk` AS `kullanc_fk`,`b`.`sgk_statu` AS `sgk_statu` from `kabul_cikis` `k` join `basvuru` `b` where ( (`b`.`id` = `k`.`basvuru_fk`) and (`k`.`sosguvsnf` = 1) and (`k`.`iptal` 1) and (`k`.`basvuru_fk` between 1 and 50655) and in_optimizer(`k`.`basvuru_fk`,exists(select `kabul_cikis`.`basvuru_fk` AS `basvuru_fk` from `kabul_cikis` where (`kabul_cikis`.`iptal` 1) group by `kabul_cikis`.`basvuru_fk` having ((min(`kabul_cikis`.`cikis_zmn`) _utf8' ') and (cache(`b`.`id`) = ref_null_helper(`kabul_cikis`.`basvuru_fk`) and (`k`.`devrkurum` _utf8'4') ) -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, October 07, 2009 6:43 PM To: profoxt...@leafe.com Subject: Re: MySql query speed Stephen Russell wrote: On Wed, Oct 7, 2009 at 9:29 AM, Paul McNett p...@ulmcnett.com wrote: Stephen Russell wrote: You will need a compound index kabul_cikisbasvuru_fk and devrkurum and iptal and cikis_zmn CREATE INDEX kabul_cikis_fk_devrkurum_iptal_cicis_zmn ON kabul_cikis (fk, devrkurum, iptal, cikis_zmn); In MySQL can you give a nint to the index you want used? It may still pick up the plain Jane index on FK and not consider the new one. Look into the EXPLAIN option too to help you see what is optimized and what's not. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000601ca4779$58f6e1b0$0ae4a5...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Need help on Select command
Select * from stock where code in (select code from stock where description like '+%' -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of free...@sohocare Sent: Friday, September 11, 2009 4:21 AM To: profoxt...@leafe.com Subject: Need help on Select command dear all GURU, Can anyone help me on how to use SELECT * from stock .. command to get the following result? STOCK.DBF code description 100 book 100 +book 101 paper 102 pen 102 +pen 103 stamp 104 brush RESULT: (List of duplicate code) code description 100 book 100 +book 102 pen 102 +pen TIA --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/001b01ca33ac$b3562840$1a0278...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Need help on Select command
Pardon, I misread. Select * from stock where code in (select code from stock group by code having count(*) 1) -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of free...@sohocare Sent: Friday, September 11, 2009 4:21 AM To: profoxt...@leafe.com Subject: Need help on Select command dear all GURU, Can anyone help me on how to use SELECT * from stock .. command to get the following result? STOCK.DBF code description 100 book 100 +book 101 paper 102 pen 102 +pen 103 stamp 104 brush RESULT: (List of duplicate code) code description 100 book 100 +book 102 pen 102 +pen TIA --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/001f01ca33ae$6960fb50$3c22f1...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Encrypted option won't stay unchecked in VFP9SP2 project
İf any included application file is encrypted, that Project also sign as encrypted. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Friday, August 28, 2009 3:00 AM To: profoxt...@leafe.com Subject: Encrypted option won't stay unchecked in VFP9SP2 project I uncheck the Encryped checkbox in the Project-Info screen, yet when I build the app, I go back there and see that it's STILL checked. What's up with that? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/003201ca2b9e$5283ffd0$f78bff...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Modal form on Vista
My main program is: Do form mainform.scx Read Events Mainform.scx ShowWindow = 2 - As Top-Level Form WindowType = 0 - Modeless Init: Do MainMenu.mpr with this, .t. *** MainMenu.mpr General Options: Checked as Top-Level Form When I call a modal form from MainMenu.mpr, I expect that all menu pads will be disabled as like past. But, they never be disabled. Ali -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Pearson Sent: Tuesday, November 25, 2008 4:22 PM To: [EMAIL PROTECTED] Subject: RE: Modal form on Vista Are you sure it's Modal? When you call the form, does your code continue to run, or does it stop? When a Form has DESKTOP=.T. or is Top-Level, the Modal state is turned off at instantiation. Tracy -Original Message- From: Ali Ihsan Türkoglu Sent: Monday, November 24, 2008 6:49 PM I have a main form (as top level form) and a main menu. When I call any modal form, I didn't activate the menu pads before. In Vista, all menu pads can be selected. Am I wrong? Ali [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Modal form on Vista
I put these lines to main program entrance, but no change. I declared a public variable as ModalOn = .f.. On each menu pad, I put skip for ModalOn. When I enter to a modal form, I do ModalOn = .t., and when unload event of the modal form, again ModalOn = .f. With this way, I solved the problem but, I look for an easier way. Ali -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Pearson Sent: Tuesday, November 25, 2008 9:13 PM To: [EMAIL PROTECTED] Subject: RE: Modal form on Vista Could this be related: IF OS(3) = 6 DECLARE integer GdiSetBatchLimit IN WIN32API integer GdiSetBatchLimit(1) ENDIF There is an issue with popups not releasing the highlighting correctly. This is what works around it. I would need to build a test project, or if you have a small test project for others with Vista to test. Tracy -Original Message- From: Ali Ihsan Türkoglu Sent: Tuesday, November 25, 2008 1:30 PM My main program is: Do form mainform.scx Read Events Mainform.scx ShowWindow = 2 - As Top-Level Form WindowType = 0 - Modeless Init: Do MainMenu.mpr with this, .t. *** MainMenu.mpr General Options: Checked as Top-Level Form When I call a modal form from MainMenu.mpr, I expect that all menu pads will be disabled as like past. But, they never be disabled. Ali -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Pearson Sent: Tuesday, November 25, 2008 4:22 PM To: [EMAIL PROTECTED] Subject: RE: Modal form on Vista Are you sure it's Modal? When you call the form, does your code continue to run, or does it stop? When a Form has DESKTOP=.T. or is Top-Level, the Modal state is turned off at instantiation. Tracy -Original Message- From: Ali Ihsan Türkoglu Sent: Monday, November 24, 2008 6:49 PM I have a main form (as top level form) and a main menu. When I call any modal form, I didn't activate the menu pads before. In Vista, all menu pads can be selected. Am I wrong? Ali [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Modal form on Vista
I have a main form (as top level form) and a main menu. When I call any modal form, I didn't activate the menu pads before. In Vista, all menu pads can be selected. Am I wrong? Ali ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Escape from Infinite loop
Mr. Mike show very good ways: There are plenty of ways you can do this. The simplest would be to create a form property, lStop, which is set to .T. in the stop button's Click() Then, in your loop, you will need to call DoEvents() once in a while. This will let the UI events happen, so your code can check to see if lStop has been set to .T. If it has, you can end your loop. Another way would be to use two programs 1. a UI-less EXE that performs your loop. 2. a UI that creates and deletes a file on disk When the UI application starts, it should create the file, and launch the UI-less app. When the stop button is clicked on the UI application, it should delete the file. The loop can do something like this: do while .t. if file(myservice.txt) *** Code to open DBF, look for records, and process else exit endif enddo So if myservice.txt exists, the loop keeps running. If it gets deleted, the loop stops. One benefit of this method is that the loop can be terminated by deleting a file from Windows explorer, if all else fails. Cloud Music Company -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ali İhsan Türkoğlu Sent: Friday, January 05, 2007 6:13 PM To: [EMAIL PROTECTED] Subject: Escape from Infinite loop I should write a VFP program that work on server. Continuously, This program will look a vfp table, if new records added, make some jobs. User should start and stop this program. Question is: How can I escape from an endless loop, when user clicks the stop buton on my vfp form? Is this type program consume much CPU time due to endless do while loop? Thanks for all help. Ali Ihsan --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Escape from Infinite loop
Mr. Bill, If the load is not so much, I think you right. My program will call WebServices continuously. If demands are much, I may run the same program more than one in the server. If I use timer event, I don't sure what should be the intervals. More interval means client wait more, short intervals may decrease the capture of stop button click event. I mean when user click the stop button, if program in job, will not reponse. Isn't it? Ali Ihsan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Arnold Sent: Monday, January 08, 2007 12:35 PM To: [EMAIL PROTECTED] Subject: RE: Escape from Infinite loop The loop can do something like this: do while .t. if file(myservice.txt) *** Code to open DBF, look for records, and process else exit endif enddo So if myservice.txt exists, the loop keeps running. If it gets deleted, the loop stops. One benefit of this method is that the loop can be terminated by deleting a file from Windows explorer, if all else fails. Wouldn't it be better to put the test into a timer event, so it doesn't waste resources? I haven't implemented your appoach anywhere, but can see it's usefulness. I'd just like not to eat a lot of resources when in this mode, which potentially can go on for some time. Also, I am assuming that timer-driven events are a hardware (clock) thing and not a loop somewhere within VFP's runtime, in which case it doesn't matter as much. I believe this question has come up before, but don't think I got a clear understanding of it: do timer events eat any resources while waiting to fire? Bill Cloud Music Company [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Escape from Infinite loop
I should write a VFP program that work on server. Continuously, This program will look a vfp table, if new records added, make some jobs. User should start and stop this program. Question is: How can I escape from an endless loop, when user clicks the stop buton on my vfp form? Is this type program consume much CPU time due to endless do while loop? Thanks for all help. Ali Ihsan --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
calling a webservce with SOAP input
I tried so many different configuration, but I couldn't obtain return object from a webservice. WebService address is : http://4300021:[EMAIL PROTECTED]/saglikws/services/ProvizyonIs lemleri/wsdl/ProvizyonIslemleri.wsdl 4300021:4300021 are username and password. I need to call HastaKabul method. Input parameter of this method as SOAP message is: ?xml version=1.0 encoding=utf-8? soap:Envelope xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:enc=http://schemas.xmlsoap.org/soap/encoding; soap:Body impl:hastaKabul xmlns:impl=http://servisler.ws.gss.sgk.gov.tr; provizyonGiris devredilenKurum3/devredilenKurumhastaKarneNo11216/hastaKarneNoh astaSosyalGuvNo11126/hastaSosyalGuvNohastaTCKimlikNo49000719000 /hastaTCKimlikNoprovizyonTarihi22.12.2006/provizyonTarihiprovizyonTip iN/provizyonTipisaglikTesisKodu10662/saglikTesisKodusigortaliTuru2 /sigortaliTurutakipNo/takipNotakipTuru1/takipTuruyakinlikKodu/ya kinlikKodu /provizyonGiris /impl:hastaKabul /soap:Body /soap:Envelope I obtain this SOAP message by using StrikeIron Web Services Analyzer. With this analyzer, I can call the WS easly. How should I call this method? lcXml = ?? LOCAL loProvizyonIslemleri AS XML Web Service LOCAL loException, lcErrorMsg, loWSHandler TRY loWSHandler = NEWOBJECT(WSHandler,IIF(VERSION(2)=0,,HOME()+FFC\)+_ws3client.vcx) loProvizyonIslemleri = loWSHandler.SetupClient(http://4300021:[EMAIL PROTECTED]/sagl ikws/services/ProvizyonIslemleri/wsdl/ProvizyonIslemleri.wsdl, ProvizyonIslemleriService, ProvizyonIslemleri) leResult = loProvizyonIslemleri.hastaKabul(lcXml) CATCH TO loException lcErrorMsg=Error: +TRANSFORM(loException.Errorno)+ - +loException.Message DO CASE CASE VARTYPE(loProvizyonIslemleri)#O * Handle SOAP error connecting to web service CASE !EMPTY(loProvizyonIslemleri.FaultCode) * Handle SOAP error calling method lcErrorMsg=lcErrorMsg+CHR(13)+loProvizyonIslemleri.Detail OTHERWISE * Handle other error ENDCASE * Use for debugging purposes MESSAGEBOX(lcErrorMsg) FINALLY ENDTRY --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
WSDL to XML converter
I must call some web services. These web services methots are required input and output parameters which are composed of complex type objects. Some parameters are complex object of other complex type object (and/or) complex object arrays. Is there a tool that read WSDL file, and produces methots input and output parameters as XML? If I know this XML structure, filling it with data will be very easy using VFP. Thanks Ali Ihsan --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
calling a webservice with username and password
How can I send username and password to a web service in vfp9? Programatically or from task pane- xml http://msdn.microsoft.com/xml/default.asp web services? Web service is : http://test.sgk.gov.tr/saglikws/services/ProvizyonIslemleri/wsdl/ProvizyonIs lemleri.wsdl username:4300021 password:4300021 Thanks Ali Ihsan --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
