Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert Memos dialog box.

Status
Not open for further replies.

MrSatan

Programmer
Jul 16, 2002
25
AU
Hi All,

By using Visual FoxPro 6.0 to open a dBaseIV table which contains the memo fields, a Convert Memos dialog box will pop up to prompt "Convert MEMO file to Visual FoxPro format?...", by pressing the Yes button, another dialog box will pop up to prompt "Remove dBASE 'soft' carriage returns from memos?..."

Is there a way to suppress all these pop up dialogs and default the prompting to "Yes"...?

Thanks in advance.
 
I think you want to use the SET COMPATIBLE Command

Try:
SET COMPATIBLE DB4 NOPROMPT

There are other options, check out the help if this fails you...

Brian
 
Thank you for your help Brian,

In fact, the command you suggested did knock down the first dialog box. I still try to kill the second (last) one "Remove dBASE 'soft' carriage returns from memos?..."

Any more suggestion will be much appreciated...:)

Thanks.
 
In a COPY of your table try:

repl all MyMemo with STRTRAN(MyMemo,CHR(141)+CHR(10), chr(13))


This assumes than CHR(141)+CHR(10) is a soft return, which I'm not sure of...

Brian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top