Too bad they never presented SPROCs that you write once in SQL and reuse
anytime you need to get THAT DATA in your app.
Pass params instead of statements.
server to do the best job for processing. Inserting master and child
preprocessed in the plan compared to getting and insert into .....
statement 150 times a day.
Post by Dave Crozierhttp://www.ml-consult.co.uk/foxst-38.htm
... but it is only a cursory review.
In addition I usually use the thought process that anything you use in VFP
SQL you can do directly in TSQL apart from the pre VFP9 availability of
including fields in an aggregated SQL select statement that aren't included
in the Group by and order by clauses.
As for TSQL Functions, they are mostly completely different unless you
write your own "VFP Equivalent functions" in native TSQL which I did many
moons ago.
A great bonus of TSQL is that you don't need to pad out character select
expressions as you do in VFP where the first character select of a field
dictates the length of the selected SQL field - this used to bite me all
the time!!!
Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.
---------------------------------------------------------------
This communication and the information it contains is intended for the
person or organisation to whom it is addressed. Its contents are
confidential and may be protected in law. If you have received this e-mail
in error you must not copy, distribute or take any action in reliance on
it. Unauthorised use, copying or disclosure of any of it may be unlawful.
If you have received this message in error, please notify us immediately by
telephone or email.
Flexipol Packaging Ltd. has taken every reasonable precaution to minimise
the risk of virus transmission through email and therefore any files sent
via e-mail will have been checked for known viruses. However, you are
advised to run your own virus check before opening any
attachments received as Flexipol Packaging Ltd will not in any event
accept any liability whatsoever once an e-mail and/or any attachment is
received.
It is the responsibility of the recipient to ensure that they have
adequate virus protection.
Flexipol Packaging Ltd.
Unit 14 Bentwood Road
Carrs
Industrial Estate
Haslingden
Rossendale
Lancashire
BB4 5HH
Tel:01706-222792
Fax: 01706-224683
www.Flexipol.co.uk
---------------------------------------------------------------
Notwithstanding delivery and the passing of risk in the goods, the
property in the goods shall not pass to the buyer until the seller
Flexipol Packaging Ltd. ("The Company") has received in cash or cleared
funds payment in full of the price of the goods and all other goods agreed
to be sold by the seller to the buyer for which payment is then due. Until
such time as the property in the goods passes to the buyer, the buyer shall
hold the goods as the seller's fiduciary agent and bailee and keep the
goods separate from those of the buyer and third parties and properly
stored protected and insured and identified as the seller's property but
shall be entitled to resell or use the goods in the ordinary course of its
business. Until such time as the property in the goods passes to the buyer
the seller shall be entitled at any time
-----Original Message-----
Sent: 27 April 2018 15:13
Subject: VFP TSQL concordance
Hi all
There is a document in Ed's download area giving concordances between
VFP(6) and VB6. I am looking for something similar showing concordances
between VFP and TSQL. Has anybody come across such an animal?
Many thanks
Paul Newton
This message: http://leafe.com/archives/byMID/profox/CAJidMYKrj1dnT7Q7LH18UQ93ug7+FNkFTT+nj+-70HmKd09-***@mail.gmail.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.