Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating CA - Too Much Schema
Message
From
06/11/2003 18:03:06
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00847340
Message ID:
00847420
Views:
23
>
>I am not sure I understand your question. You can use the CAs created by my builder to call SPs for the SelectCmd and the other *Cmd properties. You would just need to change the code in the _ca_dmlcode method of each CA so your *Cmd code to call the SPs will be used. You also would need to set the lAutoGenerate property to false in the _ca_base class.
>
>One of these days, I hope to add basic the code needed to call SPs to the CAs created by my builder.

You have the meaing correct. Thanks. There seems to be some difficulty (probably in my understanding.. duh) on what I should be doing. Here is what I have done:

1) DO CABUILDER.PRG
2) DATABASE TYPE: SQL Server
3) INTEGER WIDTH: (default)
4) CLASS NAME: (default)
5) DIRECTORY: \TEST
6) SOURCE TYPE: ODBC
7) PREFIX: (default)
8) GENERATE NEW VCX FOR EACH TABLE
8) FIELDS TO EXCLUDE: leave blank, just a test SQL Database.Table

*-- note: I am not able to access the stored procedures area: it is all disabled

9) Click Build. SQL Server Login window shows

10) Click Options
11) Identify Database

At this point I get an error 1474 or 1476. This is regardless of any setting/combination I use on login, database, etc...
Am I missing something?

Thanks.

Ric
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform