Hi,
I think it is worthwhile to study the procedures developped by Vilhelm to
export, import or append from for XLSX and XLS files. To transport an memo
field with >254 char into Excel is no problem at all, the limit for a memo
is not # of characters but the size in KB.
Vilhelm's blog and coding
Me too!
Gianni
On Fri, 3 May 2019 22:23:09 +0200, Koen Piller wrote:
Received the same message. Clicked on the option to stay tuned and all
seems ok
Koen
Op vr 3 mei 2019 om 22:21 schreef Charlie-gm
> Not sure what is going on. I got a weird message the other day saying my
> account has
I use my Gmail account for this list. I just looked at the archives and I have
received all emails from the last few days except for Paul Newton's (which
shows up as suspected spam in the archive). His message and Fletcher's
consistently eggs up in my spam and I only become aware of them when
On Fri, May 3, 2019 at 5:01 PM Ed Leafe wrote:
> I got about 70 “Bounce Action Notification” messages this morning, and it
> looks like they are all from gmail accounts. So my question to gmail users:
> have you been getting posts regularly?
>
How can you tell your phone isn't working when no
On May 3, 2019, at 2:20 PM, Charlie-gm wrote:
>
> Not sure what is going on. I got a weird message the other day saying my
> account has gotten a lot of bounces.
>
> Could someone drop a note when they see this in the list (I should have
> prefixed this with [OT] or [NF] but I wanted to see
I never get Paul's or Fletcher's messages unless I go into Gmail and clear them
from span.
I got the bounces message too.
On 3 May 2019 16:27:59 GMT-04:00, Ted Roche wrote:
>I did, too. I noticed that Paul Newton posted a bunch of messages
>yesterday, and I haven't gotten them in a long time.
I did, too. I noticed that Paul Newton posted a bunch of messages
yesterday, and I haven't gotten them in a long time.
On Fri, May 3, 2019 at 4:21 PM Charlie-gm wrote:
> Not sure what is going on. I got a weird message the other day saying my
> account has gotten a lot of bounces.
>
> Could
Received the same message. Clicked on the option to stay tuned and all
seems ok
Koen
Op vr 3 mei 2019 om 22:21 schreef Charlie-gm
> Not sure what is going on. I got a weird message the other day saying my
> account has gotten a lot of bounces.
>
> Could someone drop a note when they see this in
Not sure what is going on. I got a weird message the other day saying my
account has gotten a lot of bounces.
Could someone drop a note when they see this in the list (I should have
prefixed this with [OT] or [NF] but I wanted to see if the most
"visible" target is going through).
-Charlie
I think you can also use the CAST clause to change the memo field to a
C(254) and it will export OK (truncating things beyond 254 of course )
-Charlie
On 5/3/2019 1:51 PM, Ted Roche wrote:
On Tue, Apr 30, 2019 at 1:53 PM Ted Roche wrote:
SELECT LEFT(mMemo,255) as JustText INTO CURSOR
On Tue, Apr 30, 2019 at 1:53 PM Ted Roche wrote:
> SELECT LEFT(mMemo,255) as JustText INTO CURSOR Barney
> COPY TO example.csv TYPE CSV
>
> ... if all the memos are less than 256 characters.
>
But if the memos are too long, you'll get a "String is too long to fit" if
you try to use an ALLTRIM()
It is numeric and I have to transform it to a char (fixed length) type and
do need to show the decimal point.
I use cast to change it to char(15) and then the replace function, which
did the job of removing the decimal point
select replace(cast sales as char(15),'.','') as sales from ..
What is the data type for that column? Char, VarChar, NVarchar? Or is it
numeric and you are pulling the data in a select and you do not want the
decimal point to show?
On Thu, May 2, 2019 at 5:41 PM Rafael Copquin
wrote:
> Please tell what function in TSQL can I use in the same way as
select replace('12345.67', '.', '');
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
On Thu, 2 May 2019, at 11:41 PM, Rafael Copquin wrote:
> Please tell what function in TSQL can I use in the same way as STRTRAN in
> VFP
>
> I ned to remove the point from a character expression such
Gianni, Rafael
I would definitely recommend the VFPSQL - TSQL - Mapping article. I have found
it very useful in the past.
Paul Newton
-Original Message-
From: ProfoxTech On Behalf Of Gianni Turri
Sent: 02 May 2019 23:53
To: profoxt...@leafe.com
Subject: [SUSPECTED SPAM] Re: TSQL
15 matches
Mail list logo