Re: [NF] Experience with Firebird (nee' Interbase), recommended tools?

2017-11-28 Thread Ted Roche
On Mon, Nov 27, 2017 at 3:54 PM, Eric Selje wrote: > I'm playing w/ Firebase, but that's a whole different thing. Is Firebird > still a thing? Is that the evoution of Paradox? Firebird is different from Firebase, and has nothing to do with Freebird, either. Or Mozilla. Or

[ADMIN] Fat fingers

2017-11-28 Thread Ed Leafe
Ugh - never make a change when you are focused on something else. I did just that, and created a syntax error in one of the scripts that determines if the poster is a subscriber. So anything sent to the list in the last 8 hours or so disappeared into the bit bucket. Please re-send. -- Ed Leafe

RE: [NF] Experience with Firebird (nee' Interbase), recommended tools?

2017-11-28 Thread Paul H. Tarver
Sorry, I missed the original message. On a conference call now, will put something together of what I know and will pass it along. Paul H. Tarver Email: p...@tpcqpc.com -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Friday,

Re: [NF] Experience with Firebird (nee' Interbase), recommended tools?

2017-11-28 Thread Eric Selje
I'm playing w/ Firebase, but that's a whole different thing. Is Firebird still a thing? Is that the evoution of Paradox? On Fri, Nov 24, 2017 at 12:30 PM, Ted Roche wrote: > *crickets* > > On Fri, Nov 3, 2017 at 12:01 PM, Ted Roche wrote: > > Anyone here

Re: Extra spaces in CSV file generated from VFP9SP2 when using Varchar fields

2017-11-28 Thread Gianni Turri
Hi Mike, to have that result you have put values in the vachar defined fields without trimming blanks, why? Anyway you can resolve in this way: set fields GLOBAL set fields to set fields to PseudoID = rtrim(PseudoID), Zip3, Prov03, Prov03Other = rtrim(Prov03Other), Prov06, Prov07,

[ADMIN] Posts missing

2017-11-28 Thread Gianni Turri
Hi Ed, today my posts didn't get through. What's wrong with my posts? I have sent two, in reply to "Extra spaces in CSV file generated from VFP9SP2 when using Varchar fields". Anyway, please release only the latter. Gianni ___ Post Messages to:

Re: Extra spaces in CSV file generated from VFP9SP2 when using Varchar fields

2017-11-28 Thread Gianni Turri
On Mon, 27 Nov 2017 11:43:00 -0500, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: > But when I use varchar v(N) field declarations, it appends spaces to the end > of the field values: Hi Mike, you can resolve in this way: set fields GLOBAL set fields to set fields to PseudoID =

RE: [NF] Experience with Firebird (nee' Interbase), recommended tools?

2017-11-28 Thread Paul H. Tarver
Ted, I'm sorry in advance if this is TMI, but you asked for it! :) Here are couple of articles I wrote back in the day about my FireBird experience. Essentially, the project was to create a web-based front-end system to an existing back office system written in VFP6. Having a very short time

Re: Extra spaces in CSV file generated from VFP9SP2 when using Varchar fields

2017-11-28 Thread Ted Roche
On Mon, Nov 27, 2017 at 1:10 PM, wrote: > I think there's a misunderstanding. Please tell me how using a COPY TO > MyCSVFile TYPE CSV can be manipulated with a TRIM or ALLTRIM? You *COULD* do it with the FIELDS clause, IIRC, but it's much more