Hi Ted,
Running CTOV(somecursor) certainly TRIMs the varchar columns (browse the
cursor and print LEN(somevarcharcolumn)). It looks like _VFP.DataToClip()
is repadding.
I'll try something else.
Laurie
On 17 July 2015 at 16:06, Ted Roche tedro...@gmail.com wrote:
Laurie:
On Fri, Jul 17,
Hi Ted,
This seems to work:
LOCAL lcc As String
SET SAFETY OFF
SELECT * FROM table WHERE something INTO CURSOR tmp
COPY TO tmptxt.txt TYPE CSV
lcc = FILETOSTR(tmptxt.txt)
lcc = STRTRAN(lcc, ,, CHR(9)) replace commas with tabs
_CLIPTEXT = lcc
STRTOFILE(_CLIPTEXT, tmptxt.txt, 0)
MODIFY FILE
Have you tried comparing LUPDATE() on the server and the local tables?
Laurie
On 17 July 2015 at 20:16, mbsoftwaresoluti...@mbsoftwaresolutions.com
wrote:
Ken Dibble -- I never saw my original show up either. Let's try this
again.
Say I've got tables on a server that are lookup libraries,
Just keep a list of the aliases you used when you opened the tables, say
in an array aTables, or a collection,and when you want to close them
iterate through the list and do something like:
for i = 1 to alen(aTables, 1)
use in select(aTables[i])
endfor
If the alias is opened, it'll close it.
I don't wanna offend anyone, but are you sure that your framework is PERFECTO?
How many expert Foxpro programmers had tested your framework? :)
On Sat, Jul 18, 2015 at 11:13 PM, Ken Dibble krdib...@stny.rr.com wrote:
My query class does keep such a list. I wrote the framework code about ten
Hi Ted,
Here's another version which gets round the problem of embedded commas:
#DEFINE CTAB CHR(9)
#DEFINE CRLF CHR(13)+CHR(10)
LOCAL lcc As String, i As Integer, n As Integer
SET SAFETY OFF
SELECT * FROM table WHERE somewhere INTO CURSOR tmp
*!* Trim varchar fields if required
*!* CTOV(tmp)
for i = 1 to alen(aTables, 1)
use in select(aTables[i])
endfor
If the alias is opened, it'll close it. If not, no errors or anything
will happen, it will just continue. No type checking or any further
complication required.
My query class does keep such a list. I wrote the framework code
Just got another one.
You will see, in the code I've included below, that I am almost to the
point of just eating and ignoring this error, because it makes absolutely
no sense that it occurs. But such a strategy seems to me to be dangerous
and foolhardy, so:
At the risk of thoroughly
HI Ken,
Just a thought.
I didn't read through all of your code, but I did read your stack trace listing
with comments.
It appears that you have a path j:\cildata2\... for data, and another c:\cil
data 2\... for your programs. I don't see any evidence of any double quotes
around paths that
Just a thought.
I didn't read through all of your code, but I did read your stack
trace listing with comments.
It appears that you have a path j:\cildata2\... for data, and
another c:\cil data 2\... for your programs. I don't see any
evidence of any double quotes around paths that
On Jul 18, 2015, at 12:35 PM, Ken Dibble krdib...@stny.rr.com wrote:
Thank you. That post finally arrived!
Posts are limited to 32KB, and yours was way over, so it was held until I could
review it. In the future long blocks of code are best pasted to service like
codpaste.net.
-- Ed Leafe
On Fri, Jul 17, 2015 at 2:31 PM, Ken Dibble krdib...@stny.rr.com wrote:
For some definition of fine and some definition of plain text.
All email is encoded in some fashion.
If you use a device or a service that inserts UTF-8 or some other
double-byte encoding, or HTML-like punctuation
I don't wanna offend anyone, but are you sure that your framework is PERFECTO?
How many expert Foxpro programmers had tested your framework? :)
Huh?
The framework was developed for a specialized purpose specific to the
industry I work in. It's not a general-purpose framework. It's not
for
On 2015-07-18 04:24, Laurie Alvey wrote:
Have you tried comparing LUPDATE() on the server and the local tables?
It's a MySQL table on the server, so LUPDATE is not an option.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
And below is how my email client rendered your response. :)
I didn't post a plain text file because my go-to
for simple word processing tasks is WordPad. (I
don't like Notepad because it doesn't persist any
of my preferences. Wordpad by default supplies
margins. Wordpad can't persist tab
At 06:38 PM 7/18/2015, you wrote:
On Jul 18, 2015, at 12:35 PM, Ken Dibble krdib...@stny.rr.com wrote:
Thank you. That post finally arrived!
Posts are limited to 32KB, and yours was way over, so it was held
until I could review it. In the future long blocks of code are best
pasted to
16 matches
Mail list logo
