×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Adjust field length: Use System Manager or do it manually?

Adjust field length: Use System Manager or do it manually?

Adjust field length: Use System Manager or do it manually?

(OP)
I need to increase the field length of the Purchase Order field reqno from 5 to 6. I was planning on doing this manually via VFP5 then I discovered that System Manager seems to have this functionality builtin under Maintain: Dictionary: Tables and Fields.
Should I use the System manager feature or just adjust these tables manually (only dbf's I found with reqno as a field) ?

sydtabl
sydflds
podblk
porecr
potran
poytrn

Note: When browsing sydtabl I discovered an error probably caused by a previous modification: The reclen field value was incorrect for pomast.dbf. An extra field had been added decades ago and the reclen was greater than the true record length. Wonder if it has caused any problems? Nothing comes to mind.

Trey

Trey Harris
hdb
Houston

RE: Adjust field length: Use System Manager or do it manually?

The System Manager should be used for this purpose. Correct on all tables. Important to include history tables.
In case you need to rebuild the tables, your table modifications will not be over written.
Edgar

Edgar
Integrated Bar Code Systems, Inc.

RE: Adjust field length: Use System Manager or do it manually?

Sydtbl- How SBT keeps track of SBT tables. You can add external tables to SBT. (Always do it through System manager). Do not modify this table unless you know what you need to accomplish.

Sydflds- How Sbt keeps tracka of fields within SBT tables. You can add or modify fields. Do not modify this table unless you know what you need to accomplish.

Edgar

Edgar
Integrated Bar Code Systems, Inc.

RE: Adjust field length: Use System Manager or do it manually?

(OP)
Thank you!

I also notice that System Manager/Maintain/Dictionary/ adds 1 to the sum of all field len's. Curious...

Trey Harris
hdb
Houston

RE: Adjust field length: Use System Manager or do it manually?

(OP)
Next issue: I have adjusted the textbox inputmask, left positions and lengths in the forms that have the field reqno: poblnd.scx, poposd.scx, porecd.scx and porecr.scx and all is good, i.e. I can enter 7 character requisition numbers now.

I have also modified porept.prg, searching for "reqno" I increased the init to SPACE(7) and changed the PICTURE clause from 5 "!" to 7 "!" on all found snippets like

CODE -->

@ ln_line, 57 GET lc_reqno PICTURE "!!!!!!!" 

When I run a report, Detail Receipts, for example, I can enter 6 characters into the Requisition No. grid option, not 7. (I had increased the field to 6 from 5 earlier, today I increased it to 7.)

I cannot find where this option width is determined. I assumed it was the PICTURE clause.

What am I missing?

My apologies if I should start a new topic. I will if need be.

Trey Harris
hdb
Houston

RE: Adjust field length: Use System Manager or do it manually?

(OP)
OK I must not understand the System Manager/Maintain/Dictionary process. The sydflds.dbf shows lengths of 7 for field reqno. But the files themselves, e.g., potran.dbf, did not get the field length of reqno changed. They are still at length 6, from when I had changed them to 6 manually the other day.

So now I see in System Manager/Transaction/System recovery/Update from Data Dictionary. I guess this is the "Commit" button to whatever I had entered via Maintain/Dictionary ?

I clicked the Update from Data Dictionary and chose my company and just PO files. That seems to have lengthed reqno to 7 characters.

But still, in the report grid, I can only enter 6 characters for Requisition Number...

Trey Harris
hdb
Houston

RE: Adjust field length: Use System Manager or do it manually?

(OP)
Well what a silly goose am I! I did not have Compile Before Saving set. After a compile, porept.prg allows 7 characters in the report options grid field for reqno. Just like I told it to in the PICTURE clauses.
Thanks for being patient with me.

Trey Harris
hdb
Houston

RE: Adjust field length: Use System Manager or do it manually?

Hi,
In Order to take effect, you must run from System Manager :
Transactions
System Recovery,
Update from Dictionary

Also, You need to increase the dictionary picture clause from the field you are increasing.
Some forms( using arrays), look at the dictionary for the picture clause.

Edgar

Edgar
Integrated Bar Code Systems, Inc.

RE: Adjust field length: Use System Manager or do it manually?

(OP)
Thanks, Edgar. I did adjust the dictionary picture clauses as well. Thanks for responding to me. It's a wonder there are still SBT people around. A testament to the great system it is!

Trey Harris
hdb
Houston

RE: Adjust field length: Use System Manager or do it manually?

Can anyone help me in getting my data back from my Seagate HD, There are many freeware on the internet, the one tool which was recommended to me was Recoverit Data Recovery Tool, is there any othersoftware similar to this which is free.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close