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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

captsnappy

Programmer
Feb 19, 2009
107
US
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
 
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.
 
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.
 
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
 
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
 
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
 
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
 
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.
 
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top