Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bernard Bout
  Where is Bernard Bout?
 Brisbane
 Australia
 Bernard Bout
 To: joe Gonzalez
  Where is joe Gonzalez?
 
 Philippines
 joe Gonzalez
 Tags
Subject: RE: 255 char length of CA's and other tips
Thread ID: 49019 Message ID: 50913 # Views: 6 # Ratings: 0
Version: Visual FoxPro 8 Category: Projects and Design
Date: Tuesday, September 07, 2004 6:05:59 AM         
   


Unfortunately this method will not always work. You will be able to create the schema but it will be truncated as you have found. Also if you ever open a CA in the builder created like this, you will get errors as the builder actually instantiates the CA and actually makes a connection to the Database when you click on "Build"

The CA builder can be adapted but will take much more than just changing the save code. Also it does not display VIEWS from the Database.

The better solution is to use the builder found at www.mctweedle.com and then adapt it to your use. This builder can create CA's without regard to the size of the property limit. Also it will create a CA for every table ( and in my case after I changed the code VIEW) in the SQL Database and this is done in a few seconds. It would take hours to do using the builder supplied by MS. If you require the ability to drag and drop fields, then there is also a PRG that will create dummy tables that you can attach to the DE for dragging and then remove when actually using the CA's.

I advise you to try this out. Until VFP9 is out, this is the best way and considering the speed factor, I would still use it even post VFP9.



> Hi Boudewijn,
>
> Thanks for the info, am now able to make schemas longer than 255 chars.
>
> But when i save the form, only 255 chars seem to get saved, cutting the schema at the end
> and producing an error when the form is modified. I tested this by looking at the contents of the
> sct/scx form file memo field. any ideas regarding this?
>
> Thanks again,
>
>
> Joe Gonzalez
>
>


ENTIRE THREAD

255 char length of CA's and other tips Posted by Boudewijn Lutgerink @ 8/13/2004 9:48:55 AM
RE: 255 char length of CA's and other tips Posted by joe Gonzalez @ 9/6/2004 6:42:38 PM
RE: 255 char length of CA's and other tips Posted by Bernard Bout @ 9/7/2004 6:05:59 AM
RE: 255 char length of CA's and other tips Posted by joe Gonzalez @ 9/8/2004 6:03:54 PM
RE: 255 char length of CA's and other tips Posted by Boudewijn Lutgerink @ 9/9/2004 9:42:52 AM
RE: 255 char length of CA's and other tips Posted by Bernard Bout @ 9/10/2004 8:41:03 AM