Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A DEClass problem...
Message
 
 
To
10/11/2003 15:18:10
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00848461
Message ID:
00848464
Views:
11
Don't make your DataSource a character string. If you are putting this in the property sheet, precede the porperty holding the handle with an equal sign and put no quotes around the property name:

=glo_numMyHandle

>Hi all,
>
>I have been on UT for the last few days working through CA and DE classes and reading all of the realated threads. The CABuilder by Mark McCasland has been great (and so has his help). So, this is a big thanks for all of that help!!!
>
>Now, I am thinking there is one small thing missing, but not sure... I understand that I now have to handle all of my connections.
>
>The CaClass (from the CABuilder) I am using has properties set:
>
DataSource = 'glo_numMyHandle'
>DataSourceType = 'ODBC'
>
>The DEClass has the above CA object in it. The DEClass has properties set:
>
DataSource = 'glo_numMyHandle'
>DataSourceType = 'ODBC'
>
>So, I created a blank form. In myform.load() I have the following code:
>
>I set the properties of MyForm:
>
DEClass = 'myCABulderDataTest'
>DEClassLibrary = 'C:\_CATest.vcx'
>
>
*-- myform.load()
>PUBLIC glo_chrMyDSN, glo_numMyHandle
>glo_chrMyDSN = 'DSN=MyDataDSN'
>glo_numMyHandle =SQLSTRINGCONNECT(glo_chrMyDSN)
>
>
>When I run the form, it is coming up with 'alias not found'. Using AERROR(), the error is 'Connection Handle Invalid'. However, checking on the value of 'glo_numMyHandle', it is a one. Can someone help here as I don't know where this error is coming from.
>
>TIA
>
>Ric
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform