Index
2014-10-12 08:31Man-wai Chang : Changing field type from General to Memo
2014-10-12 08:57Allen : RE: Changing field type from General to Memo
2014-10-12 09:10Tracy Pearson : Re: Changing field type from General to Memo
2014-10-12 09:14Man-wai Chang : Re: Changing field type from General to Memo
Back to top
Changing field type from General to Memo

Author: Man-wai Chang

Posted: 2014-10-12 08:31:02   Link

According to http://fox.wikis.com/wc.dll?Wiki~VFPDataTypes

create table ttt ( f1 g )

append blank

append general f1 from temp.txt

use

ll = fopen("F:\ttt.dbf",12)

fseek(ll,43)

fwrite(ll,'M')

fclose(ll)

It didn't work. When I USE ttt and DISPLAY STRU, it's still a General field.

What's wrong with the sample codes?

--

.~. Might, Courage, Vision. SINCERITY!

/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)

/( _ )\ http://sites.google.com/site/changmw

^ ^ May the Force and farces be with you!

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CAGv=MJDSAA3chYv++5FE2vWeURzGBh_ZSLjEDZhgxumW_D2rLg@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2014 Man-wai Chang
Back to top
RE: Changing field type from General to Memo

Author: Allen

Posted: 2014-10-12 08:57:13   Link

Could it be changes in the tables between VFP versions.

Al

-----Original Message-----

From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Man-wai

Chang

Sent: 12 October 2014 15:31

To: profoxtech@leafe.com

Subject: Changing field type from General to Memo

According to http://fox.wikis.com/wc.dll?Wiki~VFPDataTypes

create table ttt ( f1 g )

append blank

append general f1 from temp.txt

use

ll = fopen("F:\ttt.dbf",12)

fseek(ll,43)

fwrite(ll,'M')

fclose(ll)

It didn't work. When I USE ttt and DISPLAY STRU, it's still a General field.

What's wrong with the sample codes?

---

This email is free from viruses and malware because avast! Antivirus protection is active.

http://www.avast.com

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/001501cfe624$6dcfcda0$496f68e0$@com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2014 Allen
Back to top
Re: Changing field type from General to Memo

Author: Tracy Pearson

Posted: 2014-10-12 09:10:21   Link

On October 12, 2014 9:31:02 AM EDT, Man-wai Chang <changmw@gmail.com> wrote:

> According to http://fox.wikis.com/wc.dll?Wiki~VFPDataTypes

>

> create table ttt ( f1 g )

> append blank

> append general f1 from temp.txt

> use

> ll = fopen("F:\ttt.dbf",12)

> fseek(ll,43)

> fwrite(ll,'M')

> fclose(ll)

>

> It didn't work. When I USE ttt and DISPLAY STRU, it's still a General

> field.

>

> What's wrong with the sample codes?

Are you sure you opened the low level with write privileges? Fwrite will not error, it will return 0. My testing in VFP9 works.

--

Tracy

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/EE738702-E206-498E-9145-E3A071D3B6D7@powerchurch.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2014 Tracy Pearson
Back to top
Re: Changing field type from General to Memo

Author: Man-wai Chang

Posted: 2014-10-12 09:14:33   Link

Never mind, I didn't notice "f:\" in "f:\ttt.dbf" when I cut-and-paste

the codes.

Sorry!! :)

On Sun, Oct 12, 2014 at 9:57 PM, Allen <profox@gatwicksoftware.com> wrote:

> Could it be changes in the tables between VFP versions.

>

> From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Man-wai

> ll = fopen("F:\ttt.dbf",12)

--

.~. Might, Courage, Vision. SINCERITY!

/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)

/( _ )\ http://sites.google.com/site/changmw

^ ^ May the Force and farces be with you!

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CAGv=MJDQfCRrNvZRdvw_eo6uLYY2f=J_uvLAiWW3E66VuuDfMA@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2014 Man-wai Chang