Hi Christof
I would very much appreciate the full sample code. Many thanks.
In the meantime I have come up with this which works well enough
Lparameters tcPostCode
Local lcPostcode, lcHTML1, lcHTML2, lcHTML3, lcHTML, lcFile
Thisform.Caption = tcPostcode
lcPostcode = Strtran(tcPostcode, , +)
On Thu, Nov 29, 2012 at 10:31 PM, Paul McNett p...@ulmcnett.com wrote:
If it was for Janie Secretary, then why does the task scheduler report
errors with
numeric codes?
--
It protects their brand(s).
Otherwise it would present:
Foxpro f'ed up again.
--
Something like:
m.lcConnectionString = server=sageserver;Integrated
Security=SSPI;Persist Security Info=False;Initial Catalog=APAC
m.lnHandle = SQLSTRINGCONNECT(m.lcConnectionString,.T.) 2nd
parameter as .T., as the single-connection-per user, shared by remote views
*!*
Hi Steve
Because we have to send the customer a consolidated invoice, a branch breakdown
and an xls spreadsheet so I do it in foxpro and then email it across to them
automatically. They then get it into SAP.
Adam
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On
Cutting down what I've found / been showed I get:
set safety off
close all
LOCAL connectionString
connectionString = Driver={SQL
Server};Server=sageserver;Database=APAC;Uid=admin-account;Pwd=admin-pwd;
LOCAL sql
** sql8 = SELECT * from dbo.BOOKER
sql8 = SELECT * from
OK, localhost is working now. Thanks so very much to all who pitched in.
Of course when I upgraded Apple also deleted my PHP directory and with it
my configuration file. grumble One thing I did not think to back up.
On Thu, Nov 29, 2012 at 4:55 PM, Ken Kixmoeller (ProFox)
On Wed, Nov 28, 2012, at 07:36 PM, Ken Kixmoeller (ProFox) wrote:
(Apple must be
learning from M$ how to break everything on upgrades.)
Not much in that line happens in Windows these days. You need to look at
Ubuntu or something for that sort of shenanigans.
Your SQLEXEC must be failing (returning -1).
Use AERROR() to see what's failing on the SQL side.
Fred
On Fri, Nov 30, 2012 at 9:48 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Cutting down what I've found / been showed I get:
set safety off
close all
LOCAL connectionString
Thanks Fred,
Invalid object name... it works ok when I reference a table, so how do I
reference a view in SQL Server is there a magic secret or isn't it possible?
TIA Adam.
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Fred Taylor
Sent: 30
Try this:
lnSuccess = SQLEXEC(connHandle, sql8, 'MYTABLE')
IF m.lnSuccess = 0
AERROR(laError)
MESSAGEBOX(laError[3]))
ENDIF
Frank.
Frank Cazabon
On 30/11/2012 01:02 PM, Fred Taylor wrote:
Your SQLEXEC must be failing (returning -1).
Use AERROR() to see what's
On Fri, Nov 30, 2012 at 11:22 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Thanks Fred,
Invalid object name... it works ok when I reference a table, so how do I
reference a view in SQL Server is there a magic secret or isn't it possible?
SQL will either return rows or
Hi Stephen...
Inside SQL Server management Console it return 2,000 records and individually I
can access the tables from the SQL console
From FoxPro, I can access tables no problem but not a view... same code , put
in a table name rather than a view and bingo... change it to the view name and
Hi Adam,
Don't you need to be referencing dbo.M2M_Booker, not just dbo.Booker?
Brant
||
Cutting down what I've found / been showed I get:
set safety off
close all
LOCAL connectionString
connectionString = Driver={SQL
Server};Server=sageserver;Database=APAC;Uid=admin-account;Pwd=admin-pwd;
I renamed it just in case something silly with hyphens and underscores. try
and get it working as simply as possible then complicate it...
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Brant E. Layton
Sent: 30 November 2012 17:32
To:
On Fri, Nov 30, 2012 at 11:32 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Hi Stephen...
Inside SQL Server management Console it return 2,000 records and
individually I can access the tables from the SQL console
Great
You can preface the db name in the table in your select statement.
Adding the database name did it... Stephen you're a star.
Don't know why it worked as the view is in the right db area.. but it
does.. cheers...
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell
Sent: 30 November 2012 17:42
To: ProFox
There's usually also an option where you can specify the default database
as part of setting up a DSN or as part of your connectionstring.
On Fri, Nov 30, 2012 at 12:48 PM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Adding the database name did it... Stephen you're a star.
Don't know
On Fri, Nov 30, 2012 at 11:48 AM, Adam Buckland
adam.buckl...@eurohill.comwrote:
Adding the database name did it... Stephen you're a star.
Don't know why it worked as the view is in the right db area.. but it
does.. cheers...
-
If you track your user info I bet
In one of my apps, I'm putting in an option to copy some tables locally
and query there instead of the network. This will not only increase
performance (because this solution is a query-only solution...it's just
for reporting) but will allow the user to query while disconnected from
our
On Fri, Nov 30, 2012 at 12:06 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
snipped
Some of the tables involved do NOT have a timestamp field on them.
Are you wanting to compare the contents on a record by record basis,
or just are they different?
You said
On 11/30/2012 3:23 PM, M Jarvis wrote:
On Fri, Nov 30, 2012 at 12:06 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
snipped
Some of the tables involved do NOT have a timestamp field on them.
Are you wanting to compare the contents on a record by record
On Nov 30, 2012, at 2:32 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
Seems like a hash of some sort would be the way to go versus filetostr() but
perhaps not. OTOH, why not just compare the file's datetime stamp? If
difference found though, I could
I think you're on the trail. MD5 is meant to be a fast hash, as opposed
to slow hashing which should be used for salted passwords, such as BCrypt.
On 11/30/2012 03:32 PM, MB Software Solutions, LLC wrote:
On 11/30/2012 3:23 PM, M Jarvis wrote:
On Fri, Nov 30, 2012 at 12:06 PM, MB Software
MB Software Solutions, LLC wrote on 2012-11-30:
In one of my apps, I'm putting in an option to copy some tables locally
and query there instead of the network. This will not only increase
performance (because this solution is a query-only solution...it's just
for reporting) but will
On 11/30/2012 3:34 PM, Ed Leafe wrote:
On Nov 30, 2012, at 2:32 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
Seems like a hash of some sort would be the way to go versus filetostr() but perhaps
not. OTOH, why not just compare the file's datetime stamp?
On 11/30/2012 3:43 PM, Tracy Pearson wrote:
If there isn't too many fields, and no Memo field.
Union them together to screen noconsole. If the RECCOUNT() = _TALLY then
they are the same.
If you didn't do a file copy of the file to the local machine, the headers
will have different time stamps.
I am also searching, but I thought Ed, Ted might give me another clue.
Apache is running and reasonably-well configured, PHP is running, but as
soon as it hits a reference to one of my script files, I get an error: No
Permission to the containing directory.
How do I give Apache permission to gain
On Nov 30, 2012, at 3:12 PM, Ken Kixmoeller (ProFox)
foxh...@information-architecture.com wrote:
How do I give Apache permission to gain access to the directories
containing my code? I tried chmod with full permissions and that did not
help.
You might need to use 'chown' to change
SInce these are DBFs, why don't you use the LUPDATE() function? DBFs know
when they were last changed.
On Fri, Nov 30, 2012 at 3:06 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
In one of my apps, I'm putting in an option to copy some tables locally
and
Pretty Cool Stephen! For the heck of it - I plugged in meteor crater -
and it went there pretty darned quick. I've been there myself on 2
occasions. For those that have never heard of it - check it out!
-K-
On 11/30/2012 3:05 PM, Stephen Russell wrote:
http://www.qsview.com/
On Fri, Nov 30, 2012 at 3:25 PM, Ed Leafe ed.le...@rackspace.com wrote:
You might need to use 'chown' to change the owner to the user that
apache is running as.
OK, I'll go to try to figure out that. I remember the configuration file
saying the owner group
I like a mystery, but
OK, instead of chown, I changed the user and group of Apache in the
configuration file. It worked!
Hoop-de-do!
Next step: I am going to have a beer. Maybe a nice IPA. Friday reward.
Thanks again to all
HAGW, everyone.
Ken
On Fri, Nov 30, 2012 at 4:22 PM, Ken Kixmoeller (ProFox)
Does anyone have any suggestions for implementing SFTP in vfp?
Cheap/free preferred, but not required. I'll check again, but I'm
pretty sure my goto for Internet, West-Wind, doesn't do SFTP.
Not urgent, just would like to avoid active-x and stick to native VFP or
open source if possible.
We use the PuTTY suite for ssh and scp, which is scriptable via a RUN
command.
http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html
On Fri, Nov 30, 2012 at 7:29 PM, Vincent Teachout tea...@taconic.netwrote:
Does anyone have any suggestions for implementing SFTP in vfp? Cheap/free
On 11/30/2012 4:30 PM, Ted Roche wrote:
SInce these are DBFs, why don't you use the LUPDATE() function? DBFs know
when they were last changed.
COOL! You're the expert on these things...is it using something in the
Header of the DBF to know this or just the file system date/time?
--
Mike
On 11/30/2012 8:33 PM, MB Software Solutions, LLC wrote:
On 11/30/2012 4:30 PM, Ted Roche wrote:
SInce these are DBFs, why don't you use the LUPDATE() function? DBFs know
when they were last changed.
COOL! You're the expert on these things...is it using something in the
Header of the DBF to
+1
Original Message
Subject: Re: Any Non-ActiveX solutions for SFTP in VFP?
From: Ted Roche tedro...@gmail.com
To: profoxt...@leafe.com
Date: 11/30/2012 6:39 PM
We use the PuTTY suite for ssh and scp, which is scriptable via a RUN
command.
Hi Everybody,
http://video.foxbusiness.com/v/1995183710001/check-out-new-volkswagen-beetle?intcmp=related
There he goes, he's trading . . .
--
Regards,
Pete
http://pete-theisen.com/
http://elect-pete-theisen.com/
___
Post Messages to:
38 matches
Mail list logo