Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

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

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...I have learned more through this forum than I did on a two day course. Thanks to everyone for their help and other postings that I have found useful..."

Geography

Where in the world do Tek-Tips members come from?

Need to change the description lenght in AR Invoice for items added

titoneon (MIS)
25 Jun 10 12:28
Hi,
In account receivable, when i select from the menu "Transaction", "Enter invoices/Credit Memos", "Invoices", a screen form appears ready to input or select a Cust(customer code), after i select the customer code then at the top i have some command buttons, if i press "Line Items" a new form appears where i am able to enter "Item", Quantity" and so on, what i need to do on this screen is increase the length of the Description texbox, i already increase the field Itmdesc in icitem.dbf from 60 character to 180 character but if i don't extend the length in that textbox i won't be able to type more than 60 chars ? The help i need is how can i find the prg file or the scx file to change that textbox lenght or the variable for the description, any help is very appreciated, i was trying to modify the form arposd.scx but i get access denied by the way this is SBT PRO 5.0I, i also have visual foxpro 5.0 to be able to change any file
Thanks in advance
BrianoNur (Programmer)
26 Jun 10 17:48
Titoneon,

You also have to increase the field DESCRIP (from 60 to 180) in ARTRAN and ARYTRN datafiles.

ARPOSD is the correct form you got to modify, if it is already open by another user, you will not be able to open it, that's why you get the "access denied" message.

To increase the descrip textbox width, call the properties list, go to the Format properties that is under data Tab.  Enter a K to scroll. It will be useful when you enter characters beyond the visible capacity.

You will probably need to change the InputMask property as well, from 60 to 180.

Hope that help you buddy.



 
titoneon (MIS)
28 Jun 10 9:02
Hi,
SO using vfp 5.0 i should go to the command window and type the "SET DEFA TO S:\PRO50\AR" , letter S where i mapped pro50 and then type "MODI FORM ARPOSD" that should open the form and then i can get the properties of that textbox and change it to what i need it but what happens is that of course users i am working on SBT but i am getting this message on the screen when i am trying to open the for ARPOSD, "error loading file-record number 3 LW_ARDETL <or one of his members>.Parent:Class definition SBTFORM is not found"
Do you still believe that this message is cause the form is in use ?
Thanks in advance
Ernest
BrianoNur (Programmer)
28 Jun 10 12:58
Obviously you have a configuration problem. That SBT version is old, I do not remember every detail, but here I can mentione to you some of them:

1. config.fpw   make sure it is located in the folder where SBT is.

2. Set VFP up.  
From the Tools-Option menu  select Form tab and set both "Form Set" and "Form" classes.

Pick the correct ones, otherwise you will not make it.

Hope you are getting close.

 
titoneon (MIS)
28 Jun 10 13:55
Brian,

When you said
2. Set VFP up.  
From the Tools-Option menu  select Form tab and set both "Form Set" and "Form" classes.

Pick the correct ones, otherwise you will not make it. (what where i am suppose to find here the vcx libary ? if so that should be under he Pro50 folder ? when you said "Pick the correct ones" I don't get what you mean, can you explain me ?
you know i went to the folder Pro50, and there a few SCX files, i am able to open them, the one i need to open is under "Pro50\AR" But those forms i cannot open cause i am getting the error the message i shown in my previous post, besides the users are using SBT TOO., i am confused here about "Pick the correct ones"
Any more detail help you can offer please ?
Thanks a lot and excuse me for so many questions
BrianoNur (Programmer)
29 Jun 10 10:19
Here is what you should do in your computer:

1. Close everything
2. Open VFP 5 or 6
3. Select Tools - Options - Form Tab
4. On the Template classes section, fill it up as follow:

   Form Set: sbtformset  

   how?
   4.1. click on the buton with ...
   4.2. go to the SBT 5 root folder
   4.3. look for sbt.vcx library and then select sbtformset

   Form : sbtform

   how?
   repeat same steps of point 4, but select "sbtform" instead.

Save everything.

Another important stuff is the config.fpw

You should have a config.fpw file in your PRO50 folder, try to include this line on it:
COMMAND = = (FILE("g_inilib.prg") OR FILE("g_inilib.fxp")) AND g_inilib("C")

Save it.

Close everything and restart working.


Hope you can make it this time.







 
titoneon (MIS)
30 Jun 10 10:48
I did exactly what you said wich was very easy and thanks for that, also i checked the config file wich resides in the pro50 folder and i did not have to change or add anything cause everything was as you said, i went back to my computer where i have vfp 5.0 and from the command window i typed
SET DEFA TO S:\PRO50\AR

Then

i typed modi form arposd
and still getting this message.

"ERROR LOADING FILE-record 8. lbl_x___26<or one of its members>.Parent:Class definition SBTLBLSCRCOMMENT is not found"  and the Ok button or Help button is present there to be press.
Let me clarify that S is the drive letter mapped in my computer to access the pro50 folder on the server, it is strange that when i change to "SET DEFA TO S:\PRO50" i can open other scx files in that folder but when i change to s:\pro50\ar i get the error i mentioned above, by the way every nite i copy the pro50 folder and subfolders to an external hd in just in case and it is not compressed it is a duplication of the whole SBT so i was trying to open that form arposd.scx from the G drive(the extra copy i do at night) wich is not in use by any user, i also change in foxpro option template to look for the library(as you state) in that G drive, and still i am not able to open any form in that AR folder or any other folder, the only scx files i can modfiy are the ones in the Root folder PRO50, it does not make any sense, i thou that SBT by itself have a choice to modi form(or screen) from the menu system manager ? probably i am confused with the reports that can be modified with report writer.
Sorry to bother but i am prety sure you can help me out i think we are very close.
Thanks a lot
Ernest
BrianoNur (Programmer)
6 Jul 10 13:25
Well buddy it is not easy to determine what the problem is, so you got to try several things,  here is one:

1. open the arposd class like you open a regular dbf file:

use arposd.vcx  
browse

Move the cursor onto memo fields, open it (one by one) and try to figure out what is wrong there.  I think your problem could be there, but again it is not easy to me to figure it out.  Memo field stores information about default paths or search paths, so try changing the path you see there to a specific path.

Don't forget to have backup copy, whatever the program/class you modify.

Let me know what you get after tests.
 
titoneon (MIS)
12 Jul 10 11:40
Hi Brian,
I think you meant arposd.scx ?
I checked all the memo fields and none of them have any path,
could be that the problem, if so wich memo field should be the one to point to a path ? if so in my case where the vcx files are in s:\pro50 and the AR arposd.scx is on S:\PRO50\AR, what will be the memo field that should have a path, i checked others like S:\PRO50\SO, and i don't see either a path location, of course i cannot modify the screen forms, the only place where i can modify screen are the scx located at S:\PRO50.
Thanks
BrianoNur (Programmer)
12 Jul 10 12:50
Yes, I meant arposd.scx

Open it again, same way.
Field Reserved8,  first record only, should have arposd.h on it.  I think you can also try S:\PRO50\ARPOSD.H

You try there and hope you get it this time.




 
titoneon (MIS)
27 Jul 10 15:37
Hi Brian,
I am not able to open the form at all i always get an error.
Does not make any sense, as i said if i open one of the existing form in the PRO50 folder i can open it and i can be able to modfiy it but if i change to the a subfolder located under PRO50 folder i cannot even open the form to modify it
Thanks for everything you did man.
 
PBSVic (Programmer)
10 Aug 10 5:18
I think you need to SET CLASSLIB to all the various class libraries. Then VFP will be able to locate the base classes.

The easiest way to do this is (if you have the Windows Environment Variable: SBTDUTIL=ON):
SET DEFAULT TO S:\PRO50
DO sbtw
Then quit without logging in.
With the Environment Variable, it will return you to the Command Window and not exit out of VFP5.

Or you can call G_INILIB in SBTPROC:
Either: DO g_inilib IN sbtproc.fxp
Or:
SET PROCEDURE TO sbtproc.fxp
?g_inilib()

At this point, all the appropriate class libraries will be set and you can now open all your screens by typing:
MODIFY FORM ar\arposd.

These are the libraries it sets:
S:\PRO50\SYCLIB.VCX ALIAS SYCLIB, S:\PRO50\SYCDYN.VCX ALIAS SYCDYN, S:\PRO50\SYCSLIB.VCX ALIAS SYCSLIB, S:\PRO50\SYCGRID.VCX ALIAS SYCGRID, S:\PRO50\SYCMCLIB.VCX ALIAS SYCMCLIB, S:\PRO50\SBTLIB.VCX ALIAS SBTLIB, S:\PRO50\SBTDYN.VCX ALIAS SBTDYN, S:\PRO50\SBTSLIB.VCX ALIAS SBTSLIB, S:\PRO50\SBTGRID.VCX ALIAS SBTGRID, S:\PRO50\SBTMCLIB.VCX ALIAS SBTMCLIB
 
SBTBILL (Programmer)
11 Aug 10 15:49
Don't remember if that edition but try this.

Go to System Manager.  Choose Dictionary.  Choose tables.  Enter the table name you want to modify a field in.  Modify it.

Go to System manager.  Choose System recovery. Update from data dictionary.

PRO uses the dictionary to control fields sizes.  Sounds like you are trying to use Vision Point methods.

Bill Couture
SBTBILL.COM

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!

Back To Forum

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