Thank you for that, Michael. ;^)
On 4/16/2014 7:07 AM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
Just reflecting on the mysteries of the day. I was almost tempted to
get out and run to the computer to say "OH I GET IT NOW" lol
On 2014-04-16 09:55, Jeff Joh
/CONTROL. Duh
Yeah...I was right...blonde moment That's what I get for coming
into the conversation late (or at least that's my excuse and I'm
sticking to it). lol
On 2014-04-15 16:23, Jeff Johnson wrote:
You are blonde if I remember correctly. ;^) The smallest width for
moment: 123-45-6789. With the format and
inputmask, wouldn't 9 suffice?
On 2014-04-15 16:15, Jeff Johnson wrote:
Michael: Fit your social security in a textbox txtssan.width = 9 ;^)
On 4/15/2014 1:20 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
On 2014-04-15 15:06, ka
Michael: Fit your social security in a textbox txtssan.width = 9 ;^)
On 4/15/2014 1:20 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
On 2014-04-15 15:06, kamcgin...@gmail.com wrote:
90 is correct for the Width property
Is that because you're encrypting it so hence the wider field
.format - "KRLZ" is even better. Shows a blank of no social security
number.
On 4/14/2014 6:23 AM, Jeff Johnson wrote:
.format - "KRL" does the trick. The reason I don't change to a string
is because this application is many years old and deployed in numerous
locati
rs does not.
On 4/12/2014 8:56 AM, Vincent Teachout wrote:
Jeff Johnson wrote:
Greetings: I have a text box who's control source is a social
security number stored as a number. Obviously I have done this for
years. Yesterday it was brought to my attention that the leading
zero messed up the fo
P9 SP2
I have a text box on a form I named txtcSSN
It has a control source: vnmpt.cssn which is a view for a table with the
field named cSSB C(9)
The input mask is 999-99- (same as yours)
The width is 90
Mine works the way you want. Not sure why yours does not.
On 4/12/2014 8:56 AM, Vinc
- (same as yours)
The width is 90
Mine works the way you want. Not sure why yours does not.
On 4/12/2014 8:56 AM, Vincent Teachout wrote:
Jeff Johnson wrote:
Greetings: I have a text box who's control source is a social
security number stored as a number. Obviously I have done thi
I am using an
input mask of 999-99-.
What do I need to do to fix this.
-- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. 623-582-0323 Fax
623-869-0675 http://www.san-dc.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
Sytze: Seems I run into similar situations. I know this is probably
not how you want to run it, but to see what the problem is have you
tried decrypting the different table in the folder that works with the
encrypting?
On 4/11/2014 11:42 AM, Sytze de Boer wrote:
Ted, thank you. You were co
n try to decrypt, I get an error with
API call caused an exception
Am I doing something wrong ?
I have used that extensively with no problems. What kind of exception
are you getting?
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-d
trial licenses before I bought the full version.
Regards
Ajit Abraham
On 4/10/2014 1:03 AM, Jeff Johnson wrote:
We talked the other day about a scanner that could be used within VFP. I
have a form that is on a client's document page. I would like to press
a button and have it scan a documen
. Can
anyone recommend a feed scanner that will play nice with VFP? Make model
& year?
TIA
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-dc.com
___
Post Messages to: ProFox@leafe.com
Sub
, Ted Roche wrote:
When you run:
c:\Windows\SysWOW64\odbcad32.exe
you should see the correct 32-bit ODBC administrator.
Go to the Drivers tab.
Do you see drivers for Office?
On 04/08/2014 02:13 PM, Jeff Johnson wrote:
Dennis: That is what I was doing. It appears something is not
install
Unfortunately support for cheese ends today!
On 4/8/2014 11:10 AM, Mike Copeland wrote:
Jeff Johnson wrote:
I can't believe the amount of time spent getting things to work
on Windows 8 that worked fine on Windows 7! ODBC, Remote Desktop,
simple network connections. Sheesh!
...whi
e.den...@gmail.com
Yuma, AZ 85364 Map it
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen
Russell
Sent: Tuesday, April 08, 2014 10:59 AM
To: profoxt...@leafe.com
Subject: Re: [NF] Excel 2003 on Windows 8
foxtech-boun...@leafe.com] On Behalf Of Jeff Johnson
Sent: Tuesday, April 08, 2014 12:37 PM
To: profoxt...@leafe.com
Subject: Re: [NF] Excel 2003 on Windows 8
Okay, I found VFP ODBC drivers and installed them. Now it works with the below
connection string with one slight problem
lnsql
the O2003 installation media.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson
Sent: Tuesday, April 08, 2014 11:04 AM
To: profoxt...@leafe.com
Subject: Re: [NF] Excel 2003 on Windows 8
Allen: I saw that but did not understand what I
On 4/8/2014 8:02 AM, Ted Roche wrote:
On 04/08/2014 10:42 AM, Jeff Johnson wrote:
I am trying to test an application the imports an Excel spreadsheet on
Windows 8.
So, a Visual FoxPro application, right?
Yes
It won't work because Windows 8 has two ODBC Managers.
All 64-bit Windows sy
oft.com/kb/2721825/EN-US
does that help?
Al
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff
Johnson
Sent: 08 April 2014 16:56
To: profoxt...@leafe.com
Subject: Re: [NF] Excel 2003 on Windows 8
Yes, this is Office 2003 32 bit.
--
Jeff
Jeff Johnso
Behalf Of Jeff Johnson
Sent: Tuesday, April 08, 2014 10:42 AM
To: profoxt...@leafe.com
Subject: [NF] Excel 2003 on Windows 8
I am trying to test an application the imports an Excel spreadsheet on Windows
8. It won't work because Windows 8 has two ODBC Managers. The
32 bit manager has all o
need to use a different connection string? Has anyone noticed that
Office 2003 support ends today too?
this has been working for me all along:
lnsqlhandle = SQLSTRINGCONNECT("Driver={Microsoft Excel Driver (*.xls,
*.xlsx, *.xlsm, *.xlsb)}; DBQ=" + lcspreadsheet + ";")
On 3/29/2014 7:52 AM, Gianni Turri wrote:
On Fri, 28 Mar 2014 09:48:04 -0700, Jeff Johnson wrote:
Anyone have good luck with scanning directly into VFP? I read a post by
Mike Lewis (I think it is) that used EZTWAIN which is now $999! I
understand that many TWAIN devices can be programmed
Vince: I noticed that EZTwain was about $200 not too long ago.
Thanks for your input.
On 3/28/2014 2:21 PM, Vincent Teachout wrote:
Jeff Johnson wrote:
Anyone have good luck with scanning directly into VFP? I read a post
by Mike Lewis (I think it is) that used EZTWAIN which is now $999! I
On 3/28/2014 10:18 AM, Tracy Pearson wrote:
Jeff Johnson wrote on 2014-03-28:
Anyone have good luck with scanning directly into VFP? I read a post by
Mike Lewis (I think it is) that used EZTWAIN which is now $999! I
understand that many TWAIN devices can be programmed.
I am
Anyone have good luck with scanning directly into VFP? I read a post by
Mike Lewis (I think it is) that used EZTWAIN which is now $999! I
understand that many TWAIN devices can be programmed.
I am interested in your ideas.
Thanks,
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582
I saved it as a bmp and finally added it as a picture and was able to
size it with adequate quality.
So no worries.
On 3/26/2014 11:47 AM, Jeff Johnson wrote:
I have a .doc with a border on it. I want to make that border the
border on a report (.frx). When I save as a .bmp or .jpg and try
TIA
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-dc.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list:
On 3/24/2014 4:19 AM, Alan Bourke wrote:
On Sun, Mar 23, 2014, at 04:18 PM, Jeff Johnson wrote:
Is there a down side to disabling SMB2
You probably can't and if you could probably wouldn't want to.
The situation is that the SMB version used is negotiated depending on
server and
wn side to disabling SMB2 when Modern Windows 8 machines
are on the network?
TIA
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-dc.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: h
+1 for encrypting fields. I still use something Mac Rubel wrote many
years ago.
On 3/12/2014 2:33 PM, Ted Roche wrote:
John:
Your intentions are good, but I don't think this goes far enough. Every
application on the machine (or the network, if the location is shared) can
read the dbf while i
is your motivation. Mine is strictly financial
and as someone mentioned dealing with SanDC, Inc. is preferred to Jeff
Johnson (assuming that is his real name).
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-06
Like I mentioned earlier, too much to go into here... but... Each
state has different rules and each individual has different situations.
There are depreciation, local codes, and costs for incorporation to
mention a few. That is why I suggest speaking with an accountant in
your area. I hav
likely do the same for you Jim.
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-dc.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-f
Webroot Secure Anywhere was installed on the two computers that won't
paste into VFP. You can, however paste into everything else that we tested.
On 3/4/2014 1:51 PM, Jeff Johnson wrote:
I have a customer that reports paste not working. We determined by
testing that cut/copy works
about installing software that my use CTRL-V for something,
but haven't heard back yet.
Any ideas?
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-dc.com
___
Post Messages to: ProFox@leafe.com
Su
I have been using OO for many years. Currently it seems to do better on
things like xlsx than others. I tried LibreOffice on Ubuntu and it
seemed like every document became corrupt and it kept freezing up.
Unacceptable for my use. Office is good if you have a AAA membership.
;^) (to get a
I like Windows 8 over Windows 7 for performance, but I have had a lot of
issues with Windows 8 regarding small business networking and remote
desktop. It is mainly due to security controls that I can't find. The
interface needs to be configured to work like a computer instead of a phone.
I h
*:* lasting one day only
2
*:* lasting a very short time
Other kinds of software (and hardware) are as basic, and enduring
Like order processing, inventory control, line-of-business applications.
Agreed.
Just helping out. ;^)
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax
Primary:
den...@cbsds.com
350 West 16th Street, Suite 309 Alternate:
schuette.den...@gmail.com
Yuma, AZ 85364 Map it
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On
Greetings: I have used a number of tools to convert a PDF to CSV with
no success. Has anyone found a Windows application that can do PDF to
CSV conversions reliably? Paid application does not matter at this point.
Thanks,
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax
Malcolm: We use Mac and Ubuntu here, but unfortunately the only way to
really work with my development system is Windows. I RDP into it.
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-dc.com
On 2/13/2014 1:08 PM, Vincent Teachout wrote:
Jeff Johnson wrote:
Tracy: I found it, but the reason I was looking for it was I was on
a conference call with 10 people from Arizona to India and places in
between and a loud video started in my browser. Yikes!
"WELCOME TO THE FIRST
On 2/13/2014 1:01 PM, Paul Hill wrote:
On 13 February 2014 14:28, Alan Bourke wrote:
On Thu, Feb 13, 2014, at 02:08 PM, Jeff Johnson wrote:
Alan, have you had any issues with using Windows 8 as the host?
Nope, although not too many of our customers have any Windows 8 and we
don't in
On 2/13/2014 11:52 AM, Ted Roche wrote:
On Thu, Feb 13, 2014 at 12:16 PM, Jeff Johnson wrote:
Which leads me to the thought... XP is no longer going to be supported so
upgrade to Windows 8. H.
Why not Win7? It will also be supported for a while, and you won't have the
avorite TV show!
http://www.bbc.co.uk/cult/hitchhikers/
-- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. 623-582-0323 Fax
623-869-0675 http://www.san-dc.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/lis
agree, but most users out there are upgrading because of it.
IT guys & gals (hardware) are encouraging it.
Yeah. People that don't know the answer is 42. ;^)
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
ht
using it on the advice that
they upgrade from XP.
Which leads me to the thought... XP is no longer going to be supported
so upgrade to Windows 8. H.
I totally agree, but most users out there are upgrading because of it.
IT guys & gals (hardware) are encouraging it.
-- Jeff Jeff Johns
talking about me? But then as I explained I am a user
and I am using it and most of my users are using it on the advice that
they upgrade from XP.
Which leads me to the thought... XP is no longer going to be supported
so upgrade to Windows 8. H.
--
Jeff
Jeff Johnson
j...@san-dc.com
San
m I have been having is working with
networks and remote access.
-- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. 623-582-0323 Fax
623-869-0675 http://www.san-dc.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.
On 2/13/2014 9:23 AM, Tracy Pearson wrote:
On February 13, 2014 11:09:54 AM EST, Jeff Johnson wrote:
On 2/13/2014 9:02 AM, Alan Bourke wrote:
This about sums it up for me:
"It doesn't do a thing to address the fact that Windows isn't a
single
OS. It's two of them
ention. It is the user interface that is all over the
board. I have to Google just about everything.
Quick, how do you turn down the sound?
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-dc.com
_
pport all of my users that are upgrading to Windows 8 and
I can't get my software running as it was without a ton of effort?
"There are none so blind as those that wait and see - and then do it
anyway." ~ Jeff Johnson
-- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. 623-582
host?
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-dc.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list:
On 2/13/2014 5:34 AM, Ted Roche wrote:
On Wed, Feb 12, 2014 at 5:00 PM, Jeff Johnson wrote:
The more I work with Windows 8, the more I wonder what they were trying
to accomplish?
Clearly they wanted to build the iPod-Android-iPhone-Nexus-Playstation
killer. With the One Bling to Rule
On 2/13/2014 2:34 AM, Paul Hill wrote:
On 12 February 2014 23:25, Paul McNett wrote:
On 2/12/14 1:16 PM, Jeff Johnson wrote:
Am I missing something?
Only that Microsoft software is a big waste of effort.
1) download TightVNC, install as windows service
2) make sure it added a windows
On 2/12/2014 3:54 PM, Tracy Pearson wrote:
On February 12, 2014 5:32:44 PM EST, Paul Hill wrote:
On 12 February 2014 21:16, Jeff Johnson wrote:
I am at my wits end - again! I have spent hours and hours trying to
set up
Windows 8.1 as a host for RDT.
Silly question: Are you running Win8
ar to work fine.
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-dc.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of
On 2/12/2014 2:54 PM, Ted Roche wrote:
On Wed, Feb 12, 2014 at 4:16 PM, Jeff Johnson wrote:
I am at my wits end - again!
I'm finding, for me, it's getting to be a shorter and shorter walk. :)
Am I missing something?
Are any of the other clients you connect to Windows 8.1
Have y
s
on the same network. I have a static IP set and it is outside of the
DHCP range. By all rights it should be working but it is not. I can
ping it. It says the computer is not connected. I can RDT from the W8
machine into the W7 machine no problem.
Am I missing something?
--
Jeff
Jeff John
tried the old cable and it
works fine. In fact, the phone came with the old style cable and an
auto adapter. It powers and/or transfers data. I'm not sure what value
that new style cable offers other than it is wider and more stable?
On 2/11/2014 9:06 AM, Jeff Johnson wrote:
On 2/10/2014
! If you are using a thumb
drive, do you need to do something to remove it safely?
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-dc.com
___
Post Messages to: ProFox@leafe.com
Subscription Mainte
would like to do what you are doing. The power
cable is unique to the Note3. It is a split connector and has a female
USB on the other end. What did you do to connect it to a USB drive?
Thank you in advance.
ps. What is your first name?
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623
.e., cloud based)? Experience preferred.
Thanks in advance!
Mike Copeland
-- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. 623-582-0323 Fax
623-869-0675 http://www.san-dc.com
___
Post Messages to: ProFox@leafe.com
Subscription Mainten
count. So I removed the Windows Live account (saving the files)
and added a local account. Then I transferred all of the profile files
from the former to the later and all is well, including accessing my
server. Even though my server had "Jeff Johnson" as a user, the Windows
Live use
I restarted the machine, I have all of the network stuff set up. I can
access all of the other computers on the network, just not the file
server. I noticed it is a Windows Live Account rather than a local
account. But why can I access all of the other computers? And why did
it start today
Yes, Alan.
On 1/30/2014 7:08 AM, Alan Bourke wrote:
Can you ping it?
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.san-dc.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http
matter what I try, it says I do not have permissions to access the
server. It won't even let me enter a user ID or password.
What's up with this?!?
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
http://www.
On 1/24/2014 6:32 AM, Frank Cazabon wrote:
On 24/01/2014 09:23 AM, Jeff Johnson wrote:
Frank: How much is your retainer? Not $ amount but in relation to
the entire project? My friend the CPA does that. If you pay the
retainer you get preferred service. If you don't, you go last.
k: How much is your retainer? Not $ amount but in relation to the
entire project? My friend the CPA does that. If you pay the retainer
you get preferred service. If you don't, you go last.
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-06
Basically anything that is was caused or requested by the
customer is billed. I also have an annual support charge after the
first year that is basically for upgrades, that is optional. They can
pay for the agreement or pay as you go.
HTH
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
62
o
another? Or do I need to acquire a VFP9 CD?
TIA
--
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtracker.com>
www.arelationshipmanager.com <http://www.arelationshipmanager.com>
--- StripM
nks,
Jeff
-------
Jeff Johnson
j...@san-dc.com
(623) 582-0323
www.san-dc.com
www.arelationshipmanager.com
On 01/16/2014 07:16 PM, Kurt @ VR-FX wrote:
OK - here's my thoughts on this -and its just a suggestion -not that I
have done it.
You could post an Ad on Craigslist - in the Gigs are
On 1/16/2014 12:29 PM, M Jarvis wrote:
On Thu, Jan 16, 2014 at 11:10 AM, Jeff Johnson wrote:
Does anybody have any advise on
how to find a competent network / IT person in light of all of these
entremanuers?
--
I don't mind expensive so much - it's incompetent that really annoy
e and ended up firing him and doing it myself. Does
anybody have any advise on how to find a competent network / IT person
in light of all of these entremanuers?
--
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracke
drive first when troubleshooting freezing up.
Thanks,
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtracker.com>
www.arelationshipmanager.com <http://www.arelationshipmanager.com>
On 1/16/201
Andy: NAS is a different animal. He says it's just the plain old
external drives.
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtracker.com>
www.arelationshipmanager.com <http://www.arel
a trip to the shop. He says the first thing he looks at in a
situation like this is an external hard drive. He also said that if you
swap external drives about every two weeks you will not experience
this. The computer is back in its spot and working great.
FYI
--
Jeff
Jeff Johnson
SanDC
Paul: Do you think if I put a timer in my app and opened up a table on
the server and closed it ever five minutes that would keep the
connection alive?
Jeff
---
Jeff Johnson
j...@san-dc.com
(623) 582-0323
www.san-dc.com
www.arelationshipmanager.com
On 01/11/2014 11:46 AM, Paul
the laptop disconnects from the LAN for some reason and they
are dead in the water. Any ideas where I should start looking? HD
going to sleep? Anything like that?
TIA
--
Jeff
-------
Jeff Johnson
j...@san-dc.com
(623) 582-0323
www.san-dc.com
www.arelationshipm
Malcolm: I use http://www.code42.com/crashplan/. Like you I looked at
a lot. I also read the comparisons. I have been using this for about
two years. Works fine and I can get my files when I need them easily.
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.
Richard: Please send it to me. Craig is a good friend of mine, but
that is a good idea to ask him if you could upload it.
Thanks,
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtr
ally appreciate your help!
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtracker.com>
www.arelationshipmanager.com <http://www.arelationshipmanager.com>
On 1/3/2014 3:43 PM, Frank Cazabon wrote:
Thanks Frank. I did not know that! I've been putting in the ";" forever.
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtracker.com>
www.arelationshipmanager.com <http://www.arel
Okay. Thanks Fred. It sure worked for me.
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtracker.com>
www.arelationshipmanager.com <http://www.arelationshipmanager.com>
On 1/3/2014 11:
Thanks Fred! I was not aware I could use AERROR(), but it gave me the
answers I needed. I am guessing a TRY CATCH would work here too?
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtr
That helped a lot!!!
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtracker.com>
www.arelationshipmanager.com <http://www.arelationshipmanager.com>
On 1/3/2014 9:35 AM, Dave Crozier wrote:
Frank: It is not working and of course all I get is a -1 returned.
Should there be ";" line continuations in there? Also, any reason why
you put the commas in front instead of behind the varuable?
TIA
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://w
On 1/3/2014 6:44 AM, Gérard Lochon wrote:
- Original Message - From: "Jeff Johnson"
To:
Sent: Friday, January 03, 2014 2:29 PM
Subject: Re: SQL Insert - Solved
Sorry to bother you guys with this one. I should have known. I
expected that records inserted in sequenc
Frank's
improved way of building the query strings.
Thanks all.
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtracker.com>
www.arelationshipmanager.com <http://www.arelationshipmanager.com>
That makes sense. Thank you Frank. I am also guessing it would be
faster. What I am seeing could be the result of a timing issue. I am
going to check this morning to see if the records that are missing are
reproducible.
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <h
ot; + wkmimark + "', " + ;
"'" + wkweight + "', " + ;
"'" + wkquant + "', " + ;
"'" + wkhook1 + "', " + ;
"'" + wkpaycode + "', "
Fred: Nope. It is skipping inserting records into the SQL table.
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtracker.com>
www.arelationshipmanager.com <http://www.arelationshipmanager.com&g
HNY Steve! I have no control over the SQL Server table. If an index is
auto generated and you place a value in there, what happens?
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtr
HNY Fred! Set deleted is on but there are no deleted records in the
source table. There is no active filter and no index file.
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtr
don't know if it skipped the records or my subsequent query is not
selecting all of the records.
Any ideas?
--
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtracker.com>
www.arelationship
h the rough parts.
I look forward to working with all of you next year!!!
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtracker.com>
www.arelationshipmanager.com <http://www.arelationshipmanager.co
What wrapping it in a try catch does is allows it to terminate normally
after the error occurs. That's what I was looking for. A way to have
the object gracefully go through it completion after an error occurred.
I always release my objects immediately after using them.
Jeff
Jeff Jo
Thanks for all your help! The main method in the class is
dodatacall(). I wrapped the entire process in a try catch and I get my
error message and it gracefully exits the method.
Thanks!
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.
object = .NULL.
release object
is what I do all the time. The situation here is that the error occurs
inside the object. Can you release an object in its error method?
Jeff
Jeff Johnson
SanDC, Inc.
(623)-582-0323
www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com
401 - 500 of 2058 matches
Mail list logo
