Inserting Data into an Access2K database

[spayne]

I am developing a program that inserts data from VFP 6.0 tables into an Access2K database using remote views. I am running into problems with text fields. The data is going in but the field doesn't trim up. For example, if I put "Red" into field "Color", whose size is twenty, there are 17 trailing spaces after the word. Some of these fields get concatenated to form sentences, so these spaces can't be there. I am using ALLTRIM, so "Red" goes in as only three characters, but it doesn't make a difference. Any ideas?

 

[jonscott8]

It's a known VFP bug:

BUG: Extra Spaces Added to Fields When Updating MS Access Table

http://support.microsoft.com/support/kb/articles/Q196/7/11.ASP

Jon Hawkins

The World Is Headed For Mutiny,
When All We Want Is Unity. - Creed

 

[ramani]

The database fields are of constant width and so the trailing spaces are present. When you want to make the sentence, you should use ALLT(color)+SPACE(1)+ALLT(shape) etc.
ramani
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com

 

[spayne]

Jon, thanks. Do you have any idea when this, if ever, will get resolved?

Ramani, unfortunately I'm not writing the code that creates the report. It's done by a program we received from another company.

Steve

 

[DEDMOD]

Sounds like you'll have to do something ugly like creating an array of variables (properly trimmed) from your table and then send those to your report. --Dave

 

[jonscott8]

Hi Steve,

I cant say for sure when, if ever, this will be resolved, for I dont know. If it were going to be fixed, it would be in the next major release, which is due out in the next few months.

Maybe someone running a VFP7 Beta can test it for you.

My thoughts are: it will still be a known issue in the next release.

Hopefully I'm wrong. Jon Hawkins

The World Is Headed For Mutiny,
When All We Want Is Unity. - Creed