From: Graham Brown grah...@compsys.co.uk
I reckon they are just being a little lazy so instead of choosing the
search from a combobox they just leave it set at any field.
You could restrict the search using a dictionary of skeletons.
For example, if the criteria is SMITH [ formal A(5)] ,
UnFoxAll has done it for me in the past.
On Mon, Feb 11, 2013, at 06:51 PM, Desmond Lloyd wrote:
Does anyone know if it is posslbe to decompile a password protected
FXP? Have inherited a rather old project. It would seem that all but
this
one file is not password protected
Regards,
I have some data in the form of an Excel spread sheet which I want to import
into a table. The problem is that one column has some entries that are more
than 254 characters. I want to import that into a memo field but APPEND
does not support appending into memo fields and APPEND MEMO appears to
John,
Automation is your friend here...
If you need an assist then shout...
Dave
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of John Weller
Sent: 12 February 2013 10:44
To: profox@leafe.com
Subject: Import From Excel
I have some data in the form of an
+1 for UnfoxAll ... just make sure you get the right version... There are many
virussed versions around. If I had my copy at hand I'd email it to you but it
is archived somewhere so safe I can't find it!
Dave
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf
This is some simple code from one of my projects for importing XL.
The aNVL function is just a wrapper to NVL to check for null values.
oXL=Createobject(Excel.Application)
oWB=oXL.Workbooks.Open(cfilename)
oWB.Sheets(Sheet1).Select()
oWS=oWB.ActiveSheet
nMax=0
nrow=0
For Each oRow In oWS.Rows
Thanks Everyone for your input... Found a copy yesterday, got it
registered. Tried decompiling my file but was a little confused with the
instructions. Long day yesterday, project deadline today Will jump
on it tommorrow
Thanks Again for all the help!
Regards,
Desmond
On 12
Have you tried passing the values as parameters instead?
For example
Select * from mytable where myvalue=1
Then
Select * from mytable where myvalue=2
Wont be optimised by sql server
But
Lnvalue=1
Select * from mytable where myvalue=?lnvalue
Lnvalue=2
Select * from mytable where
Hi gang
I'm having an issue on windows 8 pro and a web calling a VFP9 dll. The dll
in class format works fine called from a screen. But when called from
ASP.net c# form it fails to open a table and corrupts it. I have the web
application set as Network Service. I have a similar service
Further thought. This table is bigger (@ 30meg) than other tables that open
ok.
Al
-Original Message-
From: Allen
Sent: Tuesday, February 12, 2013 5:17 PM
To: profoxt...@leafe.com
Subject: problems with dll
Hi gang
I'm having an issue on windows 8 pro and a web calling a VFP9 dll.
Allen wrote on 2013-02-12:
Hi gang
I'm having an issue on windows 8 pro and a web calling a VFP9 dll. The
dll
in class format works fine called from a screen. But when called from
ASP.net c# form it fails to open a table and corrupts it. I have the web
application set as Network
If you are using any .Net calls in the dll then check the Service pack levels
on the machines it is working on compared to the one where it isn't.
Dave
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Allen
Sent: 12 February 2013 16:18
To: Profox
Subject:
good point. will try
Al
Allen,
Have you created the COM object in VFP and tested it? Does it corrupt the
table the same way?
Tracy Pearson
PowerChurch Software
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
All the same machine, well laptop as I.m away from the office. I do have a
win7 laptop with me. If all else fails I can try that
Al
-Original Message-
From: Dave Crozier
Sent: Tuesday, February 12, 2013 5:40 PM
To: profoxt...@leafe.com
Subject: RE: problems with dll
If you are using
Al,
Sorry, thought you'd created the DLL in say C# not VFP. That particularly SP
level bug has bitten me a few times, hence the suggestion
Dave
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Allen
Sent: 12 February 2013 16:43
To: profox@leafe.com
Subject:
ok tried from VFP with createobject and it also fails there. this is weird.
I even kept the table open to see as it was shared. Could see the table ok
after but once closed it would not open again. Well that means its not IIS
anyway.
Al
-Original Message-
Have you created the COM
Looks like I need to look further into this. I created a simple function in
the dll to open the table and return the first field value and it works.
Anyway dinner time so tomorrow is another day.
Al
Have you created the COM object in VFP and tested it? Does it corrupt the
table the same way?
Allen wrote on 2013-02-12:
ok tried from VFP with createobject and it also fails there. this is
weird. I even kept the table open to see as it was shared. Could see
the table ok after but once closed it would not open again. Well that
means its not IIS anyway. Al
Allen,
What version
all my pc's have the latest sp2 plus all fixes 7423.
Al
-Original Message-
Allen,
What version is your VFP9R.DLL and VFP9T.DLL on that box?
I use this versions.cmd file to determine them and their locations
@echo off
echo dim fsovfpgetver.vbs
echo set
Allen pro...@gatwicksoftware.com wrote:
all my pc's have the latest sp2 plus all fixes 7423.
Al
I've seen odd things when the VFP9T.DLL did not match the VFP9R.DLL. So I
suggested it.
--
Tracy
___
Post Messages to: ProFox@leafe.com
Subscription
Hey Folks,
Well, I was trucking right along on this Screen Hacking Utility I have been
working on. And, of course, my Boss just LOVES to see the progress - when I
show updated versions of a screen that I converted using this method - and
gave the screen basic functionality - allowing it to
IIRC, in addition to the memo field that contains the method code, there's a
column in the SCX where the property and method names are all stored. Methods
are preceded with an asterisk.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt
Reserved3 in the first record of the SCX.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Tuesday, February 12, 2013 2:49 PM
To: profoxt...@leafe.com
Subject: RE: More Screen Hacking Custom Methods...
IIRC, in addition to
Hey there RK - thank you SO MUCH for that Pointer! You the ProFox list
Save my Butt again!
I looked around - and, yeah - I saw it occur in this Reserved3 field - as
they appeared when I created 2 Dummy Methods when in Form Designer!
So - Thanks again!
-K-
-Original Message-
From:
Ha - this time I beat you to it!
:-)
But - yeah - that's what I found. The more I do this Screen Hacking stuff -
the more I find it to be a rather interesting diversion - and fun to do -
especially getting PAID to do it!
-K-
-Original Message-
From: ProfoxTech
On 02/12/13 09:59 AM, Tracy Pearson wrote:
What version is your VFP9R.DLL and VFP9T.DLL on that box?
I use this versions.cmd file to determine them and their locations
@echo off
echo dim fsovfpgetver.vbs
echo set fso=createobject(scripting.filesystemobject)vfpgetver.vbs
echo wscript.echo
Dan Covill wrote on 2013-02-12:
On 02/12/13 09:59 AM, Tracy Pearson wrote:
What version is your VFP9R.DLL and VFP9T.DLL on that box?
I use this versions.cmd file to determine them and their locations
@echo off
echo dim fsovfpgetver.vbs
echo set
Hey there Richard,
Sorry to be such a Tool - and come up with yet another related problem!
But...
So - I take these 2 procedures - and I got them loaded into the Method code
- and I also have that Reserved3 field updated with Both of the procedure
names. And, I can even see the code in the
Kurt wrote on 2013-02-12:
Hey there Richard,
Sorry to be such a Tool - and come up with yet another related problem!
But...
So - I take these 2 procedures - and I got them loaded into the Method
code
- and I also have that Reserved3 field updated with Both of the procedure
Hey there Tracy,
About a missing Char, well, I already add in at the end - a Chr(13) +
Chr(0), which I've already been doing for the Methods property - and it
should supposedly work for the Reserved3 field as well - I AssUMe - since
its also a Memo field. But, of course, I could be wrong about
Kurt wrote on 2013-02-12:
Hey there Tracy,
About a missing Char, well, I already add in at the end - a Chr(13) +
Chr(0), which I've already been doing for the Methods property - and it
should supposedly work for the Reserved3 field as well - I AssUMe - since
its also a Memo field.
On Tue, Feb 12, 2013 at 5:11 PM, Kurt k...@isssusa.com wrote:
About a missing Char, well, I already add in at the end - a Chr(13) +
Chr(0), which I've already been doing for the Methods property - and it
should supposedly work for the Reserved3 field as well - I AssUMe - since
its also a
I'm pretty sure that each bit has to be grouped together in that column (i.e.
all properties together followed by all methods together).
Rick's HackCX tool is invaluable for getting your head wrapped around how all
this stuff fits together.
--
rk
-Original Message-
From: ProfoxTech
Is there any way to change the font size for all code in prgs forms in a
project?
Ajoy Khaund
On Thu, Feb 7, 2013 at 10:21 PM, Dave Crozier da...@flexipol.co.uk wrote:
Tahoma
Dave C
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of MB Software
Ajoy Khaund akha...@gmail.com wrote:
Is there any way to change the font size for all code in prgs forms
in a
project?
Ajoy Khaund
Since you have modified the code, the setting is stored in the foxuser table.
Figure out how to change it, delete it, or write a little program that will
tools options IDE override individual settings
Thierry Nivelet
FoxinCloud
Give your VFP app a new life in the cloud
http://foxincloud.com/
Le 12 févr. 2013 à 20:46, Ajoy Khaund a écrit :
Is there any way to change the font size for all code in prgs forms in a
project?
Ajoy Khaund
36 matches
Mail list logo