Has anyone on this list used xCase by Resolution, Inc.?
The package is very powerful for building a data base model but how do I export it as a Foxpro database to my VFP project? There is not much tutorial help for using this program. The only demo I found on their web site did not agree with the menus in my program.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/700BC72F214A46E689666D8E2540C229@dual
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
On Fri, Oct 1, 2010 at 5:31 PM, Nicholas Geti <ngeti@optonline.net> wrote:
> Has anyone on this list used xCase by Resolution, Inc.?
Sure. I wrote the review of in FoxPro Advisor a long, long time ago.
And I've used every version since. The most recent, not so much.
> The package is very powerful for building a data base model but how do I export it as a Foxpro database to my VFP project? There is not much tutorial help for using this program. The only demo I found on their web site did not agree with the menus in my program.
What version are you running?
I haven't used it with DBFs in a long time. With MySQL, it uses ODBC.
IIRC, it includes a VFP app you run. Poke around the xCase
directories...
You should also try their support email address, perhaps
support@xcase.com? I've had my questions answered promptly over the
years.
--
Ted Roche
Ted Roche & Associates, LLC
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/AANLkTikimz5Yrpz7UV774PfpFkhEHHzOj8wMfgtbe4iK@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
We used it back in 1998-98 when we were redesigning our database from the original dos database from around 1988 to a
completely different design with primary keys, foreign keys, etc. It was good because it allowed us to see over 100
dbf's and how they were connected. We used it several times since for documentation. The last version we used was 7.5
around 2004. I would recommend it for anyone who wants visual documentation of their system.
We are still looking for a product that would allow us to send out an update which would convert all our VFP9 SP2
dbf/dbc data tables to PostgreSQL without any manual effort on the part of our clients. The newest version of xcase
seems to be able to do the conversion, but it would require a support person onsite to do it. We have thousands of
licensed users and it is not possible to have a support person do the conversion - it must be automated.
----- Original Message -----
From: "Nicholas Geti" <ngeti@optonline.net>
To: <profox@leafe.com>
Sent: Friday, October 01, 2010 2:31 PM
Subject: xcase question
Has anyone on this list used xCase by Resolution, Inc.?
The package is very powerful for building a data base model but how do I export it as a Foxpro database to my VFP
project? There is not much tutorial help for using this program. The only demo I found on their web site did not agree
with the menus in my program.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/086a01cb6247$d1580dc0$7a00a8c0@w2k3s02
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
I am running the latest version, xCase Professional, 9.1
I got one answer (Synchronize Database) from Elie but it was not helpful. I
ran the command to build a DBC using the Tastrade example in xCase but I
couldn't figure out where it stored the result. I was looking for a pure VFP
database (.DBC, .DBF, etc) tables. Not the dozens of xCase DBFs that control
the model.
I created my own model but xCase would not let me run the Synchronize
command because the tables are empty. How do I enter data into the tables?
The menus want to connect to an ODBC source but this seems counterintuitive.
It implies I need to now set up a data source in some other language which
looks like twice the effort.
The early versions of xCase could create VFP data base directly whether
there was data in the model or not.
----- Original Message -----
From: "Ted Roche" <tedroche@gmail.com>
To: <profox@leafe.com>
Sent: Friday, October 01, 2010 7:57 PM
Subject: Re: xcase question
> On Fri, Oct 1, 2010 at 5:31 PM, Nicholas Geti <ngeti@optonline.net> wrote:
>> Has anyone on this list used xCase by Resolution, Inc.?
>
> Sure. I wrote the review of in FoxPro Advisor a long, long time ago.
> And I've used every version since. The most recent, not so much.
>
>> The package is very powerful for building a data base model but how do I
>> export it as a Foxpro database to my VFP project? There is not much
>> tutorial help for using this program. The only demo I found on their web
>> site did not agree with the menus in my program.
>
> What version are you running?
>
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/E93699190792449DBE48C17581FF3D17@dual
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
This latest version no longer has a separate version for VFP. It has been
merged with the Professional version. I haven't found a separate VFP app.
> I haven't used it with DBFs in a long time. With MySQL, it uses ODBC.
> IIRC, it includes a VFP app you run. Poke around the xCase
> directories...
>
> --
> Ted Roche
> Ted Roche & Associates, LLC
>
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/B29887C69B5C4929BF5CB863B701C786@dual
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
On Mon, Oct 4, 2010 at 9:43 AM, Nicholas Geti <ngeti@optonline.net> wrote:
> I am running the latest version, xCase Professional, 9.1
I am running Version 8. Opening the TasTrade model, I can go to the
Model menu, DBC and Free Tables options, and set the locations for the
tables. I set the paths for the DBC and Free tables to C:\temp, and
then follow the prompts on the Database menu tab, "Synchronize
DataBase with Model...", All, OK, and "Syncronize" <sic> on the dialog
to generate all of the tables, indexes and database files. Worked for
me. Are those options no longer available?
> The early versions of xCase could create VFP data base directly whether
> there was data in the model or not.
--
Ted Roche
Ted Roche & Associates, LLC
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/AANLkTik0PweZ4FAOPiqs=ybsmUpGi+tEzvWynH+WCW6c@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Thank you. I got it to work. I had to carefully read the help for each of
the fields on the menu since the language was somewhat obscure as to which
fields were the target and which were the input xCase files.
The menu defaults pointed to the incorrect locations for the Tastrade model.
Once I fixed that I got it working correctly.
Now the question is why doesn't xCase permit building a VFP database when
the models tables are empty.
----- Original Message -----
From: "Ted Roche" <tedroche@gmail.com>
To: <profox@leafe.com>
Sent: Monday, October 04, 2010 10:50 AM
Subject: Re: xcase question
> On Mon, Oct 4, 2010 at 9:43 AM, Nicholas Geti <ngeti@optonline.net> wrote:
>
>> I am running the latest version, xCase Professional, 9.1
>
> I am running Version 8. Opening the TasTrade model, I can go to the
> Model menu, DBC and Free Tables options, and set the locations for the
> tables. I set the paths for the DBC and Free tables to C:\temp, and
> then follow the prompts on the Database menu tab, "Synchronize
> DataBase with Model...", All, OK, and "Syncronize" <sic> on the dialog
> to generate all of the tables, indexes and database files. Worked for
> me. Are those options no longer available?
>
> --
> Ted Roche
> Ted Roche & Associates, LLC
>
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/8C26F6DEA4B74EDA9F8B63A3E13C2176@dual
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
OK. Further testing of file locations solved the problem. I just set all
field locations to C:\temp and xCase built the .DBC and .DBFs correctly
without having to fill the tables with data.
----- Original Message -----
From: "Ted Roche" <tedroche@gmail.com>
To: <profox@leafe.com>
Sent: Monday, October 04, 2010 10:50 AM
Subject: Re: xcase question
> On Mon, Oct 4, 2010 at 9:43 AM, Nicholas Geti <ngeti@optonline.net> wrote:
>
>> I am running the latest version, xCase Professional, 9.1
>
> I am running Version 8. Opening the TasTrade model, I can go to the
> Model menu, DBC and Free Tables options, and set the locations for the
> tables. I set the paths for the DBC and Free tables to C:\temp, and
> then follow the prompts on the Database menu tab, "Synchronize
> DataBase with Model...", All, OK, and "Syncronize" <sic> on the dialog
> to generate all of the tables, indexes and database files. Worked for
> me. Are those options no longer available?
>
>> The early versions of xCase could create VFP data base directly whether
>> there was data in the model or not.
>
> --
> Ted Roche
> Ted Roche & Associates, LLC
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/93DD1441841C4C90A456AC4A091C83B5@dual
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.