Hi VFPers
I have asked this question on foxite too with very little feedback, so I
am asking it here too.
If you have to summarize the 1 or 2 features of VFP that you will feel
is a step backwards when migrating to .NET or any other platform as a
move forwards.
Looking forward to your repl
Steve Ellenoff and I were talking the other day about the beauty of
TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or
earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often.
On 6/27/2019 8:51 AM, Johan Nel wrote:
Hi VFPers
I have asked this question on f
Thanks,
Good news is that X# in its current version is mapping TEXT/ENDTEXT to
an internal function... See personal communication regarding the command
with Robert.
TEXT .. ENDTEXT is also parsed and send to a function with the name
"__TextSupport". That function is not included in the runti
ays to use VFP commands and features, I think I fear losing any of them!
Paul H. Tarver
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Johan
Nel
Sent: Thursday, June 27, 2019 7:52 AM
To: profoxt...@leafe.com
Subject: [NF] What would you miss from
---
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Johan
Nel
Sent: Thursday, June 27, 2019 7:52 AM
To: profoxt...@leafe.com
Subject: [NF] What would you miss from VFP, when migrating
Hi VFPers
I have asked this question on foxite too with very little feedback, so I
am asking it here
The VFP Report Writer is amazing compared to other development tools
I've seen, including my beloved Xojo. I've had to create my own report
writer that spits out HTML based reports just to get me close to what
VFP offered.
Another language command is the SCATTER NAME and GATHER NAME. The
abi
Am I missing something about TEXT/ENDTEXT where it just mashes up a string
for you for whatever transpires within the loop?
What do you do with that output or the textmerge when you are done with
it?
On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolut
In my largest case, it's usually helping to build SQLs dynamically
depending on a number of variables. In other cases, it's for building a
SET FILTER command which then gets executed.
On 6/27/2019 3:43 PM, Stephen Russell wrote:
Am I missing something about TEXT/ENDTEXT where it just mashes
Behalf Of Stephen
Russell
Sent: Thursday, June 27, 2019 2:43 PM
To: profoxt...@leafe.com
Subject: Re: [NF] What would you miss from VFP, when migrating
Am I missing something about TEXT/ENDTEXT where it just mashes up a string
for you for whatever transpires within the loop?
What do you do with that
+1
Paul H. Tarver
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kevin Cully
Sent: Thursday, June 27, 2019 12:25 PM
To: profoxt...@leafe.com
Subject: Re: [NF] What would you miss from VFP, when migrating
The VFP Report Writer is amazing compared
Thanks.
It gives me a chuckle like this:
https://www.explainxkcd.com/wiki/index.php/Little_Bobby_Tables
On Thu, Jun 27, 2019 at 2:45 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> In my largest case, it's usually helping to build SQLs dynamically
> depend
Knew you'd post that. I win my bets. lol
Careful consideration is always made so thanks for the humor nonetheless.
On 6/27/2019 4:10 PM, Stephen Russell wrote:
Thanks.
It gives me a chuckle like this:
https://www.explainxkcd.com/wiki/index.php/Little_Bobby_Tables
---
This email has been
...@leafe.com] On Behalf Of
> Stephen
> Russell
> Sent: Thursday, June 27, 2019 2:43 PM
> To: profoxt...@leafe.com
> Subject: Re: [NF] What would you miss from VFP, when migrating
>
> Am I missing something about TEXT/ENDTEXT where it just mashes up a string
> for you for whatever
I now have an Information Safety manager who is applying real safety for
our company to protect from the outside as well as ID-10-Ts who open the
wrong documents.
He has hacking sub-contractors that test our internal web apps and I get to
see what they do in logs, and I ask if it was him or his te
I think I would miss SCAN/ENDSCAN most.
John
John Weller
01380 723235
07976 393631
___
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/mail
Yeah, that'd suck. I guess you'd have to loop through record sets like ADO
FOR MyLoop = 1 to MyRecordSet.Recordset.Count
ENDFOR
??? "This sucks"
On 6/27/2019 4:45 PM, John Weller wrote:
I think I would miss SCAN/ENDSCAN most.
John
John Weller
01380 723235
07976 393631
[excessive quotin
PM
To: profoxt...@leafe.com
Subject: Re: [NF] What would you miss from VFP, when migrating
As a dba that scares the shit out of me. Just being honest about dynamic
statements and hackers who might know how to mess with you.
This fear is real.
https://codecurmudgeon.com/wp/sql-injection-hall-of-s
e.
>
> Paul H. Tarver
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Stephen
> Russell
> Sent: Thursday, June 27, 2019 3:17 PM
> To: profoxt...@leafe.com
> Subject: Re: [NF] What would you miss from VFP, when migrating
&g
: profoxt...@leafe.com
Subject: Re: [NF] What would you miss from VFP, when migrating
just put this into your textbox that gets passed back:
1=1 ; Drop table customers go
On Thu, Jun 27, 2019 at 3:54 PM Paul H. Tarver wrote:
> I meant "dynamic" in the sense of controlling variab
On 6/27/2019 6:39 PM, Paul H. Tarver wrote:
Give me a little credit for being a better programmer than that.
C'mon, Paul -- it's mega-million$ $teve we're talking about here. Mr.
Deep Pockets with SQL Server blinders on usually with only Stored
Procedures being the only viable safe option.
The philosophy is that you have a function that is called and if you have:
TEXT TO mVar
ENDTEXT
Internally it translate to:
mVar := __TextWhatEver()
So the function internally will handled based on the parameter list what
needs to be done to the string.
On 2019/06/27 21:43, Stephen Ru
Hi John,
It is in the to-do list...
On 2019/06/27 22:45, John Weller wrote:
I think I would miss SCAN/ENDSCAN most.
John
John Weller
01380 723235
07976 393631
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscrip
I am backing off of licenses for SQL Enterprise down to Standard for 2/3 of
all my SQL Server usage in my new deployments. Use to have a total of 96
cores running Ent. and now seeing if we can only use 30. Having virtual
guests instead of a single bad ass box makes this a lot easier to do.
Dynam
Hi Steve,
I don't doubt your method is super secure, but this shows a difference
of approaches: you code heavily in the backend DB and as a result
everything is very rigid. If things were to need to be changed to a
different backend, then your project is most definitely a
heavier/longer/mor
TEXT...ENDTEXT is a door to SQL Injection Attacks as much as anything else
we put inside the ODBC tube.
LOCAL SQLStmt AS String
** Thisform.txtSearch.Value = "1 = 1; DROP TABLE Customers;"
TEXT TO m.SQLStmt NOSHOW TEXTMERGE
SELECT * FROM Customers<>;
ENDTEXT
** or
TEXT TO m.SQLStmt NOSHOW TEXT
** er more like Thisform.txtSearch.Value = "'ACME'; DROP TABLE
Customers;"
On Fri, Jun 28, 2019 at 4:03 PM António Tavares Lopes
wrote:
> TEXT...ENDTEXT is a door to SQL Injection Attacks as much as anything else
> we put inside the ODBC tube.
>
> LOCAL SQLStmt AS String
>
> ** Thisform.txtS
9 9:27 AM
To: profoxt...@leafe.com
Subject: Re: [NF] What would you miss from VFP, when migrating
I am backing off of licenses for SQL Enterprise down to Standard for 2/3 of
all my SQL Server usage in my new deployments. Use to have a total of 96
cores running Ent. and now seeing if we can only use
I was already doing that with the FP distribution tool kit from FP Dos days
and working with a custom db that the law firm had that was proprietary to
the system the firm had. They made an ODBC driver and I got data in and out
of it 93-96.
Mike, you see every problem as a nail and you apply the VF
in a TEXT/ENDTEXT
> construct and I think this example shows that
>
> Thanks!
>
> Paul H. Tarver
>
>
> -----Original Message-----
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Stephen
> Russell
> Sent: Friday, June 28, 2019 9:27 AM
> To: profoxt
"Use the best tool for the job"
In my travels and experiences with SMBs (and mostly Smalls!), I've been
able to generate very flexible code and (knock on wood) I've not been
"hacked" ever.
ymmv!
On 6/28/2019 11:21 AM, Stephen Russell wrote:
I was already doing that with the FP distribution
a TEXT/ENDTEXT
construct and I think this example shows that
Thanks!
Paul H. Tarver
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen
Russell
Sent: Friday, June 28, 2019 9:27 AM
To: profoxt...@leafe.com
Subject: Re: [NF] What would you miss f
oxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Stephen
Russell
Sent: Friday, June 28, 2019 9:27 AM
To: profoxt...@leafe.com
Subject: Re: [NF] What would you miss from VFP, when migrating
I am backing off of licenses for SQL Enterprise down to Standard for
2/3 of
all my SQL Server usage in
hich I can construct SQL statements in a
TEXT/ENDTEXT
construct and I think this example shows that
Thanks!
Paul H. Tarver
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Stephen
Russell
Sent: Friday, June 28, 2019 9:27 AM
To: profoxt...@leafe.c
different than mine. The point of my original comment was to
> > praise the ease with which I can construct SQL statements in a
> TEXT/ENDTEXT
> > construct and I think this example shows that
> >
> > Thanks!
> >
> > Paul H. Tarver
> >
> >
> > ---
Query
is greatly different than mine. The point of my original comment was to
praise the ease with which I can construct SQL statements in a
TEXT/ENDTEXT
construct and I think this example shows that
Thanks!
Paul H. Tarver
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun.
12:13 PM
To: profoxt...@leafe.com
Subject: Re: [NF] What would you miss from VFP, when migrating
To make your code safer, ensure you use parameters:
m.CompanyID = ALLTRIM(thisform.CoCode.value)
m.lcWhereClause = "WHERE emp.CpnyID = ?m.CompanyID"
Frank.
Frank Cazabon
On 28/06/2019 1
= '" +
> >>> ALLTRIM(thisform.CoCode.value)
> >>>
> >>>TEXT TO lcSQLCmd TEXTMERGE NOSHOW
> >>>SELECT
> >>> CAST(emp.CpnyID AS CHAR(20)) AS compid,
> >>> CAST(emp.EmpId AS CHAR(20))
>
> > > We accept and validate the selection of the CoCode by the user and then
> > we
> > > construct the "dynamic query." I suspect your perception of a Dynamic
> > Query
> > > is greatly different than mine. The point of my original comment was to
s I'm referring to something little like this (although
>most
>> are
>> >>> far more complicated queries with lots of moving parts):
>> >>>
>> >>>lcWhereClause = "WHERE emp.CpnyID = '" +
>> >>> AL
I have created a similar approach in .NET based on the
NameValueCollection class.
Basically have subclassed it and added Methods:
1. ReaderToCollection - A SQLquery and a DBF to collection
2. ToSql - Construct an UPDATE/INSERT query based on the collection
3. ToControls - Populate a Form with v
On Thu, 27 Jun 2019, at 1:52 PM, Johan Nel wrote:
> Hi VFPers
>
> I have asked this question on foxite too with very little feedback, so I
> am asking it here too.
> 1. Macro-compilation
The nature of .NET sort of removes the need for this but you have
ExpandoObjects and Reflection should you
On Thu, 27 Jun 2019, at 6:25 PM, Kevin Cully wrote:
> Another language command is the SCATTER NAME and GATHER NAME. The
> ability to create an object with properties that corresponds to each
> field of a record is incredibly useful
Pick any one of the many ORMs!
--
Alan Bourke
alanpbourk
On Thu, 27 Jun 2019, at 5:53 PM, Paul H. Tarver wrote:
> I would greatly miss the speedy import capabilities of Foxpro and the CREATE
> CURSOR to build temporary files to temporarily hold imported data
Well, assuming CSV:
Install https://joshclose.github.io/CsvHelper/
Then:
void Main()
{
us
On Thu, 27 Jun 2019, at 9:10 PM, Paul H. Tarver wrote:
> I use TEXT/ENDTEXT to create dynamic SQL Queries by merging static text and
> dynamic variables, then pass the resulting string to SQLEXECUTE. Very
> convenient when creating large query strings.
var table = "mytable";
var myfield = "field1
Hi Alan,
On 2019/07/01 10:46, Alan Bourke wrote:
The nature of .NET sort of removes the need for this but you have
ExpandoObjects and Reflection should you really want to. The
System.Dynamic namespace.
This is true and I have removed a lot of my macros used in Visual
Objects by use of Reflect
Install https://joshclose.github.io/CsvHelper/
Then:
void Main()
{
using (var reader = new StreamReader("path\\to\\file.csv"))
using (var csv = new CsvReader(reader))
{
var records = csv.GetRecords();
}
}
Which is as follows in X# with VFP syntax selected:
funct
On 2019/07/01 10:53, Alan Bourke wrote:
On Thu, 27 Jun 2019, at 9:10 PM, Paul H. Tarver wrote:
I use TEXT/ENDTEXT to create dynamic SQL Queries by merging static text and
dynamic variables, then pass the resulting string to SQLEXECUTE. Very
convenient when creating large query strings.
var tabl
I love me some ORM!
Snippet on making an object to be populated with data and saved. You can
pile in the Add() objects and then call the SaveChanges() once if you need
to. Such as N sales order detail lines.
public static void loadresp(String Plant, String respStr)
{
using (RingSecurityEnt
e the ease with which I can construct SQL statements in a
TEXT/ENDTEXT
construct and I think this example shows that
Thanks!
Paul H. Tarver
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Stephen
Russell
Sent: Friday, June 28, 2019 9:27 AM
To: p
gt; >>>>> build interfaces to move data between different systems. I am usually
> >>>>> provided with READ-ONLY SQL credentials so I can then issue SELECT
> >>>> queries
> >>>>> to extract data and then use the results of those queries to c
NDTEXT
lnStatus = SQLEXEC(lnSQLHandle, lcSQLCmd, "EmpList")
We accept and validate the selection of the CoCode by the user and
then
we
construct the "dynamic query." I suspect your perception of a Dynamic
Query
is greatly different than mine. The point of my origi
our perception of a
Dynamic
Query
is greatly different than mine. The point of my original
comment was
to
praise the ease with which I can construct SQL statements in a
TEXT/ENDTEXT
construct and I think this example shows that
Thanks!
Paul H. Tarver
-Original Message-
From: Prof
gt;>>>>
> >>>>>> On Fri, Jun 28, 2019 at 12:13 PM Frank Cazabon <
> >>> frank.caza...@gmail.com>
> >>>>>> wrote:
> >>>>>>
> >>>>>>> To make your code safer, ensure you use parameters:
>
election of the CoCode by the user and
then
we
construct the "dynamic query." I suspect your perception of a
Dynamic
Query
is greatly different than mine. The point of my original
comment was
to
praise the ease with which I can construct SQL statements in a
TEXT/ENDTEXT
construct
= ?m.CompanyID"
> >>>>>>>>
> >>>>>>>> What do you see in the entire statement you put together?
> >>>>>>>>
> >>>>>>>> If you run it against a SQL box does your table disapp
t")
We accept and validate the selection of the CoCode by the user
and
then
we
construct the "dynamic query." I suspect your perception of a
Dynamic
Query
is greatly different than mine. The point of my original
comment was
to
praise the ease with which I can construct SQL statement
56 matches
Mail list logo